OpenAirDocs.org
AD 94-20-04 R2

Registered aircraft · 4,469

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
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-20-04-R2')
    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-20-04-R2')
  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.

N614DBaggett William C · Lake Stevens, WABuilt 1951 · S/N D-2872N614LGleason Gregory C · Ennis, MTBuilt 1977 · S/N D-10055N614PKMeadowlake Airpark LLC · Lenoir City, TNBuilt 1961 · S/N D-6730N614TRyan James A · Needville, TXBuilt 1958 · S/N D-5473N615QConroy John F · Brighton, COBuilt 1958 · S/N D-5443N616FAArnett Freddy H Jr · Yulee, FLFirst renewal noticeBuilt 1955 · S/N D-4081N616QMena Carlos T · Colorado Springs, COBuilt 1956 · S/N D-4900N616SLucas John Chapman · Sutter Creek, CABuilt 1960 · S/N D-6501N616VHernandez Frank · Poplar Grove, ILBuilt 1959 · S/N D-6106N6176UHallman David M Jr · Erie, PABuilt 1981 · S/N D-10387N617ESBrull Warren J · Oak Hill, FLBuilt 1956 · S/N D-4567N618QEstes Aviation LLC · Vicksburg, MSBuilt 1958 · S/N D-5673N6198USeldom Seen LLC · Kalispell, MTBuilt 1981 · S/N D-10388N619BOliver Rodney W · Houston, AKBuilt 1951 · S/N D-2685N619QCoyle Robert Jr · Stevenson Ranch, CABuilt 1957 · S/N D-5376N61DBBorror Sean L · Palmdale, CABuilt 1970 · S/N D-9136N61FRHorton Brad L · Lavernia, TXBuilt 1960 · S/N D-6565N61GMCantrell Christopher Brian · Hernando, MSBuilt 1961 · S/N D-6665N61HMBlanco Hector · Hudson, FLBuilt 1961 · S/N D-6756N61JCSparkman William Scott · Calhoun, GABuilt 1962 · S/N D-7021N61JLSweeney Michael Patrick · Lagrange, GABuilt 1974 · S/N D-9576N61RPFsugaviation LLC · Indialantic, FLBuilt 1962 · S/N D-6958N6200VProbasco Mitchell L · Floydada, TXBuilt 1967 · S/N D-8482N6201VUnangst John F · Fort Worth, TXBuilt 1967 · S/N D-8609N6204VAvcraft Inc · Columbus, NEBuilt 1967 · S/N D-8564N620DRubin Kenneth · Las Vegas, NVBuilt 1951 · S/N D-2879N6216VWestphal Robert S Trustee · Mill Valley, CABuilt 1967 · S/N D-8574N6218VWrather Christopher C · Los Alamos, CABuilt 1967 · S/N D-8651N621BAlvarez Johnny D · San Antonio, TXBuilt 1957 · S/N D-5416N621QHazell Samuel P · Oceanside, CABuilt 1957 · S/N D-5255N6222MBeech Club LLC · La Crosse, INBuilt 1967 · S/N D-8545N6238VTurner James D · Duvall, WABuilt 1967 · S/N D-8588N623CSReigle Aviation South LLC · Orlando, FLBuilt 1960 · S/N D-6360N623TImmigration Aero LLC · Lewes, DEBuilt 1958 · S/N D-5768N6240VRegistered aircraftBuilt 1967 · S/N D-8628N6243VManning William O Trustee · High Point, NCBuilt 1967 · S/N D-8585N6247VNichols Mark W · St Pete Beach, FLBuilt 1967 · S/N D-8614N624DHand James Kevin · Alton, ILBuilt 1951 · S/N D-2884N624DKFw Cielo LLC · Canton, OHBuilt 1976 · S/N D-9879N624NPHackett Stevan S · Jacksonville, ILBuilt 1969 · S/N D-9010N624QDuea James G Trustee · Oklahoma City, OKBuilt 1957 · S/N D-5258N624TBozarth Rodney E · Henderson, KYBuilt 1957 · S/N D-5321N625DButcher Daniel E · Marietta, OKS/N D-2885N6260VPcb Aircraft · Johnstown, OHBuilt 1967 · S/N D-8591N6261VSundance Air Service Inc · Alameda, CAS/N D-8593N6262VGk Ag LLC · Broxton, GAS/N D-8592N6263VJansen Aviation Services And Sales LLC · Monticello, IABuilt 1967 · S/N D-8594N6264VHagstrom Christopher · Sauk Centre, MNBuilt 1967 · S/N D-8596N6265VFankhauser Thomas D · Montgomery, TXBuilt 1967 · S/N D-8595N6267XWahlen Per · Newtown Square, PABuilt 1982 · S/N D-10391
Back to AD 94-20-04 R2