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.

N8062PSierra Two Holdings LLC · Vernon, CTBuilt 1982 · S/N 32-8206019 N8062TDitullio Peter C · Fallbrook, CABuilt 1981 · S/N 32R-8229027 N8062WGolden Wings Aviation LLC · Kamas, UTS/N 28-2142 N8063CHigh Planes Aviation LLC · Goodland, KSBuilt 1975 · S/N 28-7690100 N8063NDean Ralph G · Alfred, MEBuilt 1968 · S/N 28-25313 N8063THeauser Frederick M · Grass Valley, CAS/N 32-8206018 N8064WSled Aviation LLC · Prosper, TXBuilt 1965 · S/N 28-2146 N8064XDodson International Parts Inc · Rantoul, KSBuilt 2022 · S/N 2881516 N8065CArrow Air LLC · Sioux Center, IABuilt 1975 · S/N 28R-7635129 N8065NSotelo Kaleb N · Visalia, CABuilt 1968 · S/N 28-25315 N8065WGard Roger L · Danville, IAS/N 28-2147 N8066NSouthern Air Services LLC · Myakka City, FLBuilt 1968 · S/N 28-25316 N8066WWilson Jamal Abdul · White Plains, MDBuilt 1965 · S/N 28-2151 N8067NCsp Avionics LLC · Knoxville, TNBuilt 1968 · S/N 28-25317 N8068CThunderbird Aircraft Company · Bloomington, MNBuilt 1981 · S/N 28-8216099 N8068JGo Vertical Aviation LLC · Russellville, ALBuilt 1981 · S/N 28-8290084 N8068WRkd Flier Inc · Nemaha, IABuilt 1965 · S/N 28-2154 N8068ZBasco John J · Pottstown, PABuilt 1981 · S/N 28-8290086 N8069AInfinity Aviation St Cloud LLC · Rice, MNBuilt 1981 · S/N 32R-8213027 N8069NRajski Douglas S · Freeburg, ILBuilt 1968 · S/N 28-25319 N8069SGates Joel L · Salida, COBuilt 1981 · S/N 32R-8229028 N8069WAdventures In The Sky Aviation LLC · Fresno, CABuilt 1965 · S/N 28-2155 N806BBNoyes Jimmy D · Fruitland, IDBuilt 1972 · S/N 28R-7235295 N806CWWilling John W · Grove City, OHBuilt 1965 · S/N 28-2152 N806NDMob Aviation USA LLC · Auburndale, FLBuilt 1988 · S/N 2837009 N80702Over The Numbers LLC · Churchville, PABuilt 1981 · S/N 32R-8229030 N8070RRegistration Pending · Austin, TXRegistration pendingS/N 32R-8229029 N8070WMordini Robert D · Grand Marais, MNFirst renewal noticeS/N 28-2156 N8071NFigone David Anthony · Williams, AZBuilt 1968 · S/N 28-25321 N8071SNolan Cynthia M · Rimrock, AZBuilt 1981 · S/N 28-8216102 N8071WFernandez Gregory · San Antonio, TXBuilt 1965 · S/N 28-2158 N8071XFlorida Aviation Career Training Inc · Saint Augustine, FLS/N 28-8216103 N8071YFrost Aviation Services Inc · Las Cruces, NMBuilt 1981 · S/N 28-8216104 N8071ZScanlon Daniel T Jr · East Greenwich, RIBuilt 1981 · S/N 28-8290087 N8072HDuncan Anthony · Princeton, NJBuilt 1979 · S/N 28R-7931295 N8072TLane Aviation LLC · Tijeras, NMBuilt 1979 · S/N 28-7911307 N8072YStoraker Kjetil · Mckinney, TXBuilt 1979 · S/N 28-7911315 N80731Herman Robert W · Vineyard Haven, MABuilt 1981 · S/N 28-8290089 N8073NKiwi Choppers LLC · Hillsboro, ORBuilt 1968 · S/N 28-25323 N8074TWilliams Evan H · Sebastopol, CABuilt 1979 · S/N 28-8090062 N80756Badeaux William C Jr · La Porte, TXBuilt 1979 · S/N 28-8016047 N8075CGuest Stephen J · El Cajon, CABuilt 1979 · S/N 28-8090064 N8075EBlue Sky Flying Club LLC · Granger, IABuilt 1979 · S/N 28-8090065 N8075HMoore David S · Shrewsbury, MAS/N 28R-7931299 N8075MKrull Benson D · West Richland, WABuilt 1979 · S/N 28R-7931302 N8075QG-Force Aviation LLC · Surprise, AZBuilt 1981 · S/N 28R-8231026 N8075WPale Horse Imports Inc · Shingletown, CABuilt 1965 · S/N 28-2163 N8075XBruce Jerry W II · Starkville, MSBuilt 1979 · S/N 28-8016044 N80765Taylor Kyle T · Texas City, TXS/N 28-8016045 N80769Tucker Robert O · Savannah, GABuilt 1979 · S/N 28-8090066

Back to AD 87-08-08 R3