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.

N366RZOwens Duane C · Spirit Lake, IDFirst renewal noticeBuilt 1967 · S/N 63-35 N366TLWard Moussa E · Syracuse, INS/N 8436 N3670LLatch Leo D · Upland, CABuilt 1965 · S/N 17253839 N3671JAndrosky Charles S Jr · Superior, WIS/N 15064971 N3671LCalmet Aircraft Leasing LLC · Middletown, DEBuilt 1965 · S/N 17253840 N3671ZYedinak Jeremy W · Blackstone, ILS/N 18-7394 N3672GAcosta De La Torre Armando A · El Paso, TXS/N 29549 N3672JOndrasik Peter P Jr · Palmerton, PABuilt 1966 · S/N 15064972 N3672LJanowski Stephen J Jr · Wadsworth, OHBuilt 1965 · S/N 17253841 N3672VRobinson Franz · Seagrove, NCBuilt 1975 · S/N 15076582 N3673KSpring City Aviation Inc · Waukesha, WIBuilt 1946 · S/N 22364 N3673SMike Whiskey LLC · Le Claire, IABuilt 1963 · S/N 17250873 N3673TDunn Carrie B · Emporia, KSBuilt 1976 · S/N F-081 N3673VClinton Flying Service Inc · Clinton, NCBuilt 1975 · S/N 15076583 N3674JAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1966 · S/N 15064974 N3674SWiegand Gary E · Carmel Valley, CABuilt 1963 · S/N 17250874 N3675JHarder Ronald E · Bell, FLFirst renewal noticeBuilt 1966 · S/N 15064975 N3675LSheppard Dale A · Kalispell, MTBuilt 1965 · S/N 17253844 N3676JKorinko Seana L · Rostraver Township, PABuilt 1966 · S/N 15064976 N3676KCrites Elizabeth A · Waukesha, WIBuilt 1947 · S/N 22367 N3677AWing LLC · Sterling, AKBuilt 1953 · S/N 18-3072 N3677HWalkup Richard A · Pioneer, OHBuilt 1946 · S/N 4302 N3677LBell Ellis E · Forrest City, ARBuilt 1965 · S/N 17253846 N3677VNanny Seith A · Nine Mile Falls, WABuilt 1948 · S/N 14951 N3677ZSims Doyle B · Mcgehee, ARBuilt 1960 · S/N 18-7404 N3678HWilliams Terry R · Vinita, OKBuilt 1946 · S/N 4303 N3678JMorgan Daniel W · Keene, TXBuilt 1966 · S/N 15064978 N3678RCarl Aviation LLC · Lake Havasu City, AZBuilt 1964 · S/N 17251566 N3678SMartone Douglas K · Windham, CTBuilt 1963 · S/N 17250878 N3678TVeech Shawn M · Big Lake, AKBuilt 1977 · S/N F-086 N3678VCowey Kevin M · Pittsburgh, PAFirst renewal noticeBuilt 1948 · S/N 14952 N3678ZNorris Joseph B · Oshkosh, WIBuilt 1960 · S/N 18-7405 N3679KBarnhill Marcia Trustee · Ogallala, NEBuilt 1946 · S/N 22370 N3679TGks 1 LLC · Dalton, PABuilt 1977 · S/N F-079 N3679VBaird Mark C · Centerville, UTBuilt 1949 · S/N 15075 N367DSPetersen Gary Trustee · Walton, NEBuilt 1946 · S/N 7AC-1331 N367GRhodes Daryl R · Winfield, KSBuilt 2019 · S/N L-176 N3680PHyde Michael L · La Porte, TXBuilt 1955 · S/N 18-4581 N3680SLubonovic Thomas M · New Carlisle, OHBuilt 1963 · S/N 17250880 N3680VAdams James W · Sioux Falls, SDBuilt 1975 · S/N 15076586 N3681JPence Northwest Aviation LLC · Salem, ORBuilt 1966 · S/N 15064981 N3681LBurton Walter E · Statesboro, GABuilt 1965 · S/N 17253850 N3682KTorres Benjamin · Las Piedras, PRS/N 22373 N3682LRiseaero LLC · Florence, SCBuilt 1965 · S/N 17253851 N3682SPederstuen Ricky L · Hudson, WIBuilt 1963 · S/N 17250882 N3682TMortenson Allan C · Healy, AKS/N F-089 N3683JGuess Clayton L · Bushnell, FLBuilt 1966 · S/N 15064983 N3683KTrewhitt Douglas G · Pacific Palisades, CABuilt 1946 · S/N 22374 N3683VMcflight Aviation LLC · Highland, UTBuilt 1975 · S/N 15076588 N3684BBetts Brian N · Williamsfield, OHBuilt 1953 · S/N 183050

Back to AD 94-05-05 R1