Registered aircraft · 10,537

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:2004-25-16-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:2004-25-16-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:2004-25-16-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:2004-25-16-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:2004-25-16-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:2004-25-16-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.

N8007RSpath Terry L · Helena, MTBuilt 1969 · S/N TC-1244 N8008RClancey Maloney Aviation LLC · Lawrence, KSBuilt 1969 · S/N TC-1245 N8008YWillis Gary B · Willis, TXBuilt 1966 · S/N 30-1114 N800ADOkadaful LLC · Torrance, CABuilt 1978 · S/N ME-96 N800BAN8vv Inc · Corpus Christi, TXBuilt 1981 · S/N 414A0667 N800BCN800bc LLC · Columbia, PAS/N 340A0232 N800BGBlaikie Thomas B · Kenner, LAS/N 340A0346 N800CFSparky'S Air LLC · Wilmington, DEBuilt 1990 · S/N TH-1599 N800DKBartlett Paul H · Nebo, NCBuilt 1976 · S/N 31-7612110 N800JCThomas Bonner Enterprises LLC · Lubbock, TXBuilt 1979 · S/N TK-90 N800KKaufman Charles · West Palm Beach, FLBuilt 1966 · S/N 30-1115 N800LPC A Aviation Corp · Clifton, TXBuilt 1983 · S/N 31-8352009 N800MGSnell Marion Lea · Ackerly, TXBuilt 1974 · S/N 310Q0937 N800MWNorpel Express LLC · New Bedford, MABuilt 1981 · S/N 31-8252011 N800SMTofanzadeh Abdolreza · Chula Vista, CABuilt 1972 · S/N 421B-0275 N800SUOklahoma State University · Stillwater, OKBuilt 2017 · S/N 4496412 N800UOhio University · Albany, OHBuilt 1979 · S/N TC-2276 N800VMN800vm LLC · Wilton Manors, FLBuilt 1980 · S/N ME-318 N8011FAhmed Sharfaraz · Houston, TXBuilt 1976 · S/N 34-7770080 N8012YMarsh Geoffrey E · Old Lyme, CTBuilt 1966 · S/N 30-1119 N8013MBas Part Sales LLC · Greeley, COBuilt 1964 · S/N 310I0013 N8013YSunking Aviation LLC · Plano, TXS/N ME-413 N8014MCaldwell Machine & Gear Inc · Mount Pleasant, TXBuilt 1964 · S/N 310I0014 N8015MGill Conrad D · Mounds, OKBuilt 1964 · S/N 310I0015 N8017CBluedevil Aviation LLC · Scottsdale, AZBuilt 1981 · S/N 34-8133200 N8017YLoya Armando · Whittier, CABuilt 1966 · S/N 30-1125 N8019YOptimus Aicraft Leasing LLC · Naples, FLBuilt 1966 · S/N 30-1128 N801CHRisse Greg L · Lincoln, CABuilt 1974 · S/N 31-7405460 N801HLKp Equipment Investments LLC · Cottonwood, AZBuilt 1979 · S/N 31T-8020016 N801JASpokane Turbine Skydiving LLC · Medical Lake, WABuilt 1985 · S/N 20800009 N801QPrecision Flight Service Inc · Ponchatoula, LABuilt 1965 · S/N TC-897 N801SW5b Aviation LLC · Duncan, OKBuilt 1979 · S/N 447995209 N801TMajestic Enterprises Ltd · Wilmington, DEBuilt 1973 · S/N TH-330 N801TWJk Aircraft Options LLC · Aripeka, FLBuilt 1999 · S/N 20800297 N801USwint Mark S · Henderson, NVBuilt 1965 · S/N TC-715 N801VWN776va LLC · Wainscott, NYBuilt 2008 · S/N 20800503 N8020YSnead State Community College · Boaz, ALS/N 30-1129 N8021YSterling Investment Services Inc · Batavia, ILBuilt 1966 · S/N 30-1131 N8022YDanis Paul A · Woodinville, WAS/N 30-1097 N8024QFox Leasing Group LLC · Hollywood, FLBuilt 2021 · S/N 4496519 N8026YCaillouet Andre E Jr · Houma, LABuilt 1966 · S/N 30-1135 N8027CSeneca 8027c LLC · Spring Lake, MIBuilt 1976 · S/N 347670111 N8027YGreek Housing Services Corp · Port Matilda, PABuilt 1966 · S/N 30-1084 N802ATFlight School Of Texas LLC · Wilmington, DEBuilt 2013 · S/N 4496330 N802GAMns Asset Management LLC · Dover, DEBuilt 1981 · S/N 31-8152103 N802HLAir Hammer LLC · Wilmington, DES/N 414A0820 N802TDodson International Parts Inc · Rantoul, KSS/N TC-1548 N8030MInternational Air Services Inc Trustee · Carson City, NVBuilt 1964 · S/N 310I0030 N8030YPaden Frank G · Lawrenceburg, KYBuilt 1966 · S/N 30-1139 N8031YBresin Sharon M · Kamas, UTS/N 30-1140

Back to AD 2004-25-16 R1