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.

N2163FSkywarrior Flight Training Inc · Pensacola, FLBuilt 1978 · S/N 44-7995167 N2163PCarroll Bodo W · Franklin, OHBuilt 1956 · S/N 23-765 N2166MMiller Harry B · Fisherville, TNBuilt 1977 · S/N 34-7870070 N2168PSmith Kevin L · Peachtree City, GAS/N 23-773 N2168XOrtiz Stewart Flynn · San Diego, CABuilt 1965 · S/N 337-0068 N216FWAtp Aircraft 2 LLC · Wilmington, DEBuilt 1979 · S/N 447995181 N216LBBail Air LLC · Port Saint Lucie, FLBuilt 1974 · S/N 414-0545 N2170NCottle Dennis J · Bainbridge Island, WABuilt 1979 · S/N 44-7995224 N2172LU S Aviator LLC · Eugene, ORBuilt 1976 · S/N TC-2020 N2172PRiggin Flight Service Inc · Madison, SDBuilt 1956 · S/N 23-778 N2173SSunrise Aviation Inc · Ormond Beach, FLBuilt 1979 · S/N 44-7995245 N2177PMidwest Environmental Products Inc · Wichita, KSBuilt 1956 · S/N 23-783 N21788Kenco Associates Inc · Ashland, KYBuilt 1978 · S/N 34-7870450 N217BSRegistration Pending · Nogales, AZRegistration pendingBuilt 1963 · S/N 310H0034 N217HCSwartzendruber Brett E · Hesston, KSBuilt 1963 · S/N 30-166 N217KEpps Ernest P Jr · Atlanta, GABuilt 1965 · S/N TC-891 N217MEAir Research Ca Inc · Torrance, CABuilt 1983 · S/N T30300188 N2182LGadboys Jeffrey A · Naples, FLS/N TC-1996 N2186XAshiku Phillip · Ukiah, CABuilt 1965 · S/N 337-0086 N218CFLevel 200 LLC · Charlottesville, VABuilt 1980 · S/N 340A0989 N218KKSkymates Inc · Wilmington, DEBuilt 2002 · S/N 4496153 N218PAPreferred Airparts LLC · Kidron, OHS/N 20800384 N218USouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 310Q0507 N2190KArnold Mark W · Columbus, OHBuilt 1978 · S/N 34-7970096 N2190PN2190p LLC · Titusville, FLS/N 23-799 N2192XGoldsmith Alejandro J · Houston, TXBuilt 1965 · S/N 337-0092 N2193VApm Leasing LLC · Casper, WYBuilt 1979 · S/N 44-7995266 N2194KAviation Training LLC · Wilmington, DEBuilt 1978 · S/N 44-7995203 N2195PZahlmann Daniel R · Queen Creek, AZS/N 23-803 N2196VFixed Wing Holding Co Inc · Pembroke Pines, FLBuilt 1979 · S/N 44-7995267 N2197LJ Rougeau Rehab Inc · North Adams, MABuilt 1976 · S/N TC-2018 N2198PAerotrack Inc · Hemet, CABuilt 1956 · S/N 23-808 N2199PPowers Edward · Stormville, NYS/N 23-809 N219CHSteel Eagle Aviation LLC · Birmingham, ALBuilt 2001 · S/N TH-1990 N219EPEpic Aviation Inc · New Smyrna, FLBuilt 2019 · S/N 4496458 N219GMStewart Michael A · Washington, DCBuilt 1988 · S/N TH-1536 N219TGXin Han Aviation LLC · Atwater, CABuilt 1972 · S/N 34-7250315 N219ZCarroll Sean Terence · Saint Petersburg, FLBuilt 1964 · S/N TC-789 N21ABAriel J Quintela LLC · Odessa, FLBuilt 1980 · S/N 31-8052122 N21AQCapiga Daniel P · North Fort Myers, FLBuilt 1973 · S/N 27-7305035 N21BBSmartin Enterprises LLC · Phoenix, AZS/N TC-1690 N21CSHendrix Peter A · Plantation, FLBuilt 1973 · S/N 310Q0963 N21DAW Squared Holdings LLC · Edmond, OKBuilt 1978 · S/N TH-980 N21DPPacific Fleet Aviation LLC · Rochester, NYBuilt 1978 · S/N 27-7854097 N21FC310 Pals LLC · Lake City, FLBuilt 1974 · S/N 310Q1080 N21GFBas Part Sales LLC · Greeley, COBuilt 1971 · S/N 421B-0209 N21HGDrisco LLC · Ponca City, OKBuilt 1981 · S/N 31-8152078 N21HLChieftain Aviation Inc · Marietta, GAS/N 31-8152126 N21KBLow Carl S III · Aurora, TXBuilt 1973 · S/N 310Q0777 N21KDMrd Aviation LLC · Windsor, COBuilt 1979 · S/N 414A0439

Back to AD 2004-25-16 R1