Skip to content

Registered aircraft · 26,231

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:94-05-05-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-05-05-R1') 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:94-05-05-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-05-05-R1')
  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:94-05-05-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-05-05-R1')
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.

N502KWWhite Kenneth E · Lakeland, FLBuilt 1976 · S/N 15079064 N502RKKuehne Tracy · Pensacola, FLBuilt 1973 · S/N 15075370 N50304Reuben Abraham · Flushing, NYBuilt 1968 · S/N 15069211 N50308Villano Frank P · Wappingers Falls, NYBuilt 1968 · S/N 15069215 N5030HWharton Maya · Anchorage, AKBuilt 1949 · S/N 11-910 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 N5031HFrison Joyce · Whitewater, WIBuilt 1949 · S/N 11-911 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 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 N50347Garrett Dennis R · Hudson, FLS/N 15069244 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 N50367American Sky Aviation LLC · Anna, TXBuilt 1968 · S/N 15069255 N50368Rogers Warren R · Manti, UTS/N 15069256 N5036HVan Winkle Randy M · Van Buren, MOS/N 11919 N50375Mcburney Cleland V · Kingman, KSBuilt 1968 · S/N 15069260 N50379Grosdidier Rolland J · Kenai, AKBuilt 1968 · S/N 15069263 N5037HRegistered aircraftBuilt 1949 · S/N 11-920 N50382Eastside Aero Inc · Eatonville, WABuilt 1968 · S/N 15069264 N5038HMeggers Roger D · Baker, MTS/N 11-921 N50390Dillard Clayton B · Talkeetna, AKBuilt 1968 · S/N 15069269 N5039ASutton Aircraft Salvage LLC · Palmer, AKBuilt 1955 · S/N 28039 N503ETar Dennis W · Summerfield, NCBuilt 1956 · S/N 28361 N503SDSimmons Mark · Madison, MSFirst renewal noticeBuilt 1974 · S/N 15076056 N503VERegistration Pending · Fort Worth, TXRegistration pendingBuilt 1980 · S/N 503 N50400Bostick Alva D H · Portsmouth, OHBuilt 1968 · S/N 15069274 N50403Reis Gavin · Conway, SCS/N 15069277 N50404Mcflight Aviation LLC · Highland, UTBuilt 1968 · S/N 15069278 N50405Und Aerospace Foundation · Grand Forks, NDBuilt 1968 · S/N 15069279 N50406Aeroplanes Over Idaho Inc · Carson City, NVS/N 15069280 N50407Coombs Kevin A · Knoxville, TNS/N 15069281 N5040APark Kyle Hunter · Jefferson City, MOS/N 28040 N50413Rafi Adnan · Olean, NYS/N 15069286 N50418Forrest City Aircraft Club · Rockton, ILS/N 15069289 N50419Hamilton Richard Paul · Laredo, TXBuilt 1968 · S/N 15069290 N5041AMccollough Bruce S · Skandia, MIBuilt 1955 · S/N 28041 N50421Franco Gary R · Chico, CABuilt 1968 · S/N 15069291 N50425Keneston Mark G · Ballston Spa, NYBuilt 1968 · S/N 15069295 N50431Board Susan W · Moundsville, WVBuilt 1968 · S/N 15069298 N50432Mountain Air Flying Club Inc · Clarksburg, WVBuilt 1968 · S/N 15069299

Back to AD 94-05-05 R1