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.

N520RGVaughn Freddie Allen · Yatesville, GABuilt 1963 · S/N 17250408 N5210ZSale Reported · Gainesville, FLSale reportedBuilt 2011 · S/N 16200030 N52110Jhawk Aviation LLC · Leavenworth, KSBuilt 2011 · S/N 16200034 N5211NFly America Inc · Palo Alto, CABuilt 2011 · S/N 16200032 N5211YM&L Flight Inc · Newcastle, WABuilt 2011 · S/N 16200033 N5212RMontana Interstate Air Transport LLC · Kalispell, MTBuilt 2011 · S/N 16200036 N5212YM&L Flight Inc · Newcastle, WABuilt 2011 · S/N 16200037 N5213QMedia Stew LLC · Carson City, NVBuilt 1971 · S/N 15073113 N5213URegistration Pending · Bainbridge Island, WARegistration pendingBuilt 2011 · S/N 16200039 N5214FRainier Flight Service LLC · Renton, WABuilt 2011 · S/N 16200041 N5214QMann Roland F · Murrayville, GABuilt 1971 · S/N 15073114 N5215FUnited States Air Force · Rio Vista, CABuilt 1965 · S/N 17253233 N5215KFilkins Randy · Wellsburg, WVBuilt 2011 · S/N 16200042 N52165Rainier Flight Service LLC · Renton, WABuilt 2011 · S/N 16200048 N5216LCorsair Aviation LLC · Pacoima, CABuilt 2011 · S/N 16200046 N5216NSkycatcher N162ah LLC · Santa Rosa, CABuilt 2011 · S/N 16200047 N5217QGoode Stephen C · Canton, TXS/N 15073117 N5217XRodger That Aviation LLC · Arlington, TXBuilt 2011 · S/N 16200051 N5219QVital Aviation LLC · Monterey, CABuilt 1971 · S/N 15073119 N521DVVegh Dennis · Queen Creek, AZBuilt 2021 · S/N AV1115 N521EFBowen Nathan William · Washington, GABuilt 1947 · S/N 12257 N521MVVerastegui Emilio F · Albuquerque, NMBuilt 2023 · S/N 050 N5220Culwell Lewis D · Helena, MTFirst renewal noticeBuilt 1972 · S/N 6707J-85B N5220FUnited States Air Force · Eglin Afb, FLBuilt 1965 · S/N 17253250 N5223QThealphamart LLC · Saint Petersburg, FLBuilt 1971 · S/N 15073123 N5224FPfeiffer Logan A · Boonville, MOBuilt 1965 · S/N 17253263 N5224QRiibe Gary J · Herman, NEBuilt 1971 · S/N 15073124 N5225QMiller Kevin L · Arlington, WABuilt 1971 · S/N 15073125 N5227QFoster Kathleen E · Long Beach, CABuilt 1971 · S/N 15073127 N5228FUnited States US Air Force · Dover Afb, DEBuilt 1965 · S/N 17253277 N5229FUnited States Air Force Owner · Clovis, NMBuilt 1965 · S/N 17253280 N522DRIbrahim Tarek M · Lawrenceville, VABuilt 1966 · S/N 15063327 N522KSkyhigh Aviation Investments Inc · Daytona Beach, FLBuilt 1974 · S/N 15075544 N522TSFerraraccio Christopher M · Clarksville, TNBuilt 1961 · S/N 17248805 N522XSkyfest Aviation Investments Inc · Daytona Beach, FLBuilt 1964 · S/N 17252411 N5231QMonti David G · Middleport, NYBuilt 1965 · S/N 17253288 N5232FGilbert Christopher J · Edmonds, WABuilt 1965 · S/N 17253291 N5234FUnited States Air Force Owner · Apo, APBuilt 1965 · S/N 17253297 N5235FUnited States Air Force · March Afb, CABuilt 1965 · S/N 17253301 N5235QPoules Alexander · Hope Valley, RIBuilt 1972 · S/N 15073135 N5236QPeters Terry M · Okeechobee, FLBuilt 1972 · S/N 15073136 N5237FGreer James F · Louisville, KYBuilt 1965 · S/N 17253308 N5237QKretschmer Bryan · Hawthorne, NJBuilt 1972 · S/N 15073137 N5238QMolek Jon · Warren, OHBuilt 1972 · S/N 15073138 N5239FDanner Charles L Sr · Oak Harbor, OHBuilt 1965 · S/N 17253314 N5239QWayland Johnny R · Stephenville, TXS/N 15073139 N523WMBiondich Dennis · Rubicon, WIBuilt 1946 · S/N 22358 N5240QRamesh Manohari D · Liberty Township, OHBuilt 1972 · S/N 15073140 N5241FUnited States Air Force Owner · Apo, APBuilt 1965 · S/N 17253322 N5242QShimata Kenneth S · Honolulu, HIBuilt 1972 · S/N 15073142

Back to AD 94-05-05 R1