Skip to content

Registered aircraft · 22,416

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-08-08-R3') 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-08-08-R3') 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-08-08-R3')
    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-08-08-R3')
  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-08-08-R3')
  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-08-08-R3')
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.

N9096WYenne Ralph M · Salem, ORBuilt 1966 · S/N 28-10820 N90977Mouse Air LLC · Hilton Head Island, SCBuilt 1981 · S/N 32R-8129048 N9097WLyvers Joseph D · Louisville, KYBuilt 1965 · S/N 28-10707 N9098GTravel Express Aviation LLC · West Chicago, ILBuilt 1985 · S/N 28-8616024 N9098JNelson Aircraft Sales Inc · Minot, NDBuilt 1966 · S/N 28-3140 N9098KD G Aircraft LLC · Lewes, DEBuilt 1985 · S/N 28-8616025 N9098WNeville Charles D · Chicago, ILBuilt 1965 · S/N 28-10708 N9099JEdwards Darron C · Lancaster, CABuilt 1966 · S/N 28-3141 N9099KWallace Jacob M · Central Point, ORBuilt 1977 · S/N 28R-7837028 N9099WFlying Monkeys LLC · Boulder City, NVBuilt 1965 · S/N 28-10710 N909JLAims Community College · Greeley, COBuilt 2019 · S/N 2881184 N909MAKenzy 2022 LLC · Castle Rock, COBuilt 2019 · S/N 2881186 N90BWSalter Scott A · Moscow, TNBuilt 1981 · S/N 32R-8129006 N90DDBas Part Sales LLC · Greeley, COS/N 32-7940072 N90ENWiggins Gene S · Americus, GAS/N 28-1219 N90FEPasley Michael Cole · Niceville, FLBuilt 1969 · S/N 28R-35121 N90MHMooers Michael T · Hagerstown, MDBuilt 1976 · S/N 28R-7635158 N90VWAero Cruise Ltd · Brighton, MIBuilt 1967 · S/N 28-4030 N9100WNegley Veronica L · Eloy, AZBuilt 1965 · S/N 28-10711 N9101JCarter David · Jackson, TNBuilt 1966 · S/N 28-3143 N9101THahn Derrick J · Combine, TXBuilt 1985 · S/N 28-8690019 N9101WHastert Christopher R · Goleta, CABuilt 1965 · S/N 28-10713 N9102JRaper Don A · Woodstock, GAFirst renewal noticeBuilt 1966 · S/N 28-3144 N9102KM & T Aircraft LLC · North Canton, OHBuilt 1977 · S/N 28R-7837029 N9102WWilson Joshua M · Port Saint Lucie, FLBuilt 1965 · S/N 28-10714 N9103WNelson Kevin J · Spring Creek, NVS/N 28-10716 N9104WWhite-Dicus Elizabeth Renee · Mount Washington, KYBuilt 1965 · S/N 28-10717 N9105QTalon Aviation Of Nc LLC · Winston Salem, NCBuilt 1986 · S/N 3213002 N9105TMcclellan Peter · Altus, OKBuilt 1985 · S/N 32R-8629003 N9105WRegistration Pending · Lago Vista, TXRegistration pendingBuilt 1965 · S/N 28-10718 N9105XHedgehopper Flying Club Inc · Springfield, MOBuilt 1986 · S/N 2890006 N9106JMc Nutt Richard Kevin · De Pere, WIBuilt 1966 · S/N 28-3148 N9106WBaker Kenneth R · Mc Calla, ALBuilt 1965 · S/N 28-10719 N9106YRegion Flyers LLC · Valparaiso, INBuilt 1985 · S/N 28-8616001 N91071Warrior II LLC · Zionsville, INBuilt 1985 · S/N 28-8616004 N91077Brown Patricia L · Destin, FLBuilt 1985 · S/N 28-8690023 N91079Gholson Travis R · Carmi, ILBuilt 1985 · S/N 28-8690024 N9107KBeidoun Bassam A · Auburn Hills, MIBuilt 1977 · S/N 32-7840029 N9107SMaul Errol T · Ocala, FLBuilt 1986 · S/N 2890010 N9108JCampbell Aircraft Restorations · London, KYBuilt 1966 · S/N 28-3150 N9108KHicks William A Jr · Mount Airy, NCBuilt 1977 · S/N 32R-7880032 N9108WCope James Brandon · Canyon, TXBuilt 1965 · S/N 28-10703 N9109QBurns Timothy M · Huntington, NYBuilt 1986 · S/N 2890011 N9109WJenkins Jon Richard · Kaufman, TXS/N 28-10715 N9109ZO'Neill Erik M · Williamsville, NYBuilt 1986 · S/N 2811002 N910GSRobinson Nicholas Anthony · Westborough, MABuilt 1976 · S/N 28R-7635029 N910MREcho Dynamics · La Mesa, CABuilt 1979 · S/N 28-7990549 N9110JRkd Aviation Services Inc · Dallas, TXBuilt 1966 · S/N 28-3152 N9110UPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28020280 N9110WRg Air LLC · Muscle Shoals, ALBuilt 1986 · S/N 3229002

Back to AD 87-08-08 R3