Registered aircraft · 3,466

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

N123CEBas Part Sales LLC · Greeley, COS/N 21061054 N123DDCenturion 123 LLC · Glenwood Springs, COBuilt 1974 · S/N 21060627 N123DMJacquin Philip Fink · New York, NYS/N 21062663 N123MCNelson Isaac · Saint Croix Falls, WIS/N 21063578 N123TMJaars Inc · Waxhaw, NCS/N U20601768 N123UAwg Aviation LLC · Ainsworth, IABuilt 1968 · S/N 21059004 N123VRLewis Edward M · Mesquite, NVS/N 210-59891 N124WHHillcrest Aircraft Co Inc · Lewiston, IDBuilt 1979 · S/N U20605355 N124WNTemple Steve D · Superior, MTBuilt 1972 · S/N U206-01832 N1255VHanson Lanny Lane · Polson, MTBuilt 1974 · S/N U20602540 N125BMBaron Transporation Services LLC · Destrehan, LAFirst renewal noticeBuilt 1978 · S/N 21062926 N125CFInternational Air Services Inc Trustee · Carson City, NVS/N 21064253 N126LSMerritt Aaron S · Manhattan, MTS/N 21062038 N1289UKavak Air Inc · Middletown, DEBuilt 1982 · S/N 21064682 N128EEAlgab Holdings LLC · Newark, DEBuilt 1978 · S/N P21000133 N128TTWarner Wings LLC · Yakima, WABuilt 1979 · S/N U20604991 N1299MMoanaviation Inc · Tampa, FLBuilt 1977 · S/N 21061932 N129ELTrooien-Smith Construction LLC · Seeley Lake, MTBuilt 1978 · S/N U20604374 N12AWTgam LLC · Toppenish, WABuilt 1978 · S/N U20604688 N12DUWoodtick Summit Aviation LLC · Redmond, ORBuilt 1979 · S/N U20605202 N12JGVosworx Aviation LLC · Morrison, COBuilt 1979 · S/N P21000365 N12KFN12kf LLC · Pass Christian, MSBuilt 1973 · S/N 21059853 N12PFRucker Gary R · Kingman, AZBuilt 1977 · S/N 21062401 N12PWOhio State University College Of Engineering · Columbus, OHBuilt 1972 · S/N 21059796 N12VMS & R Air Inc · Asheville, NCBuilt 1977 · S/N 21061697 N1301LFox Aircraft LLC · Bethel, AKBuilt 1980 · S/N 20700641 N130RCWilliams Brian G · Las Cruces, NMBuilt 1983 · S/N P21000822 N1314UKilgore Don H · Jasper, ALBuilt 1982 · S/N 21064685 N131TTCharlie Kilo Enterprises Inc · Melbourne, FLBuilt 1979 · S/N U20605010 N1329UA C W Inc · Gonzales, LABuilt 1982 · S/N 21064687 N1333TWoodford Michael F · Fabius, NYBuilt 1969 · S/N T210-59108 N134RFMaverick Jet Leasing Inc · Wilmington, DES/N U20602719 N1361VLeduc Richard · Mazama, WABuilt 1974 · S/N U20602584 N1372VBoland Matthew S · Anchorage, AKS/N U20602588 N1397MRichs Inc · Wilmington, DES/N 21061940 N139BBTrejo Nahomy · Socorro, TXBuilt 1979 · S/N 21063712 N13KSNolt Ivan · Mount Solon, VABuilt 1974 · S/N 21060202 N13TNMcdaniel Robert M · Tonasket, WABuilt 1977 · S/N 21062428 N1400Salour Michael M · Carlsbad, CABuilt 1979 · S/N P210-00277 N1410URuffcorn Aviation Co · Bettondorf, IABuilt 1982 · S/N 21064693 N144WPDresel Av LLC · Fayetteville, ARBuilt 1973 · S/N 21059900 N1450CFreeland Christopher G · Brownwood, TXBuilt 1970 · S/N T21059318 N1450MCrescent Solutions Group LLC · Camden, DEBuilt 1970 · S/N U20601450 N1454QDarden Tyson · Wasilla, AKS/N U20602900 N1457MStevenson William E · Sutton, AKBuilt 1970 · S/N U20601457 N1459MK And L Aviation Incorporated · Wilmington, DEBuilt 1969 · S/N U20601459 N145PLState Of Alaska · Anchorage, AKBuilt 1981 · S/N U20606141 N1465MBig Mountain Construction LLC · La Grande, ORBuilt 1969 · S/N U20601465 N1466MTabor Shayne · Renville, MNBuilt 1970 · S/N U20601466 N1468MArctic Barnabas Ministries · Kenai, AKBuilt 1970 · S/N U20601468

Back to AD 2002-07-01