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.

N323DDHd Security Systems LLC · Watertown, TNBuilt 1981 · S/N 31-8152170 N323LMSandcastle Jwm Properties LLC · Paradise Valley, AZBuilt 1992 · S/N TH-1667 N323TJGuardian Wings LLC · Fredericksburg, VABuilt 1983 · S/N T30300243 N3240YMeadowlake Airpark LLC · Lenoir City, TNS/N TC2322 N3241PBravo Partners LLC · Payson, AZBuilt 1957 · S/N 23-1186 N32456Bas Part Sales LLC · Greeley, COBuilt 1974 · S/N 34-7570023 N3246BRb3246b LLC · La Follette, TNBuilt 1995 · S/N TH-1746 N3248LPreferred Management Corp · Shawnee, OKBuilt 1995 · S/N TH-1748 N3248PAero Spectra Corp · Boulder, COS/N 23-1193 N324ARParrish Blake · Seminole, TXS/N 31T-7620052 N324QLove Charles Keith · Asheville, NCBuilt 1999 · S/N TH-1909 N324RTTorres Rafael · Levittown, PRBuilt 1966 · S/N 27-3210 N3252PGodbout Kevin P · South Hadley, MABuilt 1957 · S/N 23-1197 N32555Harvest Aviation · Wauchula, FLBuilt 1974 · S/N 34-7570032 N3257XN1002q LLC · Lake Butler, FLFirst renewal noticeBuilt 1967 · S/N 310L-0107 N3258XWrenn William H · Baytown, TXFirst renewal noticeS/N 310L-0108 N325AKInternational Air Services Inc Trustee · Carson City, NVS/N 31-8112016 N325BBCapital City Curb & Gutter LLC · Wake Forest, NCBuilt 1975 · S/N 31-7512021 N325CRDiaz Aviation LLC · South New Berlin, NYBuilt 1978 · S/N 31-7912001 N325DCGmg Aviation LLC · Ehrhardt, SCBuilt 1981 · S/N TH-1292 N325FATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1982 · S/N 31-8212005 N325FJSale Reported · Hopkinsville, KYSale reportedBuilt 1977 · S/N 31-7812007 N325JAdonai International Ministries · Marine, ILBuilt 1976 · S/N 31-7712002 N325KCMount Wilson Holdings LLC · Orange, CABuilt 1981 · S/N 414A0825 N325LAPeregrine Howard Fund V Owner LLC · New Orleans, LABuilt 2019 · S/N 4496487 N325LBGlobal Aircraft Trust Inc Trustee · Cheyenne, WYS/N 27-7305149 N325SGTraveling Lill LLC · Key Largo, FLBuilt 1978 · S/N 317812115 N325TTSuperior Flying Service LLC · Superior, WIBuilt 1983 · S/N 348333006 N3260FGilbert Aviation Inc · Wilmington, DEBuilt 1995 · S/N TH-1760 N3261CHeyman Steven · San Mateo, CABuilt 1996 · S/N TH1785 N32624Rio Aviation LLC · Wilmington, DES/N 34-7570038 N3264XDesert Cat Aviation LLC · Tempe, AZBuilt 1967 · S/N 310L-0114 N3266XRegistered aircraftBuilt 1967 · S/N 310L-0116 N3268POn Glideslope LLC · Middletown, DEFirst renewal noticeBuilt 1957 · S/N 23-1213 N326NDNational Training I LLC · Wilmington, DEBuilt 2003 · S/N 4496173 N326PTJt Aero LLC · Covington, GABuilt 1974 · S/N 310Q0968 N326TCAlvarado Ruben Jr · Brownsville, TXBuilt 1969 · S/N P-121 N3270JBerry Matthew G · Creedmoor, NCBuilt 1996 · S/N TH-1770 N3271XCoastal Defense Inc · Mill Hall, PABuilt 1967 · S/N 310L-0121 N3273DMonitor Ventures Group LLC · Anaheim, CABuilt 1973 · S/N 33701491 N3274XBoyer Dennis A · Harvest, ALBuilt 1967 · S/N 310L-0124 N32755Illinois Air Inc · Naperville, ILBuilt 1975 · S/N 34-7570049 N3276PFly Rite Aviation LLC · Fort Myers, FLS/N 23-1221 N32776Hutchison Ross C · Olathe, COBuilt 1975 · S/N 34-7570052 N3278YMiddle Tennessee State University · Murfreesboro, TNS/N 27-3714 N3279PSouth Bay Flight Training Center · Carolina, PRBuilt 1957 · S/N 23-1224 N327CABurbano Oscar Sebastian · Greensboro, NCBuilt 1979 · S/N 7970276 N327MWW. Morrison Consulting Group Inc · Aliso Viejo, CABuilt 1980 · S/N 414A0531 N327TALeblanc Joseph E Jr · Houston, TXBuilt 1984 · S/N 340A1809 N3280PRiggin Flight Service Inc · Madison, SDBuilt 1956 · S/N 23-679

Back to AD 2004-25-16 R1