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.

N8034ZEight Ball Flying Club Inc · Van Nuys, CABuilt 1981 · S/N 32-8206016 N80368Registration Pending · Augusta, KSRegistration pendingBuilt 1981 · S/N 28-8216085 N8036DN 8036d LLC · Brownsburg, INBuilt 1981 · S/N 32R-8213021 N8037WUtterback Harry Lee · Prescott, AZBuilt 1965 · S/N 28-2104 N80392Ernest Beier · Mickleton, NJBuilt 1981 · S/N 28-8211021 N803TWGsfcpp Corp · Palm City, FLBuilt 1968 · S/N 28-5117 N803WWHarmon Louie · Gainesboro, TNS/N 28-2102 N8040WJeff Abrams-2 LLC · Ocala, FLBuilt 1965 · S/N 28-2108 N8041BIchtou LLC · Dover, DEBuilt 1981 · S/N 32R-8213022 N8041HKing Ag Leasing Inc · Sudan, TXBuilt 1981 · S/N 32R-8229022 N8041MLewis Edward H · Moorestown, NJBuilt 1981 · S/N 32R-8229023 N8041WBas Part Sales LLC · Greeley, COBuilt 1965 · S/N 28-2110 N80426Pcb Aviation LLC · Davidson, NCBuilt 1983 · S/N 32-8306028 N8042GTemple In The Sky LLC · Marietta, GABuilt 1981 · S/N 32R-8229024 N8043WMcabee Aviation LLC · Fresno, CABuilt 1965 · S/N 28-2112 N80441Archer Aircraft LLC · Wilmington, DEBuilt 2019 · S/N 2881235 N8044NN7396w LLC · Coeymans Hollow, NYBuilt 1968 · S/N 28-25289 N8044TArcher Aircraft LLC · Wilmington, DEBuilt 2019 · S/N 2881234 N8044WKananen Agency Inc · Joliet, MTBuilt 1965 · S/N 28-2114 N8045WOpen Engineering LLC · Ames, IABuilt 1965 · S/N 28-2919 N8046RComputer Solutions Inc · Casper, WYBuilt 1981 · S/N 28-8211022 N8046WMuthandi John M · Woodland, WABuilt 1965 · S/N 28-2116 N8047SRisso Christopher W · Huntington Beach, CABuilt 1981 · S/N 32R-8229025 N8047WFlying Fossil LLC · Franklin, TNBuilt 1965 · S/N 28-2119 N8048CDegraff Claude Md · Fort Myers, FLBuilt 1975 · S/N 28-7625093 N8049NKolbjornsen Arne · Middletown, DES/N 28-25295 N8051NSapienza Gregory T · Williamstown, NJBuilt 1969 · S/N 28-25298 N8051VAv8 Flight Assets LLC · Eden Prairie, MNBuilt 2021 · S/N 2881106 N8051WMcginn Gary P · Elk City, OKBuilt 1965 · S/N 28-2124 N8052NBcaeronautics LLC · Houston, TXBuilt 1968 · S/N 28-25299 N8052TAtd Pilot Training LLC · Kansas City, MOBuilt 1981 · S/N 28-8216091 N8052WTaylor Robert E · Haines City, FLBuilt 1965 · S/N 28-2125 N8053NJump Ventures LLC · Key West, FLBuilt 1968 · S/N 28-25300 N8054BSkycrafters Inc · Johnson City, TNBuilt 1981 · S/N 28-8211023 N8054CMitchell Craig · Tucson, AZBuilt 1975 · S/N 28-7615074 N8054SMccrea Stephen M · Eatonton, GABuilt 1981 · S/N 28-8290077 N8055CSea 2 Sea LLC · Cantonment, FLS/N 28-7690099 N8055VSandler Sergey · Golden Beach, FLBuilt 1981 · S/N 288290078 N8056BChandler Air Service Inc · Chandler, AZBuilt 1981 · S/N 28R-8218011 N8057NTrisauskas Kestutis · Hazlet, NJBuilt 1968 · S/N 28-25305 N8057WMarsh John T Jr · Athens, GABuilt 1965 · S/N 28-2134 N8058WPierce Allen L · Douglas, WYBuilt 1965 · S/N 28-2135 N8059RTravel Express Aviation LLC · West Chicago, ILBuilt 1981 · S/N 28-8290081 N805AMOrtega Aviation Services LLC · Wichita, KSBuilt 2021 · S/N 28020036 N805MAKpanda Aviation LLC · Peoria, ILBuilt 2022 · S/N 2881585 N8060NWind Island LLC · Darien, ILBuilt 1968 · S/N 28-25309 N8060USluka Christopher J · San Diego, CABuilt 1981 · S/N 28-8290083 N8060WSchroeder Jeffry S · Springfield, ILS/N 28-2139 N8061NNorth Florida Flyers LLC · Green Cove Springs, FLBuilt 1969 · S/N 28-25310 N8061WReardon Christopher · Chicago, ILS/N 28-2140

Back to AD 87-08-08 R3