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.

N8076WTipton James · Hot Springs, ARBuilt 1965 · S/N 28-2165 N8077H8077h LLC · Southington, CTBuilt 1979 · S/N 28-8090067 N8077NRodgers Wesley T · Enterprise, ALS/N 28-25328 N8077QWakefield Robert · Toccoa, GABuilt 1979 · S/N 28-8090069 N8077RIscovich Mario S · Thousand Oaks, CABuilt 1979 · S/N 28-8090070 N8077WN8077w Inc · Bloomfield Hills, MIBuilt 1979 · S/N 28-8090072 N8077YMagenta Line LLC · Geneva, NYBuilt 1982 · S/N 32R-8213029 N80785Campbell Air LLC · Angola, INBuilt 1979 · S/N 28-8090077 N8078RKhozam George · Murrieta, CABuilt 1979 · S/N 28-8090073 N8078ZL & A Bennett Second Family Lp · Renton, WAS/N 28-8090076 N8079WFox Michael · Winfield, KSBuilt 1965 · S/N 28-2168 N8079YKaszuba Peter M · Bradenton, FLBuilt 1979 · S/N 28-8016049 N807APTexas South Wind Aviation LLC · Kenedy, TXBuilt 1975 · S/N 28-7615086 N807DAMays Gloriaj · College Station, TXBuilt 1977 · S/N 28-7816227 N807FPM&A Industrial Construction LLC · Atkinson, NEBuilt 1977 · S/N 32R-7780518 N807MSGilbert Allyn E · Grass Valley, CABuilt 1988 · S/N 2837010 N807TFAir Fleet Holdings LLC · Addison, TXBuilt 2024 · S/N 2881700 N807WMGriswold George B III · Cedar Point, NCBuilt 1967 · S/N 28R-30186 N8080AChapel Hill Flying Club Inc DBA · Sanford, NCBuilt 1979 · S/N 28-8016051 N8080UMaas Justin J · Columbus, INBuilt 1977 · S/N 28R7737056 N8081GGonzalez Biorky · Atoka, TNBuilt 1979 · S/N 28-8016053 N8081PCraner Andrew · Richfield, IDBuilt 1979 · S/N 28-8016056 N8082HWalters Glenn L · Triadelphia, WVBuilt 1979 · S/N 28-8016059 N8082KWood Roger E · Waxhaw, NCBuilt 1979 · S/N 28-8016060 N8082WWallace Louis Wayne · Sherman, TXBuilt 1965 · S/N 28-2172 N80834Odom Kirkland R Jr · Clayton, NCBuilt 1979 · S/N 28-7911312 N80838Green Timothy R · Marblehead, MABuilt 1979 · S/N 28-7911313 N8083LLoofbourrow Eric A · Livermore, CAS/N 28-8090080 N8083VMorris Allyn D · Woodinville, WABuilt 1979 · S/N 28-7911309 N8083WNedelea Traian · Katy, TXBuilt 1965 · S/N 28-2173 N8083YJuliet Deltaahh LLC · Vero Beach, FLBuilt 1979 · S/N 28-7911310 N8084NBlack Tie Limousine LLC · Springville, ALBuilt 1981 · S/N 28-8290090 N8084WFieldgrove Matt L · Somerton, AZBuilt 1965 · S/N 28-2174 N80853Candace A Larned Enterprises Inc · Long Beach, CABuilt 1979 · S/N 28-8090082 N8085ALane Community College · Eugene, ORBuilt 1979 · S/N 28-8016065 N8085WFireside Aviators Assn Corp · San Jose, CAFirst renewal noticeBuilt 1965 · S/N 28-2175 N8085XGorkes Richard E Jr · Lilburn, GABuilt 1979 · S/N 28-8016068 N8085ZJli Partners Inc · Miami, FLBuilt 1979 · S/N 28R-7918260 N8086ECoker Chadwick Daryl · Goldsboro, NCS/N 28-8090083 N8086GMason Aviation Club LLC · Mason, MIBuilt 1979 · S/N 28-8090084 N8086HCloud Catcher Aviation LLC · Great Falls, MTBuilt 1979 · S/N 28-8090085 N8086KClubs 2 LLC · Calabasas, CABuilt 1979 · S/N 28-8090086 N8086NDakota Group Inc · Rockaway, NJBuilt 1979 · S/N 28-8011052 N8086RColburn Richard S · Fort Mohave, AZS/N 28R-8231027 N8087BMach Point One LLC · Nashville, TNBuilt 1982 · S/N 32-8206022 N8087CHartzell Propeller Employees Flying Club · Piqua, OHBuilt 1979 · S/N 28-7911317 N8087DRa Aviation Services LLC · Sorrento, FLBuilt 1979 · S/N 28-7911318 N8087EJd Aviation Inc · Muskegon, MIBuilt 1979 · S/N 32R-8029019 N8087WCampbell James A · Brighton, MIBuilt 1981 · S/N 28-2177 N80886Kellow Sherman Lee · Lebanon, TNS/N 28-7921055

Back to AD 87-08-08 R3