Skip to content

Registered aircraft · 54,017

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-20-03-R2') 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-20-03-R2') 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-20-03-R2')
    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-20-03-R2')
  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-20-03-R2')
  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-20-03-R2')
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.

N50276Pense Richard L · Katy, TXBuilt 1968 · S/N 15069188 N5027DTucker Austin L · Spooner, WIBuilt 1958 · S/N 51127 N5027EMeister James E · New Richmond, WIBuilt 1958 · S/N 50327 N5027RVentura Hector E · Vieques, PRS/N 17263268 N50283Sanchez Oscar A Blanco · Portsmouth, VAS/N 15069194 N50284Dunaire LLC · Mechanicsburg, PABuilt 1968 · S/N 15069195 N50286Baue Michael G · Foristell, MOBuilt 1968 · S/N 15069197 N5028AVonszilassy Peter · Fredericksburg, VABuilt 1955 · S/N 28028 N5028DSanders Jess E · Troy, MTBuilt 1958 · S/N 51128 N5028RSmith Ray C Jr · Sault Sainte Marie, MIBuilt 1976 · S/N 18502981 N50291Euros Aircraft Leasing LLC · College Station, TXBuilt 1974 · S/N 17264199 N50292Wheeler Richard Edmond III · Norfolk, VABuilt 1968 · S/N 15069201 N50297Eddleston Ryan · Winter Haven, FLBuilt 1968 · S/N 15069206 N50299Wood Thomas J · Overland Park, KSBuilt 1968 · S/N 15069208 N5029DUrban Cowboy Aviation LLC · Richland, NES/N 51129 N502CSIsr Platforms LLC · Mclean, VABuilt 1966 · S/N 337-0280 N502KWWhite Kenneth E · Lakeland, FLBuilt 1976 · S/N 15079064 N502RKKuehne Tracy · Pensacola, FLBuilt 1973 · S/N 15075370 N502TMDraco Flight School Inc · Chino, CABuilt 1975 · S/N 17265893 N502TVShyena Aviation LLC · Henderson, NVBuilt 1981 · S/N R18201704 N502WACommodore Jr Paul S · Tinton Falls, NJS/N 177RG0664 N50304Reuben Abraham · Flushing, NYBuilt 1968 · S/N 15069211 N50308Villano Frank P · Wappingers Falls, NYBuilt 1968 · S/N 15069215 N50310Richards Lyle · San Diego, CABuilt 1968 · S/N 15069217 N50311Khamo Josef · Running Springs, CABuilt 1968 · S/N 15069218 N50316Foster Reynolds Sw · Winona, MNBuilt 1968 · S/N 15069222 N50318Florida Fast Boats LLC · Palm Coast, FLBuilt 1968 · S/N 15069224 N5031AEggum Jeramy J · Puyallup, WABuilt 1955 · S/N 28031 N50323Got Valentin L · Olivehurst, CAFirst renewal noticeS/N 15069228 N50326Thompson Arthur W · Paris, TXBuilt 1968 · S/N 15069229 N50328Neiger Steven · Ocean View, NJBuilt 1968 · S/N 15069231 N5032DAirborne Holdings Inc · Midlothian, TXBuilt 1956 · S/N 33498 N50331Sale Reported · Nashotah, WISale reportedBuilt 1968 · S/N 15069233 N50335Joung Kweon · Cumming, GABuilt 1968 · S/N 15069235 N50337Nava Alfred Joseph II · Gig Harbor, WABuilt 1968 · S/N 15069236 N5033AAloof Aviation LLC · Denver, COBuilt 1955 · S/N 28033 N5033REastern Cincinnati Aviation Inc · Batavia, OHBuilt 1974 · S/N 17263274 N50345Stanley345 LLC · Esko, MNS/N 15069242 N50347Garrett Dennis R · Hudson, FLS/N 15069244 N5034EBurns Joyce A · Sparta, MOBuilt 1958 · S/N 50334 N5034HHernandez Dorothy V · Juneau, AKBuilt 1975 · S/N 17265309 N50354N50354 LLC · Key West, FLBuilt 1968 · S/N 15069249 N50355Kurpgeweit William E · Ewing, NEBuilt 1968 · S/N 15069250 N50356Meyers Meade M · Rockwood, PABuilt 1968 · S/N 15069251 N5035TJettime10 LLC · Grayslake, ILBuilt 1964 · S/N 18255231 N50367American Sky Aviation LLC · Anna, TXBuilt 1968 · S/N 15069255 N50368Rogers Warren R · Manti, UTS/N 15069256 N5036DPfeil Carl A · Mendocino, CABuilt 1958 · S/N 51136 N5036RArctic Winds Inc · King Salmon, AKS/N R18200628 N50375Mcburney Cleland V · Kingman, KSBuilt 1968 · S/N 15069260

Back to AD 87-20-03 R2