Skip to content

Registered aircraft · 40,473

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:80-04-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2') 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:80-04-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2')
  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:80-04-03-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2')
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.

N7335GJordan Jeffrey B · Woodland, WABuilt 1970 · S/N 17259035 N7335WWhitworth Kenneth W · Hanford, CARegistration expired, pending cancellationBuilt 1963 · S/N 28-1205 N73361Snyder Steven S · Norfolk, VABuilt 1976 · S/N 17267400 N73362Spanaflight LLC · Puyallup, WABuilt 1976 · S/N 17267401 N73365Toliver David R · Lenexa, KSS/N 17267404 N73367Martinez Jose Antonio · Orlando, FLBuilt 1976 · S/N 17267406 N7336DJohnson Dale M · Seminole, TXBuilt 1957 · S/N 22-5125 N7336JKey West Aviation LLC · Key West, FLBuilt 1968 · S/N 28-24691 N7336WDemers Matthew H · Plano, TXBuilt 1963 · S/N 28-1206 N73370Bay Flying Services LLC · Pinconning, MIBuilt 1976 · S/N 17267408 N73371Elliott Aaron · Scott City, KSBuilt 1976 · S/N 17267409 N7337GReiss Alan T · Puyallup, WABuilt 1970 · S/N 17259037 N7337LKiehl Flying Service LLC · Winnett, MTBuilt 1975 · S/N 18-7509047 N7337WReynolds Jessica C · Maricopa, AZBuilt 1963 · S/N 28-1220 N73381Wings Over Texas Holdings LLC · Denton, TXBuilt 1976 · S/N 17267414 N73383Ludington Rental LLC · Ludington, MIBuilt 1976 · S/N 17267416 N73387Bartley Darrell Jr · Somerset, KYBuilt 1976 · S/N 17267419 N73388Wings Over Texas Holdings LLC · Denton, TXBuilt 1976 · S/N 17267420 N7338FKyle Aviation Services LLC · North Charleston, SCBuilt 1979 · S/N 17273251 N7338WEvans Russell Slade · Austin, TXBuilt 1963 · S/N 28-1209 N73391Holdgate Irvin F · Englewood, FLBuilt 1976 · S/N 17267423 N73395Quick Caleb B · North Newton, KSBuilt 1976 · S/N 17267426 N73398Wintons Wings LLC · Bardstown, KYBuilt 1976 · S/N 17267428 N73399Stone Mary A Trustee · Weeki Wachee, FLS/N 17267429 N7339FLambright Kevin L · Shipshewana, INBuilt 1979 · S/N 17273252 N733ABKalman Engineering Inc · Pekin, ILBuilt 1976 · S/N 17268136 N733ADMarshe Aviation LLC · Upland, CABuilt 1976 · S/N 17268137 N733AEMackey Aviation LLC · Talking Rock, GAS/N 17268138 N733AGRick Aviation Inc · Newport News, VABuilt 1976 · S/N 17268140 N733AHAltus Aircraft LLC · Taylor, TXS/N 17268141 N733AJ578 Airplane Leasing Inc · Kissimmee, FLBuilt 1976 · S/N 17268142 N733AKParker Helicopters Inc · Watsonville, CABuilt 1976 · S/N 17268143 N733AMGlendale Community College · Glendale, CABuilt 1976 · S/N 17268145 N733ANAtlas Epigrin Aviation LLC · Austin, TXS/N 17268146 N733AQCrankshaft Aviation LLC · Pine River, MNBuilt 1976 · S/N 17268147 N733ATAlpha Tango LLC · Lake Village, ARBuilt 1976 · S/N 17268150 N733AVPdm Aviation LLC · Greencastle, INBuilt 1976 · S/N 17268152 N733AWKaiser Eric J · Milford, INBuilt 1976 · S/N 17268153 N733AYFord Eagles Inc · Plymouth, MIBuilt 1976 · S/N 17268155 N733AZTactical Integrated Training Solutions LLC · San Antonio, TXBuilt 1976 · S/N 17268156 N733BCPs N733bc LLC · Green Bay, WIBuilt 1976 · S/N 17268159 N733BDRegistered aircraftBuilt 1976 · S/N 17268160 N733BEFlying Particles Inc · Livermore, CABuilt 1976 · S/N 17268161 N733BGAviator Air Flight School LLC · Grand Prairie, TXBuilt 1976 · S/N 17268163 N733BKB & R Aircraft LLC · Wadsworth, OHBuilt 1976 · S/N 17268166 N733BPDavis Keith I · Manchester, TNS/N 17268170 N733BRAmalong Tim M · Tucson, AZBuilt 1976 · S/N 17268172 N733BSJulius William C · Julesburg, COS/N 17268173 N733BTNorthern Air Aviation LLC · Naples, IDBuilt 1976 · S/N 17268174 N733BZBz Partners Inc · Purcellville, VABuilt 1977 · S/N 17268180

Back to AD 80-04-03 R2