Registered aircraft · 14,113

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

N10006Coutches Robert Hercules DBA · Livermore, CABuilt 1955 · S/N BG-72 N1000LWise Joe · Kilgore, TXBuilt 1966 · S/N TC-1000 N1000YBarkhimer James C · Iraan, TXBuilt 1954 · S/N 30999 N1007F007 Aviation LLC · Wilmington, DEBuilt 1968 · S/N TC-1163 N1008AAerial Surveys International LLC · Watkins, COBuilt 1967 · S/N 402-0097 N100ANWatson Family Investments LLC · Houston, TXBuilt 1977 · S/N D-10084 N100BMarshall Xavier T · Carson, CAS/N 57114 N100BABemidji Aviation Services Inc · Bemidji, MNBuilt 1968 · S/N U12 N100FBHoffman Swen · Sedalia, COBuilt 1963 · S/N D-7158 N100FMRivkin Gerald · Saint Augustine, FLBuilt 1969 · S/N TE-729 N100GMHuguenard Jefferson J · Alpharetta, GABuilt 1968 · S/N TC-1183 N100GSPegasus Florida I Inc · San Diego, CABuilt 1974 · S/N P-301 N100HJClipper Air Inc · Tomball, TXBuilt 1974 · S/N 340-0334 N100HSAir Works Ltd · Wilmington, DES/N E-3506 N100JLBytelogics Inc · New York, NYS/N 421-0008 N100JPAviation Consulting LLC · Ada, MIS/N TH-1683 N100KBExecutive Air Taxi Corp · Bismarck, NDBuilt 1979 · S/N LJ-820 N100KJDrewyor Kenneth · Eaton Rapids, MIBuilt 1977 · S/N D-9987 N100KWBaldassarre Thomas Anthony · Gillette, NJBuilt 1980 · S/N D-10336 N100LKKoebele Thomas R · Cape May, NJBuilt 1977 · S/N CE-686 N100LLPremiere Brand Meats · Shasta Lake, CABuilt 1973 · S/N 414-0429 N100LSAg Flyers Inc · Torrington, WYBuilt 1969 · S/N P-116 N100MLMl Aviation LLC · Boulder, COBuilt 1972 · S/N TH-249 N100MMFarmer Aviation LLC · Milan, MIS/N 33611 N100MRCarlson Carl J II · Aledo, TXBuilt 1973 · S/N TC-1512 N100NKLand Air Sea Inc · Chesapeake, VABuilt 1969 · S/N TE-767 N100NNDunnair LLC · Panama City, FLBuilt 1973 · S/N D-9465 N100PETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2018 · S/N 680-0580 N100PRKinder Eric Eugene Trustee · Tucson, AZBuilt 1970 · S/N D-9167 N100PSG & C Property Hc LLC · San Francisco, CABuilt 1987 · S/N CE1140 N100PZAeromotors LLC · St James, MOBuilt 1974 · S/N TH-554 N100QTSouthwest Aviation Inc · Marshall, MNBuilt 1976 · S/N LJ689 N100RABonanza Holdings Group LLC · Greenville, NCBuilt 1977 · S/N P405 N100RBIngraham Donald S · New Bern, NCBuilt 1991 · S/N CE-1586 N100RESchooler Jordan Benjamin · Hummelstown, PABuilt 1981 · S/N CE-987 N100SFSafe Flight Instrument LLC · White Plains, NYBuilt 1979 · S/N TC-2211 N100SPWright Richard S · Half Moon Bay, CABuilt 1970 · S/N D-9107T N100SYAerodan Aviation LLC · Alpharetta, GABuilt 1990 · S/N 560-0054 N100TBAlexander Aviation LLC · Brighton, COBuilt 1963 · S/N CD-637 N100TXJones Joseph Clayton · Bossier City, LABuilt 1976 · S/N D-9854 N100VReserve Aviation LLC · Dallas, TXBuilt 1978 · S/N LJ-796 N100WBBbcc Foundation · Moses Lake, WABuilt 1966 · S/N LJ-139 N100WPTads LLC · Kansas City, KSBuilt 1990 · S/N 560-0073 N100WSQualitair LLC Trustee · MichelstadtBuilt 1987 · S/N CE-1202 N100XHBiggs Aircraft Inc · Wellston, OKBuilt 1999 · S/N E-3249 N100XPHeath Darrell L · Houston, TXBuilt 1991 · S/N CE-1564 N100ZPZipjack Inc · Fernandina Beach, FLBuilt 1955 · S/N BG-4 N100ZZArbuckle George A · Poolville, TXBuilt 1975 · S/N TC-1922 N1010FHangar 10 Aviation LLC · Durant, OKS/N 1403-145 N1010NScoular Co · Omaha, NEBuilt 2012 · S/N 680-0331

Back to AD 78-05-06