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.

N84TTRenda Michael A · Sunrise Beach, MOBuilt 1962 · S/N D-6942N84WHWhiskey Hotel Aviation LLC · South Hill, VABuilt 1956 · S/N D-4884N8500MThomas Kent J · Wilsonville, ORS/N D-7184N8503MPlatt Anthony Eric · Riverside, CAS/N D-7185N8505MRegistered aircraftS/N D-7186N8506MMichaels Daryl · Owasso, OKBuilt 1963 · S/N D-7187N8507MSutliff Geoffrey A · Sacramento, CAS/N D-7177N850TWisdom John D · Mineola, TXBuilt 1972 · S/N D-9367N8512MMalone David Dean · Carefree, AZBuilt 1963 · S/N D-7180N8514MSummerland Spins LLC · Summerland Key, FLBuilt 1963 · S/N D-7182N8515MSegura Richard J III · Henderson, TXBuilt 1963 · S/N D-7183N8521MStarr Aero LLC · Tempe, AZBuilt 1963 · S/N D-7213N8528MSheldon Randy C · Osceola, MOS/N D-7192N8529MSpivey Yancy D · Nocona, TXBuilt 1963 · S/N D-7193N852RRauch Karl W · Fredericksburg, VABuilt 1959 · S/N D-6183N853Cameo Marketing Inc · Ellsworth, MES/N D-9888N8533MDrill Driver LLC · Livingston, TXS/N D-7199N8534MSimons Torrence · Keene, TXBuilt 1963 · S/N D-7200N8536MReever John J · Dover, PABuilt 1963 · S/N D-7198N8538MSt Clair Arthur · Monroe, NCBuilt 1963 · S/N D-7211N853RBelknap Aero Services LLC · Meredith, NHBuilt 1959 · S/N D-6193N853THumphrey Daniel P · Sausalito, CABuilt 1974 · S/N D-9630N8541MPorter Matthew R · Stephenville, TXBuilt 1963 · S/N D-7201N8542MCross Colin · Alameda, CABuilt 1963 · S/N D-7202N8544MKc Storm Survey Services LLC · Liberty, MOBuilt 1963 · S/N D-7203N8550MHuber Pamela J · Lake City, FLBuilt 1963 · S/N D-7209N8558MA & C Customs LLC · Caddo Mills, TXBuilt 1963 · S/N D-7216N855DSAerolutions LLC · Preston, IDBuilt 1966 · S/N D-8287N8565MMundt Paul W · Henderson, NVBuilt 1963 · S/N D-7208N8566RSouthwest Fresh Potato LLC · Hugoton, KSBuilt 1974 · S/N D-9684N8568MMoore Charles B · Miles City, MTBuilt 1963 · S/N D-7215N856B4261bravo Corp · Wilmington, DEBuilt 1961 · S/N D-6778N8570MChester Steven G · Aurora, COBuilt 1963 · S/N D-7129N8572MSignor Jeff R · Alta Loma, CAS/N D-7217N8577QRegistration Pending · Amarillo, TXRegistration pendingS/N D-8208N857BCCynamon Bruce · Weirsdale, FLBuilt 1968 · S/N D-8885N8586MNahas Andrew W · Viroqua, WIBuilt 1963 · S/N D-7222N8588MHoward Richard · Erie, COBuilt 1963 · S/N D-7224N8589MOwosso Aircraft LLC · Bancroft, MIExpired dealerBuilt 1963 · S/N D-7233N858DFulmer Robert Alan · Irvine, CABuilt 1966 · S/N D-8200N8590MLeaders Chase N · Clear Lake, MNS/N D-7293N8591MPreszler Terence H · Braddock, NDBuilt 1963 · S/N D-7225N8592MWeis Samuel K · Madera, CABuilt 1963 · S/N D-7226N8598MMerrill Gregory T · Fresno, CABuilt 1963 · S/N D-7228N85BAMclean Randy Justin · Taylorsville, NCBuilt 1968 · S/N D-8820N85GSMtas LLC · Laveen, AZS/N D-3627N85JLewis Thomas R · Aransas Pass, TXBuilt 1954 · S/N D-3774N85SXBaker Kenneth L Jr · Carlisle, KYBuilt 1958 · S/N D-5605N8600QSpano Darren · Deville, LABuilt 1964 · S/N D-7630N8602MP35 Bonanza LLC · Dequincy, LABuilt 1963 · S/N D-7294
Back to AD 94-20-04 R2