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.

N9722BBosshard Steven A · Midlothian, VABuilt 1966 · S/N 30-1156 N972ETowe Lannie K · Madison, ALBuilt 1969 · S/N TC-1277 N972GCInternational Air Services Inc Trustee · Carson City, NVBuilt 1962 · S/N TC-540 N9731KAnywhere Atp LLC · Mt Juliet, TNBuilt 1977 · S/N 34-7870036 N9746CBas Part Sales LLC · Greeley, COS/N T30300210 N974CFAviation Trust Company LLC · Oklahoma City, OKBuilt 1974 · S/N 421B0609 N974CSMcgregor Daniel A · Denali Natl Park, AKBuilt 1976 · S/N 31-7652120 N975J&H Aircraft Leasing LLC · Berrien Springs, MIBuilt 1977 · S/N TC-2056 N976AZWl Aviation LLC · Boca Raton, FLBuilt 1976 · S/N 27-7654200 N976BEAero Sphere Inc · Mcclellan, CABuilt 1979 · S/N ME-252 N976CAFlydreams Aircraft Group Inc · Fort Lauderdale, FLBuilt 1979 · S/N ME228 N976MKLyman John W · Orrs Island, MEBuilt 1976 · S/N TC-1973 N976SRMs Baron LLC · Oxford, MSBuilt 2000 · S/N TH-1944 N977BHMotors Inc · Cumming, GAS/N 421C0227 N977GUS Nameplate Co · Mount Vernon, IABuilt 1981 · S/N 31T-8104065 N977GFBrown Bear Aircraft LLC · Hartland, MEBuilt 1972 · S/N TH-175 N977LBMiloud Chadd K · Fort Worth, TXS/N 34-7670243 N977PAGlobal Aviation Corp · Farmingdale, NYBuilt 1979 · S/N ME-195 N977PMFlamoil Wings LLC · Kaiser, MOBuilt 1981 · S/N 44-8107040 N977SFAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1979 · S/N 347970169 N977SMKmc Aviation Leasing LLC · Indianapolis, INBuilt 1974 · S/N 421B0595 N978Destination Flight Solutions LLC · Russellville, ALBuilt 1968 · S/N 310N-0128 N978NCColumbia Asset Trust Corp Trustee · Wichita, KSBuilt 1983 · S/N T30300206 N978WCXin Han Aviation LLC · Helena, MTBuilt 2000 · S/N 4496041 N9798CWeather Modification LLC · Fargo, NDBuilt 1978 · S/N 34-7870222 N979SPGulf South Services LLC · Chipley, FLS/N 31-7812015 N979SSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N TH-1932 N979WA700p LLC · Lewes, DEBuilt 1979 · S/N 34-8070109 N97DFFlying G Aviation LLC · Elizabeth, COBuilt 1978 · S/N 340A0510 N97DHEmbry Aero Ltd · Greenville, ILBuilt 1978 · S/N 421C0450 N97JKAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1978 · S/N 414A0052 N97LSFly2golf LLC · Largo, FLS/N TC-899 N97MADodson International Parts Inc · Rantoul, KSBuilt 1975 · S/N 31-7552006 N97NNAviation Business Corp · Saint Louis, MOS/N 23-435 N97RTeh LLC · Mccall, IDBuilt 1977 · S/N TK-45 N97RGArmy Aviation Heritage Foundation · Hampton, GAS/N TF-20 N97RSSchiffenhaus Robert · EspooBuilt 1984 · S/N TH-1414 N97VCSababa Aviation LLC · West Palm Beach, FLBuilt 1985 · S/N TJ-495 N97VPAtkins Louis Clifford Jr · Birmingham, ALBuilt 1964 · S/N 30-480 N9802AAtp Aircraft 7 LLC · Wilmington, DEBuilt 2008 · S/N 4496255 N980AMC&P Aircraft Holdings LLC · Nacogdoches, TXS/N 340-0518 N980CATlh Enterprises Inc · Corsicana, TXBuilt 1980 · S/N 31T-8104010 N980GCAir Kraft Spraying Inc · Timber Lake, SDBuilt 1971 · S/N 39-119 N980PADesantis Anthony · Memphis, TNS/N TH-1980 N981DMMartin David E · Dallas, TXBuilt 1975 · S/N 340A0028 N982KAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1978 · S/N 31T-7820011 N982TPYarab Holdings I LLC · Clearwater, FLBuilt 2019 · S/N 20800651 N983JBConstellation Aviation LLC · Rock Springs, WYBuilt 1978 · S/N 340A0453 N98437Infranco Anthony · Amityville, NYBuilt 1975 · S/N 421C0040 N984BCRegistered aircraftBuilt 1978 · S/N TH-984

Back to AD 2004-25-16 R1