Skip to content

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.

N9248DTischer Energy LLC · Colleyville, TXBuilt 2012 · S/N T20609076 N9248PPajaro Jaison · Burtonsville, MDBuilt 1966 · S/N 24-4627 N924BKSolutions North Bank · Stockton, KSBuilt 2025 · S/N T20609797 N924CCSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1966 · S/N 27-3490 N924CKTexas Air Machines LLC · Corpus Christi, TXBuilt 2016 · S/N T20609252 N924DCAirmann Leasing LLC · Mount Sterling, KYBuilt 1996 · S/N 4636057 N924RRHigh Timothy Duane · Glenwood, MOBuilt 1977 · S/N 32R-7780450 N924TM & B Aviation LLC · Wake Forest, NCBuilt 2010 · S/N 4636466 N924TFRegistered aircraftBuilt 1996 · S/N 27-0218 N9250PBas Part Sales LLC · Greeley, COBuilt 1967 · S/N 24-4747 N9251PSalori Aviation LLC · Centralia, MOBuilt 1967 · S/N 24-4749 N92521G&J Myles Aviation LLC · Owens Cross Roads, ALBuilt 1995 · S/N 4622191 N9252POsipov Yuri A · Lomita, CABuilt 1967 · S/N 24-4750 N9253CJetstream LLC · River Forest, ILBuilt 1995 · S/N 4622183 N9253PConway Brandon · Springtown, TXBuilt 1967 · S/N 24-4751 N9255PSalvia Michael · Farmington Hills, MIBuilt 1968 · S/N 24-4754 N9257NJohn Bowman Inc · Fountain, COBuilt 1995 · S/N 4636006 N9258PCessna 79432 LLC · Missoula, MTBuilt 1968 · S/N 24-4757 N9259PChiarini Joshua · Cranston, RIBuilt 1968 · S/N 24-4758 N925BFSandin Robyn · Mc Donald, TNBuilt 2000 · S/N T20608232 N925DBHawk2lane LLC · Newark, DEBuilt 2005 · S/N T18208366 N925LDRegistration Pending · Carson City, NVRegistration pendingBuilt 2016 · S/N T20609242 N925LLSutton-Gee Ryan · Lafayette, CABuilt 2025 · S/N T18209174 N925RAJoe R Jones Construction Inc · Weatherford, TXBuilt 2012 · S/N T20609041 N925TCJarvis Bradley A · North Port, FLBuilt 1981 · S/N 32R-8129013 N9260PRichter Scott J · Eden Prairie, MNBuilt 1996 · S/N 4636044 N9262GChampion Med LLC · Dover, DEBuilt 1995 · S/N 4636017 N9262PReliant Aeroworks LLC · Sanger, TXBuilt 1968 · S/N 24-4761 N9262YTwin Star Montana LLC · Kalispell, MTBuilt 1984 · S/N 31P-8414033 N9263KCrook Michael J · Paradise, UTBuilt 1976 · S/N 32R-7680205 N9263PWhitacre John B III · Waynesburg, OHBuilt 1968 · S/N 24-4762 N9264PBeil Richard P Trustee · Caroline, WIBuilt 1968 · S/N 24-4763 N9267PNickravesh Niknam J · San Jose, CABuilt 1968 · S/N 24-4767 N9268PAts Inc · Chicago, ILBuilt 1968 · S/N 24-4768 N926ETWestern Farming LLC · Missoula, MTBuilt 2008 · S/N T20608886 N926HBAwmr LLC · Conroe, TXBuilt 1975 · S/N 317552007 N926JDJosephs Howard I · Edgartown, MABuilt 2007 · S/N 4636422 N926SLNt Aviation LLC · Wichita, KSBuilt 2008 · S/N T20608902 N9270PPenn Landmark Corp · Pinehurst, NCS/N 24-4770 N92714Registered aircraftBuilt 1996 · S/N 4636042 N92728Washington International Aviation LLC · Washington, DCBuilt 1996 · S/N 4636050 N9272PH&R Aircraft LLC · Kansas City, MOBuilt 1968 · S/N 24-4772 N9272YIal Corp · Lewes, DEBuilt 1984 · S/N 31P-8414039 N9274PMurray John F · Crystal Lake, ILBuilt 1968 · S/N 24-4774 N92765N92765 Inc Trustee · Wilmington, DEBuilt 1996 · S/N 4636070 N9276PHansen Stephen J · Redmond, WAS/N 24-4776 N9279PArdis Mitchell Farm LLC · Winnsboro, TXBuilt 1968 · S/N 24-4780 N927DMGoat Rancho LLC · Euless, TXS/N 32-40225 N927PCBillington Seabird LLC · Norman, OKBuilt 2006 · S/N T18208624 N927PTReds Asset Managers LLC · Pottsville, PABuilt 1976 · S/N 27-7754008

Back to AD 71-13-01 R1