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.

N8343RLedford Larry L · Stone Mountain, GABuilt 1966 · S/N 28-22217 N8343URiley Air LLC · Phoenixville, PAS/N 32R-8329008 N8343WWaid Fred M · Abilene, TXS/N 28-2527 N8344VStandley Joseph · Lake In The Hills, ILBuilt 1982 · S/N 28-8316035 N8345CChristofersen Jon E · Batavia, ILBuilt 1976 · S/N 28-7615092 N8345RKlad-Air LLC · Catlett, VABuilt 1966 · S/N 28-22219 N8345ZTrident Aircraft Inc · Easton, MDBuilt 1981 · S/N 28-8116167 N8346CBroyles Richard M · Wildwood, MOBuilt 1976 · S/N 28-7690120 N8346HAir Jay West LLC · Winnetka, CABuilt 1981 · S/N 28-8190180 N8346NFleetcraft Transportation LLC · Naperville, ILBuilt 1981 · S/N 28-8190181 N8346STravel Express Aviation LLC · West Chicago, ILBuilt 1981 · S/N 28-8190182 N8346TMoradi Mark M · Orlando, FLBuilt 1981 · S/N 28-8190183 N8346WBurns C R · Huntsville, ALBuilt 1965 · S/N 28-2532 N8347CTriple R D2 Jmw Corp · Saint Cloud, MNBuilt 1976 · S/N 28-7690121 N8347WKirk Kevin J · Pulaski, PABuilt 1981 · S/N 32R-8113049 N83484Doumit Patrick F · Cathlamet, WAS/N 28R-8131097 N83486Arrow Aviation LLC · Scottsdale, AZBuilt 1981 · S/N 28R-8131098 N8348GChelmsford Flyers LLC · Chelmsford, MARegistration ineffective or invalidBuilt 1981 · S/N 32R-8113050 N8348HRogers Gary J · Massapequa, NYBuilt 1981 · S/N 32R-8113051 N8348RMorris Jeff L · Radcliffe, IAS/N 28-22223 N8348WAmerican Equipment Sales Inc · Lawrence, KSBuilt 1965 · S/N 28-2535 N8349WGrayhawk Flight Training LLC · Lucas, TXBuilt 1965 · S/N 28-2536 N834DVVeith Donald C · Cattaraugus, NYBuilt 1972 · S/N 28-7305159 N834HPNewman Aviation Services Inc · Tiffin, OHBuilt 2006 · S/N 3257426 N834NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2020 · S/N 2881304 N834TFAir Fleet Holdings LLC · Missoula, MTBuilt 2024 · S/N 2881707 N8350RPerinoni Edward Jr · Novato, CABuilt 1966 · S/N 28-22225 N8350WJr Aviation Holdings LLC · Newark, DEBuilt 1965 · S/N 28-2538 N8351WQuality Aero LLC · East Aurora, NYBuilt 1981 · S/N 28-8116176 N8352DScarlet Wings LLC · Brunswick, OHBuilt 1981 · S/N 28-8116179 N8352RQuantum Aviation LLC · Wauna, WABuilt 1966 · S/N 28-22227 N8352TFlight Inc · Lakewood, COBuilt 1981 · S/N 28-8190187 N8352WLebanon Flying Club · Lebanon, MOBuilt 1965 · S/N 28-2540 N8353COstwinkle Jeffrey J · Justin, TXBuilt 1976 · S/N 28R-7635152 N8353DKauffman Land & Development LLC · Fort Lupton, COBuilt 1981 · S/N 28-8190189 N8353HThompson Rufus · Oceanside, CABuilt 1981 · S/N 28-8111054 N8353RSchrandt Mark L · Shoreview, MNBuilt 1966 · S/N 28-22228 N8353WN8353w Flyers LLC · North Las Vegas, NVS/N 28-2542 N83540Red Tail Scholarship Foundation · Tuskegee, ALBuilt 1981 · S/N 28-8190190 N8354CTayab Farooq · Allen, TXBuilt 1976 · S/N 28-7690122 N8354QKandravi Enterprises Inc · Centereach, NYBuilt 1981 · S/N 32-8106050 N8354RStonebrink Grant · Boonton, NJBuilt 1966 · S/N 28-22229 N8354WCoombs Eric S · Louisburg, NCBuilt 1965 · S/N 28-2543 N8354YMiles Dan · Saint Augustine, FLBuilt 1981 · S/N 32-8106051 N8355EHigh Noon Leasing LLC · Anchorage, AKBuilt 1981 · S/N 32R-8113052 N8355HLjmf 17 LLC · Hays, KSBuilt 2001 · S/N 3257204 N8355XSkyway Leasing Co Inc · Yakima, WABuilt 1981 · S/N 32R-8129053 N8356WSmith Randall K · Wilton, CABuilt 1965 · S/N 28-2547 N8357RRegistration Pending · Fort Worth, TXRegistration pendingBuilt 1966 · S/N 28-22233 N8358RHight Mayon C · Snohomish, WABuilt 1966 · S/N 28-22234

Back to AD 87-08-08 R3