Skip to content

Registered aircraft · 1,267

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:80-26-04-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:80-26-04-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:80-26-04-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:80-26-04-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:80-26-04-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:80-26-04-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.

N500TDPacific Fleet Aviation LLC · Rochester, NYBuilt 1977 · S/N 27-7854027 N5018YHighland Rim Aviation LLC · Springfield, TNBuilt 1963 · S/N 27-2020 N501BCJamestown Jet Center Inc · Jamestown, NDBuilt 1973 · S/N 27-7305157 N5023YAas LLC · Ovid, MIBuilt 1962 · S/N 27-2027 N5038YAileron Buzz LLC · Daytona Beach, FLBuilt 1962 · S/N 27-2044 N5045YWingsolutions Corp · Miami Lakes, FLS/N 27-2054 N5064CEaton Roger C · Vernon, NYBuilt 1974 · S/N 27-7405376 N5071YFletchers Aviation LLC · Mason, NHS/N 27-2085 N5079YDiaz Apolo · Kansas City, MOBuilt 1962 · S/N 27-2097 N507JBDi Marco Michael G · Orlando, FLBuilt 1979 · S/N 27-7954051 N5081YDoumis Joy S · Marathon, FLBuilt 1962 · S/N 27-2099 N5082YTanner Greg · Bend, ORBuilt 1962 · S/N 27-2100 N5089YLewis Aaron J · Salado, TXS/N 27-2109 N5097YBlackburn Anthony C · Mcdonough, GABuilt 1962 · S/N 27-2122 N509GCN509gc LLC · Branford, CTS/N 27-7854086 N50CCScott Macdonald Aircraft Sales Inc · Stuart, FLBuilt 1974 · S/N 27-7405360 N50CSBoretsky Bryan F · Lolo, MTBuilt 1961 · S/N 23-1973 N5102YK F Aviation Inc · San Juan, PRBuilt 1962 · S/N 27-2127 N510ADDj Aztec LLC · Springfield, OHBuilt 1980 · S/N 27-8054044 N510DYoungs Water Conditioning Of Logansport LLC · Logansport, INS/N 27-7654024 N510GCSchramm Craig O · Fenton, MIBuilt 1964 · S/N 27-2681 N5125YTassopoulos Thomas · Flushing, NYBuilt 1962 · S/N 27-2158 N5157YChristine Flight Inc · Denver, COBuilt 1962 · S/N 27-2196 N517EASchafer Erich S · Fremont, MIBuilt 1975 · S/N 27-7554125 N5188YElliott William R · Reno, NVBuilt 1962 · S/N 27-2235 N51GCCragg Gordon E · Georgetown, TXBuilt 1966 · S/N 27-3516 N51HPJ R'S Downwind Aviation Inc · Lantana, FLBuilt 1974 · S/N 27-7405412 N51JNNaylor Aviation LLC · Scotch Grove, IABuilt 1978 · S/N 27-7854128 N5206YHart Lewis W DBA · Rexburg, IDBuilt 1962 · S/N 27-2254 N520AZSaydun LLC · Richardson, TXBuilt 1966 · S/N 27-3424 N5213YFlying High Again LLC · Mount Juliet, TNBuilt 1962 · S/N 27-2261 N5216YGv Air Inc · Medford, ORBuilt 1962 · S/N 27-2264 N521EEMhg Leasing LLC · Edgewood, KYBuilt 1979 · S/N 27-7954067 N5220YHart Robert D · The Villages, FLBuilt 1962 · S/N 27-2269 N5226YSale Reported · Miami, FLSale reportedBuilt 1963 · S/N 27-2275 N522CAC-140 Company LLC · Milton, FLBuilt 1971 · S/N 27-4711 N522ESkyfest Aviation Investments Inc · Daytona Beach, FLBuilt 1964 · S/N 27-2495 N5236YSvh Flying Operations LLC · Mooresville, NCBuilt 1963 · S/N 27-2289 N5253ALet Industries LLC · Lewes, DES/N 27-7654058 N5269YFlying K Aviation LLC · Quinlan, TXS/N 27-2334 N5272AWelch Kevin R · Hartland, WIBuilt 1961 · S/N 23-2019 N52EVPacific Fleet Aviation LLC · Rochester, NYBuilt 1979 · S/N 27-8054006 N52HFNorov Yury · Saint Augustine, FLBuilt 1964 · S/N 27-2568 N52WWPacific Fleet Aviation LLC · Rochester, NYBuilt 1981 · S/N 27-8154014 N5317YBaker Avery R · Bonifay, FLBuilt 1963 · S/N 27-2394 N5320YRawareo LLC · Warsaw, MOBuilt 1963 · S/N 27-2397 N5329YFlying Fish Ranch 29y LLC · Leesburg, FLBuilt 1963 · S/N 27-2406 N532SJohnson Lucas G · Pleasant Lake, MIBuilt 1965 · S/N 27-2966 N533KCTidd Scott · Reading, MIBuilt 1963 · S/N 27-2390 N5344YMerced County Mosquito Abatement District · Merced, CABuilt 1963 · S/N 27-2418

Back to AD 80-26-04 R1