Skip to content

Registered aircraft · 54,019

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.

N20091Henderson Norman L · Bowling Green, MOBuilt 1972 · S/N 17261001 N20093Patterson Kyle · Tega Cay, SCBuilt 1972 · S/N 17261003 N20094Valiair Lc Trustee · Casper, WYS/N 17702627 N20095Wingsleasing LLC · Wichita, KSBuilt 1972 · S/N 17261005 N20097Morrison Robert J · Newport, MIBuilt 1972 · S/N 17261006 N20099Wehnam Kenneth J · Shingle Springs, CAS/N R18201922 N2009QTranby Wayne A · Fargo, NDBuilt 1973 · S/N 177RG0409 N200BJWright Thomas L · Clyde, OHBuilt 1975 · S/N 33701684 N200HPOklahoma Department Of Public Safety · Norman, OKS/N U20605693 N200LDFenske Jeffrey D · Gold Hill, ORBuilt 1973 · S/N 21059895 N200NMOrr Leroy A · Tonasket, WABuilt 1960 · S/N 57271 N200PFPrimary Flight Control LLC · Fleming Island, FLBuilt 1984 · S/N 17276085 N200PSMerren R Todd DBA · Montgomery, ALBuilt 1967 · S/N 67-15030 N200QRPdq Flight Inc · Garden City, NYS/N U20606092 N200RCRc Aviation LLC · Omaha, NEBuilt 1975 · S/N 21061073 N200RXAndrews Laral B · Portland, ORS/N 15067073 N200SDKing Dwayne W · Sutton, AKBuilt 1969 · S/N 15070651 N200TWeishaar Walt E · Livingston, TXBuilt 1964 · S/N 15060991 N200TLHusnik Brad M · Forest Lake, MNBuilt 1966 · S/N U206-0559 N200UAUrrea Hugo Edmundo Rincon · Houston, TXBuilt 1980 · S/N 21063921 N200VVN200vv LLC · Pontiac, MIS/N 18267363 N200WRVaughan Jason B · Sublette, KSBuilt 1978 · S/N 21062478 N200ZKInternational Air Services Inc Trustee · Carson City, NVBuilt 1966 · S/N 17255678 N20102Wings Over Texas Holdings LLC · Denton, TXBuilt 1972 · S/N 17261010 N20106Atlanta Air Academy LLC · Kennessaw, GABuilt 1972 · S/N 17261014 N2010GFox Stephen A · Wasilla, AKBuilt 1958 · S/N 51310 N2010QShadow Blade Technologies LLC · Palm Bay, FLBuilt 1973 · S/N 177RG0410 N2010XHutchinson Darrold K Trustee · Hingham, MTBuilt 1965 · S/N 18256110 N20111Westcott Emily E · Sequim, WABuilt 1972 · S/N 17261019 N20115Alpha Zulu Aviation LLC · San Diego, CABuilt 1972 · S/N 17261021 N20116Paxton Roger D · Norman, NCFirst renewal noticeS/N 17702630 N2011QManzo Mario A · Sacramento, CAS/N 177RG0411 N2011SHeath Stephen · Alpine, TNBuilt 1975 · S/N 21060979 N2011XSalem Ricky L · Burnet, TXBuilt 1965 · S/N 18256111 N20121Fly Maui LLC · Puunene, HIBuilt 1972 · S/N 17261025 N20123Irungu Gitau · Charlotte, NCBuilt 1972 · S/N 17261027 N20124Cerven Bohuslav Bo · Claremont, CABuilt 1977 · S/N 17702631 N20127Lewallen David H · Alexander, ARBuilt 1977 · S/N 17702633 N2012EAirgo Inc · Centralia, ILBuilt 1978 · S/N 17271117 N2012GMchugh Michael J Trustee · Hailey, IDBuilt 1958 · S/N 51312 N2012QOwens Joseph L · Fort Mohave, AZBuilt 1973 · S/N 177RG0412 N2012RPhysical Therapy And Sports Solutions LLC · Santa Fe, NMBuilt 1964 · S/N 18255212 N2012S9791m LLC · Tacoma, WAS/N 21060980 N20132J & L Aviation LLC · Malta, NYBuilt 1972 · S/N 17261035 N20133Creative Strategies Inc · Proctorville, OHBuilt 1972 · S/N 17261036 N20136Crate Inc · Humboldt, NEBuilt 1972 · S/N 17261038 N2013RZinsmeyer Charles D · Llano, TXBuilt 1964 · S/N 18255213 N2013XEec Group LLC · Kalispell, MTBuilt 1965 · S/N 18256113 N2013YRoberts Michael R · Plano, TXBuilt 1962 · S/N 17249513 N2014Blue Skies Trading Company LLC · Toledo, OHS/N 18052338

Back to AD 87-20-03 R2