Skip to content

Registered aircraft · 26,230

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.

N1287HNelson Chester C · Little Falls, MNBuilt 1948 · S/N 15AC-303 N1288DConner Brent F · Medford, ORBuilt 1951 · S/N 19861 N1288QCahill Chad · Edmond, OKS/N 15072588 N1289DAeronautical Technical Service Inc · Collierville, TNS/N 19865 N1289HTranby Wayne A · Fargo, NDBuilt 1948 · S/N 15AC-306 N1289QLong Jeffrey K Trustee · The Villages, FLBuilt 1971 · S/N 15072589 N128BTThrift Bobby · Macclenny, FLBuilt 1983 · S/N 128 N128RBNewman Michael S · Summerville, SCS/N 61586 N128RRRegistered aircraftS/N 15070734 N1291Poplar Grove Airmotive Inc · Poplar Grove, ILS/N 1291 N1292Eaa Aviation Foundation Inc · Oshkosh, WIBuilt 1948 · S/N 7 N1292DKlaerner John D · San Antonio, TXBuilt 1951 · S/N 19868 N1292HHall James E · Naples, FLBuilt 1949 · S/N 7FC-1 N1292YCarbiener Ross E · Kewanee, ILBuilt 1962 · S/N 15059692 N12930Eaa Aviation Foundation Inc · Oshkosh, WIBuilt 1932 · S/N 1 N1293DAlder George A · Palmer, AKBuilt 1951 · S/N 19869 N1293HAyers Mark T · Whitney, TXS/N 15-AC-311 N1293QCoxwell James L · Midlothian, TXBuilt 1971 · S/N 15072593 N1294HWolbert Joseph P · Canton, GABuilt 1948 · S/N 15AC-318 N1294QKimmons Anthony J · Bogue Chitto, MSBuilt 1971 · S/N 15072594 N1295DBlessum Jay A · Minot, NDBuilt 1950 · S/N 19871 N1296QFey Brian F · Waycross, GABuilt 1971 · S/N 15072596 N1297DPerk LLC · Glendale, AZBuilt 1951 · S/N 19873 N1298BJury Steven T · Fresno, CABuilt 1947 · S/N 5925 N1298DGlaser Gerald A · Sebastopol, CABuilt 1951 · S/N 19874 N1299Grater Timothy F · Knoxville, TNS/N 4590 N129AHN388vr LLC · Olalla, WABuilt 1963 · S/N 17251051 N129MDMiller Glen S · Brenham, TXS/N 56430 N12FYEber Lorenz · Bainbridge Island, WABuilt 2017 · S/N 003 N12JMMroz Kaitlin J · Rhome, TXBuilt 1961 · S/N 17248841 N12JTHines Thomas J · Amsterdam, NYBuilt 1972 · S/N 15073955 N12MMHigh Exposure Inc · Wilmington, DEBuilt 1968 · S/N 15069873 N12NBFarrell Richard A · Dacono, COS/N 55815 N12SGCacolici Dominic J · Saint Petersburg, FLBuilt 1978 · S/N TDH-2 N12TYSewell Roger C · Meridian, IDBuilt 1960 · S/N 17248030 N1300QA-Cent Aviation Inc · Jacksonville, FLBuilt 1971 · S/N 15072600 N1300TVarnado Calvin M · Palmer, AKBuilt 1965 · S/N 17253731 N1300YMammucari Leonard E · West Chester, PAS/N 17249000 N1301HFair David E · Anchorage, AKFirst renewal noticeBuilt 1949 · S/N 15AC-325 N1302BSns Flyers LLC · Salinas, CABuilt 1948 · S/N 5929 N1302HN1302h LLC · Levering, MIS/N 15AC-333 N1302QProfessional Pilot Training Inc · Eagle Lake, TXBuilt 1971 · S/N 15072602 N1302YDorning Patrick J · Ft Lauderdale, FLBuilt 1961 · S/N 17249002 N1303DTail Dragn Tn LLC · Adams, TNBuilt 1951 · S/N 19879 N1303QMontemayor Joshua Lee · Orlando, FLBuilt 1971 · S/N 15072603 N1303YDay Patrick J · Bloomer, WIS/N 17249003 N1304HShade Eric L · Dillingham, AKS/N 15AC-330 N1304MBourg Frederick I · Drummond, WIBuilt 1971 · S/N 15072604 N1304YLyon Samantha J · Milton, FLS/N 17249004 N1305FShlapak Jeffrey M · Peachtree City, GABuilt 1966 · S/N 17254800

Back to AD 94-05-05 R1