Skip to content

Registered aircraft · 72,001

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-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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.

N16299Piper Niner Niner LLC · Evansville, INBuilt 1973 · S/N 28-7310084 N1629EAnson Air LLC · Sugar Land, TXBuilt 1978 · S/N 17271072 N1629JBuckley Barney P · Colfax, WABuilt 1967 · S/N 28-24016 N162ACWatson Tommy R · Thibodaux, LABuilt 1997 · S/N 1235-97 N162ASA S Air LLC · Lantana, FLBuilt 1978 · S/N 17271785 N162AVPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010078 N162AWSchiller Gottfried · Englewood, FLS/N 18-8109082 N162BCRegistration Pending · Tampa, FLRegistration pendingBuilt 2004 · S/N 465-2004 N162CSFrielingsdorf Tim Richard · Manvel, TXBuilt 1998 · S/N 18280192 N162DSDavid Y Stevens · Falcon, COBuilt 2009 · S/N 90695 N162FCSanders Racing Inc · Jasper, ALS/N 135 N162GMMiltenberger Roger J · Sergeant Bluff, IABuilt 1990 · S/N 162 N162HDWolfenden Enterprises Inc · Vero Beach, FLBuilt 1981 · S/N 17274762 N162KMerge Mafia LLC · Wall, TXBuilt 1959 · S/N 18-7171 N162LHFarmingdale State College · Farmingdale, NYBuilt 2010 · S/N 2842361 N162MEIasco Flight Training Inc · Redding, CABuilt 2000 · S/N 172S8442 N162PMFrench Loren · Gypsum, COBuilt 1963 · S/N 30-72 N162RVAcord John R · Hattiesburg, MSBuilt 2004 · S/N 23143 N162WTFly Whiskey Tango 2 LLC · Scottsdale, AZBuilt 1984 · S/N 17276202 N16304Stockmeier Steven J · Liberty Twp, OHBuilt 1973 · S/N 28-7325237 N16305Fross James B · Wichita, KSBuilt 1973 · S/N 28-7305221 N1630JPiston Aviation LLC · Saint Charles, MOBuilt 1967 · S/N 28-24017 N1630PSmith Richard D · Williamstown, OHBuilt 1954 · S/N 22-2444 N16311Toxen Robert M · Fort Lauderdale, FLBuilt 1973 · S/N 28R-7335124 N16313Sanders Christopher Scott · Knoxville, TNBuilt 1973 · S/N 28-7310085 N16317Wolf Aviation Network Inc · Westfield, MABuilt 1973 · S/N 28-7325223 N16318Enbom Brian Trustee · Discovery Bay, CABuilt 1973 · S/N 28-7325241 N16319Bethers Michael R · New Market, MDBuilt 1973 · S/N 28-7305224 N1631ESkywarrior Flight Training LLC · Pensacola, FLBuilt 1978 · S/N 17271073 N1631GSwiger Cale W · Hendersonville, TNBuilt 1968 · S/N 127 N1631JReds Aircraft LLC · Edinburg, TXBuilt 1969 · S/N 28-25416 N16320Basurto Kathryn A · Sacramento, CABuilt 1973 · S/N 28-7305225 N16321Chamberlain Frederick L · Tavernier, FLBuilt 1973 · S/N 28R-7335126 N16322Liggett Esaias Martin · Union, KYBuilt 1973 · S/N 28-7310086 N16329Greensite Phillip M · Walton, KYBuilt 1973 · S/N 28R-7335129 N1632EXin Han Aviation LLC · Atwater, CABuilt 1978 · S/N 17271074 N1632HM & B Aero LLC · York, PABuilt 1977 · S/N 28-7790319 N1632JDavid A Bowden · Duncan, OKBuilt 1968 · S/N 28-24019 N1632PWilley Larry E · Fremont, OHBuilt 1954 · S/N 22-2446 N16332Brown Chritopher M · Lake Helen, FLBuilt 1973 · S/N 32-7300023 N1633CUS Aviation Training Solutions (Usats) · Titusville, FLBuilt 2005 · S/N 0208 N16340Schwartz Gregg M · Ambler, PABuilt 1973 · S/N 28-7325245 N16341Schmitz Frederick · Atlanta, GAS/N 28-7325246 N16343Starlight Real Estate Investments Inc · Punta Gorda, FLS/N 115 N16348Mcelyea Shawn T · Aledo, TXBuilt 1973 · S/N 28-7325249 N1634JLemaire Norman J Jr · Taunton, MABuilt 1968 · S/N 28-24021 N16350Dunn Mitchell R · Hayden, ALS/N 28-7305229 N16351Degraaff Norman L · Friday Harbor, WABuilt 1973 · S/N 28-7305231 N16357Ktup Aviation LLC · Belden, MSBuilt 1973 · S/N 28-7325253 N16359Skinner Colin L · Hartland, VTBuilt 1973 · S/N 28-7305233

Back to AD 87-10-06 R1