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.

N1211YEdens William D · Mesa, AZBuilt 1962 · S/N 15059611 N1212DN1212d LLC · Boise, IDS/N 19766 N1212YKennedy Kevin · Vassar, KSBuilt 1962 · S/N 15059612 N1213RMorgan Robert · Ozark, MOFirst renewal noticeBuilt 1967 · S/N 15064627 N1214EMurray Craig P · Hagaman, NYBuilt 1946 · S/N 7AC-4772 N1214QTalapanuri Gokul N · Austin, TXBuilt 1971 · S/N 15072514 N1215DMytth Spray Solutions Inc · Easley, SCBuilt 1950 · S/N 19769 N1215YGill Robert S · Anchorage, AKS/N 15059615 N1216BBrown Carl E Jr · Milan, ILS/N 5843 N1218QSale Reported · Commerce City, COSale reportedBuilt 1971 · S/N 15072518 N1219QRedeemed Flying Corps Association · Oklahoma City, OKBuilt 1971 · S/N 15072519 N121CGGeiser Corbin Scott · Little Elm, TXBuilt 2017 · S/N 928 N121PSQualls Kelly L · Malvern, ARBuilt 2007 · S/N CC11-00062 N121SSGraber Matthew P · Mountain View, CABuilt 1974 · S/N 15076450 N121YSelk Gary B · Eau Claire, WIBuilt 1966 · S/N 141 N1221DJamison Tim · Oklahoma City, OKBuilt 1951 · S/N 19982 N1222UUmanzor Daniel A · S San Francisco, CABuilt 1964 · S/N 15060415 N1222WPlanes Over Plains LLC · Benton, KSBuilt 1974 · S/N 15075991 N1222YPasseno Craig A · Cheboygan, MIBuilt 1962 · S/N 15059622 N1223QAlbertson Alford L · Lemoore, CABuilt 1971 · S/N 15072523 N1224DByrer Jesse A · Monrovia, INBuilt 1951 · S/N 20114 N1224HCorcoran Timothy J · Aurora, ORFirst renewal noticeS/N 15AC-236 N1224QEmprize LLC · Menasha, WIBuilt 1971 · S/N 15072524 N1224VCarter John T · Huntington Beach, CABuilt 1952 · S/N 20358 N1224YLowenkron Laurence H · Pleasanton, CABuilt 1962 · S/N 15059624 N1226YVolo Consulting LLC · Menomonee Falls, WIBuilt 1962 · S/N 15059626 N1227DWhite Michael D · Willow Springs, MOBuilt 1950 · S/N 19781 N1227HSutton Aircraft Salvage LLC · Palmer, AKBuilt 1948 · S/N 15-AC239 N1227RRegistration Pending · Laie, HIRegistration pendingBuilt 1965 · S/N 15062347 N1227YGyure Ronald J · Ft Worth, TXBuilt 1962 · S/N 15059627 N1228DBell Stephen R · Carleton, MIBuilt 1950 · S/N 19782 N1229BWiley Barbara · Yellow Springs, OHBuilt 2011 · S/N 16200169 N1229HMattfield Weldon D · Bovey, MNFirst renewal noticeS/N 15AC-241 N1229YFinney James R · Howe, TXBuilt 1962 · S/N 15059629 N122DQOliver Taylor R · Topeka, KSBuilt 1981 · S/N 589-12 N122KSPt Arts LLC · Grand Rapids, MIBuilt 1966 · S/N 17255255 N122LCAnderson Robert A · Waynesville, OHBuilt 2005 · S/N AL-1012 N122MSStaudacher Mark W · Bay City, MIBuilt 2023 · S/N 845 N122PWKal Aero Flight Instruction LLC · Mattawan, MIBuilt 1966 · S/N 17255433 N122RPWerner Bryce R · Blue Earth, MNBuilt 1966 · S/N 17254543 N122SDa Silva Haroldo Rodrigues · Gaithersburg, MDBuilt 1984 · S/N DS-1 N1231DNeel Aviation LLC · Lakeland, FLBuilt 1950 · S/N 19785 N1231QMclin Robert J · Mays Landing, NJBuilt 1971 · S/N 15072531 N1232QPeres Kenneth V · Erie, PABuilt 1971 · S/N 15072532 N1233EWieman Dianne L · Marion, TXBuilt 1946 · S/N 7AC-4791 N1233HRamberg Stephen Jon · Saint Louis Park, MNS/N 15AC-245 N1233QReach For Skies LLC · San Antonio, TXS/N 15072533 N1233YPoland Marvin W · Tawas City, MIBuilt 1962 · S/N 15059633 N1234SGale Jeremy C · Clear Lake, WIS/N 17254335 N1235DStates Douglas S · Geneseo, ILBuilt 1951 · S/N 20118

Back to AD 94-05-05 R1