Registered aircraft · 10,536

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.

N123BTYingling Consultation LLC · Wilmington, DEBuilt 1973 · S/N 421B0414 N123CWCoastal Wings LLC · Fort Lauderdale, FLS/N 310Q0975 N123FLPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 4496648 N123JHFti Group LLC · Norman, OKS/N 31P-7630010 N123JJRotorwings Aviation LLC · Hebron, NEBuilt 1972 · S/N TC-1421 N123MNFoster Aviation And Mobile Maintenance LLC · Dublin, VABuilt 1972 · S/N 310Q0602 N123NKLarson Ken · Escondido, CABuilt 1970 · S/N P-153 N123NPTralo Aviation LLC · Owatonna, MNBuilt 1977 · S/N 421C0402 N123PJacobs Michael · Jay, OKBuilt 1955 · S/N 23-397 N123PTScheller Erik G Trustee · Gig Harbor, WAS/N 31-8112020 N123PVSandlapper Aviation Of De Inc · Bennington, VTBuilt 1973 · S/N 27-7305039 N123TBTango Bravo LLC · Wilmington, DEBuilt 1979 · S/N 340A0795 N123TDVinanam Aviation LLC · Cupertino, CABuilt 1977 · S/N 340A0307 N123TJClover Management Systems Inc · Sanford, FLBuilt 1978 · S/N 44-7995045 N123USLow Gary Mike · Southside, ARBuilt 1982 · S/N TH-1335 N123WBHighview LLC · Brentwood, TNBuilt 1978 · S/N TH-937 N1240GBas Part Sales LLC · Greeley, COBuilt 1974 · S/N 310Q1091 N1242GHeathington A H · Georgetown, TXBuilt 1974 · S/N 310Q1093 N12434Aviation S And S LLC · Miami, FLBuilt 1983 · S/N 414A1002 N1245AAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 1984 · S/N 414A1201 N1247GNafziger Aviation Leasing LLC · Wittman, MDBuilt 1974 · S/N 310Q1098 N1249VAguilar Perez Jose L · Newton, MABuilt 1976 · S/N 27-7654046 N124AGPegasus Enterprises LLC · Granbury, TXBuilt 1978 · S/N 31-7852103 N124AWCyalco Aviation LLC · Spencer, IABuilt 1965 · S/N TC-942 N124DRLeventis Phil P · Sumter, SCBuilt 1973 · S/N 340-0219 N124MDKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 1981 · S/N TJ374 N124RFRandigo LLC · Wilmington, DEBuilt 1988 · S/N 20800018 N124TJAlan Aviation LLC · Los Angeles, CAS/N TH-923 N124TMUniversal Aviation LLC · Decatur, ARS/N 421C-0898 N124VLeach Manuel R · Natchitoches, LABuilt 1964 · S/N TC-747 N124WABraswell Jerrold W · Dillingham, AKS/N 31-7405242 N124WC3-B Farms Inc · Pinetown, NCBuilt 1973 · S/N 421B0484 N1250CBravan Aviation · Fort Lauderdale, FLS/N 31P-7530011 N1252GInternational Air Services Inc Trustee · Carson City, NVBuilt 1975 · S/N 414-0809 N1255PJones Jamie · Grants Pass, ORS/N 23-281 N1258GConroy Bruce M · Martinez, CABuilt 1974 · S/N 310Q1109 N1258SN76bt LLC · Lynnfield, MAS/N 33701894 N12595Cornell Terry Jason · Bloomsburg, PABuilt 1971 · S/N 27-4725 N125BEGomez Eliud · Winter Park, FLS/N TH-43 N125CPLinscott Jeffrey R · Boring, ORBuilt 1972 · S/N 340-0093 N125DMCallegari Gino A · Susanville, CABuilt 1966 · S/N 310K0176 N125FLAll Star Capital LLC · Concord, NCBuilt 1980 · S/N 34-8170025 N125LLDykstra Darren · Pacific Grove, CABuilt 1982 · S/N TJ-417 N125MGHillsboro Aero Academy LLC · Hillsboro, ORBuilt 2002 · S/N 4496152 N125MLL3 Cts Airline Academy · Sanford, FLBuilt 2019 · S/N 4496480 N125TCYoung Jeremy · Portland, ORBuilt 1975 · S/N TJ-3 N125YDsr-Cherokee 180 LLC · Dallas, TXBuilt 1963 · S/N 27-2366 N1265HKingsky Flight Academy LLC · Lakeland, FLS/N 34-7770117 N12666Wdr Inc · Grand Forks, NDBuilt 1996 · S/N 20800250 N1266MBeta Flight LLC · Queen Creek, AZS/N 33701266

Back to AD 2004-25-16 R1