Skip to content

Registered aircraft · 54,015

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:87-20-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2') 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:87-20-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
  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:87-20-03-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
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.

N7591SWildenberg Earl W · Menomonie, WIBuilt 1976 · S/N 18265240 N7591TScamman Glenn O · Topeka, KSBuilt 1960 · S/N 47191 N7591UBarbour Benjamin · Huntersville, NCBuilt 1975 · S/N 15077758 N7591VHallack Daniel Edwin · Hart, MIBuilt 1976 · S/N 177RG0882 N75922Phillips Lester L · Pahrump, NVBuilt 1976 · S/N 17268045 N75925A&A Aviation LLC · Edinburgh, INBuilt 1976 · S/N 17268047 N75926Owens Flight Training LLC · Lafayette, LABuilt 1976 · S/N 17268048 N7592RInternational Security Network Inc · Pahrump, NVBuilt 1978 · S/N R18200654 N7592SJld Aero Inc · Dalton, GABuilt 1976 · S/N 18265241 N7592TSouthern Kentucky Aviation LLC · Bowling Green, KYS/N 47192 N7592UMiller Collin · Allen, TXBuilt 1975 · S/N 15077759 N7592VMisener Richard H · Hermiston, ORBuilt 1976 · S/N 177RG0883 N7592YClover Park Technical College · Lakewood, WABuilt 1977 · S/N R18200141 N75930Rivera Aniceto · Boonton, NJBuilt 1976 · S/N 17268052 N75931Alston Russell R · South Jordan, UTS/N 17268053 N75935Allison Aviation LLC · Missoula, MTBuilt 1975 · S/N 21060741 N75938Fiedler Aviation LLC · Suffolk, VABuilt 1976 · S/N 17268055 N7593EFrench Robert J · Ferndale, WABuilt 1978 · S/N 17272113 N7593NCenac Towing Co LLC · Houma, LABuilt 1981 · S/N 18504327 N7593ST-Craft Aero Club · Nampa, IDBuilt 1976 · S/N 18265242 N7593VBlanzy Paul J · Highland, MIBuilt 1976 · S/N 177RG0884 N7593XMills Laura L · Canton, OHBuilt 1960 · S/N 17248093 N75942Ward Sharon A · Lago Vista, TXBuilt 1976 · S/N 17268058 N75943Savage Island Airport (Vt15) LLC · Burlington, VTBuilt 1976 · S/N 17268059 N75944Noll Gregory Lloyd · Watford City, NDBuilt 1976 · S/N 17268060 N7594MNcneill Dudley · Happy, TXBuilt 1977 · S/N 21062025 N7594SGibbs John D · Victoria, TXBuilt 1976 · S/N 18265243 N7594TGrimes Arthur D · Zeeland, MIBuilt 1959 · S/N 47194 N7594VSilly Boy Aviation LLC · Moses Lake, WABuilt 1976 · S/N 177RG0885 N75950West John T · Bulverde, TXBuilt 1976 · S/N 17268063 N75951Newman James D · El Cajon, CAS/N 17268064 N75955Belgarde Monte G · Butte, MTBuilt 1976 · S/N 17268067 N75956Millennium Aviation Group LLC · Wallace, NCBuilt 1976 · S/N 17268068 N7595QSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1978 · S/N 18503622 N7595UClavel Carl R · North Platte, NEBuilt 1975 · S/N 15077761 N7595XDelgado Mario Jr · Baldwin Park, CAS/N 17248095 N75967Ace Of Spades Aviation LLC · Las Vegas, NVBuilt 1976 · S/N 17268073 N7596HMccrory James K · Bloomington, INS/N 18267920 N7596SLoftin Nathan E II · Pompano Beach, FLBuilt 1976 · S/N 18265245 N7596XBurklund Joel · Minneapolis, MNBuilt 1960 · S/N 17248096 N75971Price Ronald Anthony · Deer Park, WABuilt 1976 · S/N 17268075 N75972Aircraft Resource Center Inc · Lakeville, MNBuilt 1976 · S/N 17268076 N75974733et LLC · Columbus, OHS/N 17268077 N75976Suburban Aircraft Leasing And Sales LLC · Sylvania, OHBuilt 1976 · S/N 17268079 N7597HCulhane Tim R · Anchorage, AKBuilt 1977 · S/N 18503408 N7597SRainier Ranch LLC · Enumclaw, WABuilt 1976 · S/N 18265246 N7597XPlain Company Ltd · Bloomfield Hills, MIBuilt 1977 · S/N R18200111 N75982Schurr Frank J · Las Vegas, NVBuilt 1976 · S/N 17268083 N75985Pitt Patrick L · Ephrata, WABuilt 1976 · S/N 17268086 N7598GGbc Leasing LLC · Gun Barrel City, TXBuilt 1970 · S/N 17259298

Back to AD 87-20-03 R2