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.

N9218YHubble Boeing Development Corp · Gallipolis, OHBuilt 1968 · S/N 31-282 N9219PChrastka Keith · San Angelo, TXBuilt 1967 · S/N 24-4715 N921CBDavis David G · Cresson, TXFirst renewal noticeBuilt 1980 · S/N 32R-8129019 N921JBC&Z Aero LLC · Des Plaines, ILBuilt 1976 · S/N 32R-7780099 N921KMLo Aircraft LLC · Key West, FLBuilt 2019 · S/N 4636741 N921KSWilliams Scott Thomas · Lake Havasu, AZBuilt 2006 · S/N T20608693 N921LSNg Research · Manassas, VAS/N T20608976 N921PJbt Legacy LLC · Ocklawaha, FLBuilt 2025 · S/N T20609814 N921RTAd Aviation LLC · Billings, MTBuilt 2018 · S/N 4636725 N921UN921un Ventures LLC · Mercer Island, WABuilt 2004 · S/N T20608501 N9220PDavid Rever Aviation LLC · Dewey Beach, DEBuilt 1967 · S/N 24-4716 N9221PStevenson Tom · Portland, ORBuilt 1967 · S/N 24-4718 N9222PAztec Remains LLC · Potosi, WIBuilt 1967 · S/N 24-4719 N9224PAnde Leasing Co LLC · Edgewood, NMS/N 24-4721 N9224YFavret Bernard A · Ocean Springs, MSBuilt 1983 · S/N 31P-8414012 N9225PRegistered aircraftBuilt 1967 · S/N 24-4722 N9225YDodson International Parts Inc · Rantoul, KSBuilt 1983 · S/N 31P-8414015 N9226KAlatis Nicholas C · Cincinnati, OHBuilt 1976 · S/N 32R-7680199 N9227PSiebold Peter · Tehachapi, CABuilt 1967 · S/N 24-4717 N9228PShillig Vance R · Colorado Springs, COS/N 24-4726 N9229PKoeman Scott B · Fort Moore, GAS/N 24-4727 N922BSCentral Airlines Inc · Leawood, KSBuilt 1966 · S/N 1598-207 N922CSWorm Rudolf Heiko · Saint Petersburg, FLBuilt 2021 · S/N T20609622 N922JMApplied Aerospace Concepts Pllc · Bloomington, MNBuilt 1972 · S/N 24-5017 N922MJAga Aviation LLC · Woodruff, SCBuilt 1997 · S/N 3257004 N9231PSeaton Flying Services Inc · Salado, TXBuilt 1967 · S/N 24-4729 N9231YBbees LLC · Moss Point, MSBuilt 1983 · S/N 31P-8414017 N9233PBlandina Leon V · New Hudson, MIBuilt 1967 · S/N 24-4731 N9235PJen Lyn Inc · Wilmington, DEFirst renewal noticeBuilt 1967 · S/N 24-4734 N9235YKamasano LLC · Highland, CABuilt 1983 · S/N 31P-8414020 N9236PTasso Aviation LLC · Orrville, ALS/N 24-4735 N9237PCloud Climibers LLC · Lexington, KYBuilt 1967 · S/N 24-4736 N9238PPylant Eric Jon · Arnold, CABuilt 1967 · S/N 24-4737 N9238WMansour Muhamad A · Wichita, KSBuilt 1967 · S/N 28-10908 N9239YDelgado John F · San Antonio, TXBuilt 1984 · S/N 31P-8414040 N923CSGlobal Aircraft Leasing Inc · Wilmington, DEBuilt 2021 · S/N T20609623 N923JSSankey Aviation LLC · Warminster, PABuilt 2005 · S/N T18208390 N923SDFresno County Sheriffs Department · Fresno, CABuilt 2001 · S/N T20608342 N92417Heritage Bay LLC · Carmel, CABuilt 2012 · S/N T18209076 N9241BBorder Warehouse Inc · Mission, TXBuilt 2010 · S/N T18209008 N9241PGaskill Jeffrey V · Weston, MOS/N 24-4740 N9242PDekervor Marc Phillippe II · La Mesa, CAS/N 24-4741 N9243PKanne Michael J · Des Moines, IABuilt 1967 · S/N 24-4742 N9244YParker Aircraft Sales Inc · Wilmington, DEBuilt 1983 · S/N 31P-8414014 N9245YMiles Aviation LLC · Sheridan, WYBuilt 1983 · S/N 31P-8414025 N9246MShenkirsch Consulting Inc · Mammoth Lakes, CABuilt 1993 · S/N 4622149 N9246PSharp Paul C · Modesto, CABuilt 1967 · S/N 24-4745 N9247LGenesis Aviation Enterprises Inc · Fort Lauderdale, FLS/N 31-8152160 N9247PEhrenberg David G · Corning, NYBuilt 1968 · S/N 24-4746 N9247YWest Bend Air Inc · West Bend, WIBuilt 1968 · S/N 31-322

Back to AD 71-13-01 R1