Registered aircraft · 744

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-09-03-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:80-09-03-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:80-09-03-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:80-09-03-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:80-09-03-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:80-09-03-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.

N775DMGeneration Jets LLC · Denison, TXBuilt 1978 · S/N LJ-764 N775SCZw Air LLC · Little Rock, ARBuilt 1981 · S/N BB-808 N776LDodson International Parts Inc · Rantoul, KSBuilt 1970 · S/N B-54 N777AQBcms Investments LLC · Dexter, MOBuilt 1979 · S/N BB-583 N777AWFair Air Aviation LLC · Myrtle Beach, SCBuilt 1979 · S/N BB-536 N777EB7eb Aviation LLC · Dallas, TXBuilt 1979 · S/N LJ-863 N777KATake-Off LLC · Knoxville, TNBuilt 1978 · S/N LW-285 N777SSCalderwood Aviation LLC · Shafter, CABuilt 1980 · S/N BB-661 N77CA77ca Associates LLC · Coral Gables, FLBuilt 1980 · S/N BB-717 N77CESmall Plane LLC · Carson City, NVBuilt 1978 · S/N LW-257 N77HEDavis Aviation Inc · Brandon, MSBuilt 1981 · S/N LJ969 N77NBDodson International Parts Inc · Rantoul, KSBuilt 1978 · S/N LJ818 N77PFAerospace Asset Holdings LLC · Wilmington, DEFirst renewal noticeBuilt 1970 · S/N B-70 N77WFKt Aviation LLC · Las Cruces, NMBuilt 1972 · S/N LW-4 N77WMWhiskey Mike Aero LLC · Wilmington, DEBuilt 1986 · S/N LJ-1133 N781AKAlsworth Glen Sr · Port Alsworth, AKS/N B-53 N785WCWillwork 4 Jeta LLC · Houston, TXBuilt 1978 · S/N BB-425 N787TTMjw Aviation LLC · Beaumont, TXS/N LJ-787 N789CTKingfisher Associates LLC · Wilmington, DEBuilt 1981 · S/N BB-820 N78DARegistered aircraftBuilt 1976 · S/N BE-11 N790AWilliam C New Aviation Services LLC · Morgan City, LABuilt 1982 · S/N LJ-1016 N791EBSav Aviation LLC · Jacksonville, TXBuilt 1980 · S/N BB791 N7931DJet Air Inc · Galesburg, ILBuilt 1982 · S/N LJ-1049 N795PAPdx LLC · Indianapolis, INS/N BB-328 N797CFAmerican Aviation Inc · Brooksville, FLBuilt 1978 · S/N LJ-797 N799DDRenfro Michael W · Bethel, AKBuilt 1971 · S/N B-102 N799GKCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1978 · S/N LJ-799 N79DMKsg Capital LLC · Casper, WYBuilt 1981 · S/N BB-853 N804Abc Aviation LLC · Gonzales, LABuilt 1980 · S/N BB-724 N806JMFlorida Fish & Wildlife Conservation Commission · Lakeland, FLS/N BC-22 N808SWFmgi Inc · Woodstock, GABuilt 1978 · S/N LJ801 N809DMAir Reldan Inc · Slidell, LABuilt 1980 · S/N LW-334 N809PSP & P Air LLC · Wilmington, DEBuilt 1978 · S/N BB-339 N80BTCentral Virginia Aviation Inc · Petersburg, VABuilt 1975 · S/N LW-148 N80CPBf Air LLC · Panama City, FLBuilt 1977 · S/N BB-263 N80WMAt Aero LLC · Wilmington, DES/N BB-863 N811KCTwa International Inc · Cheyenne, WYFirst renewal noticeBuilt 1979 · S/N LJ-869 N813BLSarma Aviation LLC · Fort Wayne, INBuilt 1978 · S/N BE-55 N813JBDodson International Parts Inc · Rantoul, KSBuilt 1980 · S/N LJ-899 N81HPFly Buys Too LLC · Wilmington, DEBuilt 1973 · S/N LW-72 N81TFA P A C LLC · Berlin, NJBuilt 1980 · S/N BB-750 N81TLC S & P Rocky Mountain Inc · Cheyenne, WYS/N BB-959 N820RDImhof Air 2 LLC · Ferndale, WABuilt 1973 · S/N LW-82 N821CBEz Transportation Inc · Rosharon, TXBuilt 1977 · S/N BE-35 N821VVElite Team Offices Inc · Clovis, CABuilt 1977 · S/N LJ-714 N825KASav Aviation LLC · Jacksonville, TXS/N BB-825 N825SDGreat Valley Management Inc · New Castle, DEFirst renewal noticeBuilt 1996 · S/N LJ-1449 N827KBArkansas Air Partners LLC · Jonesboro, ARBuilt 1978 · S/N LW-287 N82XPJones Harry R Jr · Houston, TXBuilt 1982 · S/N LJ-1012 N831WPVagus Group Inc · Wilmington, DEBuilt 1979 · S/N BB-569

Back to AD 80-09-03 R1