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.

N5092NMill-Run LLC · Lewes, DES/N D-9893N5093BFe2 LLC · Washington, LABuilt 1955 · S/N D-4390N5095BMoore Darrell R · Lake Stevens, WABuilt 1955 · S/N D-4393N5096BCooke Riley O · Bridger, MTBuilt 1955 · S/N D-4402N5097BJ P Sanders · Knoxville, TNBuilt 1955 · S/N D-4395N509JMRegistered aircraftBuilt 1980 · S/N D10352N50BDGoodrich Gilbert Joseph · Katy, TXS/N D-8175N50JMMinter Michael D Jr Trustee · Rock Port, MOBuilt 1978 · S/N D-10141N50ZTackes Steven · Carson City, NVBuilt 1969 · S/N D-8929N510CHTj Air Holdings Inc Trustee · Wilmington, DEBuilt 1977 · S/N D-9999N512BDTurbo Aviation LLC · Chesterfield, SCS/N D-9398N5130XHofferth Brian K · Anacortes, WABuilt 1959 · S/N D-6039N513RCraddock Roger D · Memphis, TNBuilt 1961 · S/N D-6782N514CSTomco Stores Ltd · Ruidoso, NMBuilt 1964 · S/N D-7533N514KValentin Arnaldo J · Bayamon, PRBuilt 1958 · S/N D-5566N514PCParsons Donald E · Clarksville, TNBuilt 1969 · S/N D-8967N516WClearwater Holding LLC · Parkersburg, WVBuilt 1975 · S/N D9744N517JLSchmidt Robert G · Coppell, TXBuilt 1958 · S/N D-5762N517KGRegistration Pending · Pittsburg, TXRegistration pendingBuilt 1980 · S/N D10350N518Action Aviation Inc · New Port Richey, FLBuilt 1953 · S/N D-3636N518MMull Jason E · Chester, NYBuilt 1970 · S/N D-9111N519PHFlyboys LLC · Blue Bell, PABuilt 1957 · S/N D-5413N51EDWallbirds LLC · San Diego, CABuilt 1955 · S/N D-4246N51HMDw Peterson Inc · Warren, MNBuilt 1966 · S/N D-8288N51RJJones Robert B Trustee · Fresno, CABuilt 1960 · S/N D-6371N521DPWin Holdings Inc · Englewood, COBuilt 1962 · S/N D-7005N521VRMyers Jonathan A · Dieterich, ILBuilt 1965 · S/N D-7922N522DHFlohr James E · Parker, COBuilt 1960 · S/N D-6493N523QNixon John H · Ormond Beach, FLBuilt 1967 · S/N D-8582N523TTennant Daniel R · Uniontown, OHBuilt 1963 · S/N D-7178N523TCSmith Ranch Bonanza LLC · San Francisco, CABuilt 1964 · S/N D-7613N523ZARegistration Pending · Perryton, TXRegistration pendingBuilt 1974 · S/N D-9596N525BHWalker Craig · Pleasant View, TNBuilt 1982 · S/N D-10400N525FWWall Freddy V · Raleigh, NCBuilt 1962 · S/N D-7044N525KGCherokee Trail Aviation LLC · Tontitown, ARBuilt 1962 · S/N D-6965N527RABonanza Parts Inc · Davis, CAS/N D-4213N5298CCheshire Derek L · Mercer Island, WABuilt 1951 · S/N D-2682N529BBCarnahan Charles Christopher · Wentzville, MOBuilt 1955 · S/N D-4250N529DDSchwertfeger Dean · Woodruff, WIBuilt 1970 · S/N D-9151N529PHoffman Andrew · Martinsville, INBuilt 1961 · S/N D-6686N52AUUllman Aaron L · Barksdale Afb, LABuilt 1967 · S/N D-8484N52WRCoppola Larry Joe · West Des Moines, IAS/N D-4841N5300BPerkins Dimmitt · Sheridan, ARS/N D-3597N5307EHutton Douglas F · Elk City, OKBuilt 1958 · S/N D-5766N530CContinental Title Trust LLC Trustee · Wichita, KSBuilt 1976 · S/N D-9927N531Martz G Rodney · Frederick, MDBuilt 1953 · S/N D-3676N5311ESale Reported · Playa Del Rey, CASale reportedBuilt 1958 · S/N D-5775N5313EFlying And Farming LLC · Kingsley, IABuilt 1959 · S/N D-5844N5316ENoble Zachary Q · Rhoadesville, VABuilt 1959 · S/N D-5813N5317ECallaghan James J III · West Chester, PABuilt 1959 · S/N D-5808
Back to AD 94-20-04 R2