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.

N8095WSkierka Michael A · Browning, MTBuilt 1965 · S/N 28-2189 N80964Three Wing Flight School LLC · Stratford, CTBuilt 1981 · S/N 28-8216108 N80968Wisconsin Aviation Inc · Watertown, WIBuilt 1979 · S/N 28-8016087 N8096JBullgoose Aviation Inc · York, PANon-citizen corporation, flight hours not reportedBuilt 1979 · S/N 32R-8029006 N8096QHoover Charles J · Logansport, INBuilt 1981 · S/N 28-8216107 N8096SFreedom Aircraft Jv 1 LLC · Milton, FLBuilt 1979 · S/N 32R-8013006 N8096VPlatt Philip L · Concho, AZBuilt 1979 · S/N 32R-8013007 N8096WRoberts Heather V · Birmingham, ALBuilt 1965 · S/N 28-2190 N8097CImmell Michael · Buffalo, OKBuilt 1975 · S/N 32-7640052 N8097HMiloud Chadd K · Fort Worth, TXBuilt 1979 · S/N 28-8016092 N8097JAjdari Rodmehr · Millville, NJBuilt 1979 · S/N 28-8016093 N8097PEmery Jonathan D · Payson, AZBuilt 1979 · S/N 28-8090106 N8097QHissey Mark E · Fannettsburg, PABuilt 1980 · S/N 28-8090107 N8097SBrookwood Plastering Inc · San Diego, CABuilt 1979 · S/N 28-8090108 N8098BIowa Aircraft Inc · Burlington, IABuilt 1979 · S/N 28-8090110 N8098MRock Solid Aviation LLC · Lake Charles, LABuilt 1979 · S/N 28-8090111 N8098NBlessing Gary · Cape Coral, FLBuilt 1968 · S/N 28-25342 N8098RSomerset Air Service Inc · Bedminster, NJBuilt 1979 · S/N 28R-8018003 N8099NArthur Kezian Inc · Los Angeles, CABuilt 1979 · S/N 28-8011002 N8099QKocher Gary E · Bellingham, WAS/N 28-8011004 N8099VGrannetino Gerald F · West Chester, PABuilt 1971 · S/N 32-7140072 N8099WClarion County Flight Club LLC · Shippenville, PABuilt 1965 · S/N 28-2194 N809MBerkshire Aviation Enterprises LLC · Great Barrington, MABuilt 1977 · S/N 28R-7837015 N809MAStraw Robert D · Farmington, MNS/N 28-23712 N809TFAir Fleet Holdings LLC · Missoula, MTBuilt 2024 · S/N 2881702 N80BRN80br LLC · Port Orange, FLBuilt 1967 · S/N 32-913 N80DJShireman Kirk A · Pearland, TXBuilt 1981 · S/N 32R8129081 N80FGFlightgest Academy LLC · Morrisville, NCBuilt 2022 · S/N 2881562 N80FTWifa (Washington International Flight Academy) LLC · Gaithersburg, MDBuilt 2000 · S/N 2842078 N80KARowe Andrew · Palmdale, CABuilt 1972 · S/N 28R-7235166 N80KPMacstam Air LLC · Robins, IABuilt 1980 · S/N 28R-8018090 N80MLBishop Jack · Sabina, OHBuilt 1980 · S/N 28R-8018007 N80PDGatpandan Grace Michele V · Martinez, CABuilt 1967 · S/N 28-4044 N80UMGoodman Christopher W · Hammond, LABuilt 1979 · S/N 28R7918090 N81006Wicked Wings LLC · Norwood, NCBuilt 1979 · S/N 32R-8013010 N8100NSpeicher Peter · Grand Forks, NDBuilt 1968 · S/N 28-25288 N8100WWaggoner Alan L · Blanchard, OKBuilt 1965 · S/N 28-2195 N81013Saratoga N81013 LLC · Santa Rosa Beach, FLBuilt 1979 · S/N 32R-8013013 N81014Beccario Joseph P · Sault Sainte Marie, MIBuilt 1979 · S/N 28-8090112 N81016Lane Community College · Eugene, ORBuilt 1979 · S/N 28-8016095 N8101WMccooknet Inc · Mccook, NEBuilt 1965 · S/N 28-2197 N81021Paris Air Inc · Vero Beach, FLBuilt 1979 · S/N 28-8016106 N81023Boettinger John G · Oak Lawn, ILBuilt 1979 · S/N 28-8016108 N81024Jonsson Erik · Twin Falls, IDBuilt 1979 · S/N 28-8016109 N8102BDayton Stephen · Littleton, NHS/N 28-8016099 N8102HEklof Gary L · Wayzata, MNBuilt 1979 · S/N 28-8016101 N8102SJl Holdings Ntx LLC · Flower Mound, TXBuilt 1979 · S/N 28-8016104 N8102WGutierrez Juan · Sarasota, FLBuilt 1965 · S/N 28-2198 N81034Registered aircraftBuilt 1979 · S/N 28-8090120 N81036Precision Aviation LLC · Fayetteville, GABuilt 1979 · S/N 28-8090121

Back to AD 87-08-08 R3