Registered aircraft · 6,916

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:71-13-01-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:71-13-01-R1') ORDER BY n_number

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:71-13-01-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:71-13-01-R1')
  ORDER BY n_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:71-13-01-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:71-13-01-R1')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N495KBWipaire Inc · South Saint Paul, MNBuilt 2011 · S/N GA8-TC 320-11-168 N495MAZero G Aviation LLC · Helena, MTBuilt 2010 · S/N 4636484 N495PMDmfs Leasing LLC · Des Moines, IABuilt 2025 · S/N 4636871 N495WFWalters Steven M · Marathon, FLBuilt 1995 · S/N 3213097 N4960250 Inc · Washington, DCS/N 24-4025 N4960FLc Aviation LLC · Fort Meade, FLS/N 32-7640123 N4966FDj&A Enterprises LLC · Sevierville, TNBuilt 1976 · S/N 32R-7680494 N496VBerkenkotter Transportation LLC · Howard, COBuilt 2006 · S/N T18208592 N496WWNational Aircraft Leasing Corporation · Greenville, DEBuilt 2009 · S/N T20608912 N4976WQualitair LLC Trustee · MichelstadtBuilt 1977 · S/N 14296 N497MAAlexandria Spine & Rehab Center LLC · Alexandria, LAS/N 4636498 N497MSN497ms LLC · Miami, FLBuilt 2015 · S/N 4636678 N4981WJahn Kenneth Kris · Shingle Springs, CABuilt 1977 · S/N 14301 N4983WPappa Whiskey Victor LLC · Brandon, MSBuilt 1977 · S/N 14303 N498MMLadd Air LLC · Mt Holly, NCS/N 4636149 N4995WAnderson Ryan L · Wadena, MNS/N 14315 N499FCFoxtrot Charlie Aviation LLC · Charlotte, NCBuilt 1976 · S/N 32R-7780076 N49BMHarriman Aviation LLC · Pearland, TXBuilt 1977 · S/N 27-7754077 N49DSSalinger David L · Verdi, NVBuilt 1998 · S/N 27-0251 N49FMRockin R&L Ranch · Kaufman, TXBuilt 1999 · S/N 27-0260 N49LBOwen Walter M · Arlington, TNBuilt 1976 · S/N 32R-7680481 N49RDDziak Chester · Jackson, MIBuilt 1966 · S/N 27-3192 N49WZOlson Vern · Woodinville, WABuilt 2026 · S/N T20609837 N49XLQualitair LLC Trustee · MichelstadtBuilt 1989 · S/N 4622049 N4AVSouthwest Aircraft LLC · Fairacres, NMBuilt 1949 · S/N NAV-4-1844 N4DRTotah John E · Kailua Kona, HIBuilt 1966 · S/N 27-3175 N4DWFlycone LLC · Encinitas, CABuilt 2025 · S/N 4636864 N4EPPilots Landing Aviation LLC · Lampasas, TXBuilt 1979 · S/N 70032 N4JBMy Airplane LLC · Sheridan, ARBuilt 2024 · S/N T20609775 N4QSPonderosa Aviation LLC · Safford, AZBuilt 1968 · S/N 1755-1 N4SGCp Aero LLC · Missoula, MTBuilt 2002 · S/N 3257282 N4VSAircraft Montana LLC · Helena, MTBuilt 1974 · S/N 27-7405426 N4WBBe Positive Holdings LLC · Bloomsburg, PABuilt 1977 · S/N 32R-7880018 N5003LGlobal Aero Solutions LLC · Wilmington, DES/N T20608903 N5008AWings Like Eagles LLC · Wilmington, DES/N 27-3695 N500DYEnterprise Aircraft Finance LLC · Clayton, MOBuilt 2025 · S/N 4636865 N500EGElliott Candice H Brown · Santa Rosa, CABuilt 1974 · S/N 27-7405453 N500GWFeldtman Enterprises Inc · Wilmington, DEBuilt 1964 · S/N 1476-170 N500HMTalos Aviation Group LLC · Blackstone, VABuilt 1973 · S/N 3155 N500HRDese Enterprises LLC · Huntsville, ALBuilt 1981 · S/N 318152133 N500LCCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1979 · S/N 27-7954060 N500NMGriffin Medical LLC · Sidney, NEBuilt 2011 · S/N 4636500 N500QSanborn Map Co Inc · Colorado Springs, COBuilt 1973 · S/N 31-7300934 N500TADouble 00 Investments LLC · Shaw, MSBuilt 2018 · S/N T20609531 N500TDPacific Fleet Aviation LLC · Rochester, NYBuilt 1977 · S/N 27-7854027 N50101Bas Part Sales LLC · Greeley, COBuilt 2008 · S/N T20608899 N5014TGalati David R · Sebring, FLBuilt 1972 · S/N 32-7240098 N5015HKnox Fred · Los Altos, CABuilt 2001 · S/N T18208096 N501BCJamestown Jet Center Inc · Jamestown, NDBuilt 1973 · S/N 27-7305157 N501BTCloud Chasers LLC · Columbus, MSBuilt 1976 · S/N 32R-7780039

Back to AD 71-13-01 R1