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.

N15839Phoenix East Aviation LLC · Daytona Beach, FLBuilt 1972 · S/N 34-7350100 N158BBStubbs J Phillip · Richmond, VABuilt 1975 · S/N TH-592 N158BDJ L Aviation LLC · Jonesboro, ARBuilt 1979 · S/N TH-1045 N158BHB58 LLC · Granger, INBuilt 1988 · S/N TH-1540 N158BJPerfectus Inc · Wilmington, DES/N TH-324 N158BMChorman Spraying LLC · Milton, DEBuilt 1981 · S/N TH-1244 N158GEarle Norman R · Fairview, NCS/N 23-1521 N158JDNavajo N158jd LLC · Wilmington, DEBuilt 1981 · S/N 318152104 N158KPelican Aviation Inc · Gainesville, GABuilt 1980 · S/N TH-1178 N158KSBowerman Marvin · Montgomery, TXBuilt 1982 · S/N TJ-419 N158NCIal Corp · Lewes, DEBuilt 1974 · S/N TH-444 N158PA2 Laikas LLC · Helena, MTBuilt 1978 · S/N TJ-141 N158RFBeech Bound LLC · Morgantown, WVBuilt 1978 · S/N TH-941 N158RMWings Lc · Baltimore, MDBuilt 1988 · S/N TH-1543 N158RSRegistration Pending · Wallace, CARegistration pendingBuilt 1981 · S/N TJ-359 N158SQGriffith Aviation Inc · Griffith, INBuilt 1978 · S/N ME-86 N158SWFern Leasing Corp · Larkspur, CABuilt 1999 · S/N TH-1921 N158TBLunt Christopher K · Marco Island, FLBuilt 1977 · S/N TH-826 N158TCBoyd Brent · Fort Worth, TXBuilt 1978 · S/N TK-68 N158WCKing Air Properties LLC · Huntington Beach, CABuilt 2001 · S/N TH-2008 N158WUYale Companies LLC DBA · Indianapolis, INBuilt 2002 · S/N 4496158 N15925Everglades Aviation Academy LLC · Weston, FLBuilt 1973 · S/N 34-7350109 N1592GCtl Legacy Holdings LLC · Midland, TXBuilt 1974 · S/N 421B0822 N1595WHope John W · Greeneville, TNS/N TC-1448 N1596GN1596g Inc · Peachtree City, GABuilt 1974 · S/N 340-0507 N1596TPlane Crazy Inc · Page, NDBuilt 1973 · S/N 4140376 N159BOppold Robert S · Overland Park, KSBuilt 1977 · S/N 27-7754047 N159DSynapse USA LLC · Mesa, AZBuilt 1974 · S/N 31P7530012 N159RSTechnical Education Services Inc · Virginia Beach, VAS/N 27-2817 N159SMMcneill Transportation LLC · Whiteville, NCS/N TH-2085 N159WMFixed Wing Holding Co Inc · Pembroke Pines, FLBuilt 2002 · S/N 4496159 N159ZIdaho State University · Pocatello, IDBuilt 1978 · S/N TJ-178 N15CGJwe Aviation LLC · Sugar Hill, GABuilt 1964 · S/N TC-568 N15CLDoran Jeffrey T · Westerville, OHS/N TC-818 N15DSAll Attitude Aviation Inc · Edgewater, FLBuilt 1965 · S/N 320D0079 N15EEBorn To Fly LLC · Booker, TXBuilt 1981 · S/N 34-8133054 N15FGShannon Jesse Lee · Boise City, OKBuilt 1975 · S/N 27-7554112 N15FSHappytails Aviation LLC · Fort Collins, COBuilt 1981 · S/N 34-8133046 N15GK427 Siera Lima LLC · Ponte Vedra, FLBuilt 1974 · S/N TC-1681 N15JAAdams Harry Jay · New Waverly, TXBuilt 1979 · S/N TK95 N15JDSwanson Alec · Hanahan, SCBuilt 1972 · S/N 310Q0476 N15JEPremier Flight Center LLC · Hartford, CTBuilt 1964 · S/N 27-2494 N15JMAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1981 · S/N 44-8107060 N15JUC&D Aviation LLC · Appleton, WIBuilt 1982 · S/N TJ-434 N15KWRibitsch Robert L · Redondo Beach, CABuilt 1981 · S/N 31T-8166014 N15KYMcdougle Sean · Oklahoma City, OKBuilt 1965 · S/N 27-2780 N15LSArch Air LLC · Paducah, KYBuilt 1972 · S/N TC-1465 N15REGreat Alaskan Flooring Inc · Kodiak, AKBuilt 1968 · S/N 27-4068 N15SVGore Joshua · Sedro Woolley, WABuilt 1977 · S/N 340A-0226 N15SYGoldman Richard D · Litchfield Park, AZBuilt 1969 · S/N P-46

Back to AD 2004-25-16 R1