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.

N12PSMurphy Peter · Johns Creek, GABuilt 1981 · S/N 44-8107047 N12RJDesert Air Ambulance Inc · Blythe, CABuilt 1977 · S/N 421C0306 N12SBSilvano Sal · La Grange, KYBuilt 1979 · S/N 340A0911 N12TTThoms Robert D · Clyde, MIS/N 310H0066 N12VLCrow Edward N Jr · Silverdale, WAS/N 310P0171 N12WLLauterbach Christian · Carmel, CABuilt 1975 · S/N TC-1870 N12WTMtzb Corp · New York, NYBuilt 1974 · S/N 421B0829 N12XVStormhaul Holding LLC · Taylors, SCBuilt 2021 · S/N 20800678 N1305PParkhill Clifton A Jr Trustee · Oxnard, CABuilt 1955 · S/N 23-345 N1306GCitadel Engineering Inc · Ellendale, DEBuilt 1974 · S/N 310Q1148 N1307Brian Michael L · Greensboro, NCBuilt 1969 · S/N TC-1307 N1308BHopewell Jeffrey D · Temple, TXBuilt 1955 · S/N 23-340 N1308GRed Over White Aviation · Louisville, KYBuilt 1974 · S/N 310Q1149 N130AGWings Over Texas Holdings LLC · Denton, TXBuilt 2024 · S/N 4496578 N130BVTheophanis Charters LLC · Stuart, FLS/N 31-7952216 N130HLFair Winds Aviation LLC · Shreveport, LABuilt 1979 · S/N 414A0322 N130MMMighty Mike LLC · Maysville, KYBuilt 1964 · S/N 30-550 N130MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2019 · S/N 4496477 N130RACarter Distribution Lc · Salt Lake City, UTBuilt 1976 · S/N 340A0040 N1311GGranite Mountain Flight Training LLC · Prescott, AZBuilt 1974 · S/N 310Q1152 N1311LCarpe Diem Atb LLC · Northfield, MNS/N 33701804 N1312LMccole Kevin · Brookline, NHBuilt 1977 · S/N 33701805 N1313RAztexas LLC · Valley Farms, AZS/N 310J0178 N1314GBas Part Sales LLC · Greeley, COBuilt 1974 · S/N 310Q1154 N1316ASky West Aviation Inc Trustee · Albuquerque, NMS/N 347770258 N1316PMatthews Grover C · Hardinsburg, KYBuilt 1955 · S/N 23-356 N1317PWhite Christopher N · Clearwater, FLBuilt 1955 · S/N 23-357 N1319LOttlinger Robert L · Ormond Beach, FLBuilt 1977 · S/N 33701811 N1319PCanter Russell L · Enterprise, KSBuilt 1955 · S/N 23-360 N131AGWings Over Texas Holdings LLC · Denton, TXBuilt 2024 · S/N 4496589 N131FHappy Star LLC · Baxley, GABuilt 1963 · S/N TC-538 N131FAJones Donald T Jr · Barrigada, GUBuilt 1968 · S/N 27-4097 N131HPPacific Integrated Handling Inc · Tacoma, WABuilt 1981 · S/N 31T-8166018 N131MEDuncan John H Jr · Bend, ORBuilt 1984 · S/N TJ-451 N131MPN Registration Service LLC Trustee · Sanford, NCS/N 31P-7400193 N131PCSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1977 · S/N 31T-7820009 N131PJCrosswinds Flight Center Inc · Drums, PAS/N 31-7912030 N131RMInternational Air Services Inc Trustee · Carson City, NVBuilt 1976 · S/N 27-7654053 N131TVO'Brien Daniel H · Half Moon Bay, CABuilt 1977 · S/N 27-7754070 N1322GSmetters Jeffrey L · Crystal Lake, ILBuilt 1974 · S/N 310Q1160 N1323YState Of Alaska · Anchorage, AKBuilt 2001 · S/N 20800352 N132AGMarsh Equipment LLC · Aurora, ORBuilt 2024 · S/N 4496590 N132CTausch Roger M · Saint Charles, MIBuilt 1963 · S/N 30-62 N132CTHanger Six LLC · Birmingham, ALBuilt 1978 · S/N 34-7870179 N132DWChristiansen Aviation LLC · Wilmington, DEBuilt 2002 · S/N 4496139 N132MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2022 · S/N 4496540 N132TWRc Flyers LLC · Wilmington, DEBuilt 1974 · S/N TC-1654 N1333Beech Nut Flyers LLC · San Diego, CABuilt 1968 · S/N TC-1100 N1334HPreskar Michael H · Ione, CABuilt 1977 · S/N 34-7770121 N1334PN1334p LLC · Titusville, FLBuilt 1955 · S/N 23-379

Back to AD 2004-25-16 R1