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.

N9744YDouble P Creative LLC · Pleasanton, TXBuilt 1963 · S/N D-7141N9745RBykerk John C · Springfield, ORS/N D-6226N9747RAmundson James Robert · South Lake Tahoe, CAS/N D-6228N9747YRichardson LLC · Henderson, NVBuilt 1963 · S/N D-7136N9748RVinson Lonnie Eugene Jr · Oceanside, CABuilt 1959 · S/N D-6229N974CCPlane Fun Inc Tr Trustee · Snellville, GABuilt 1964 · S/N D-7498N974QBailey Jerry D · Sulpher, OKBuilt 1961 · S/N D-6849N9750CJv Aviation LLC · Johnston, RIBuilt 1973 · S/N D-9469N9750RMiletta Anthony · Beloit, OHS/N D-6232N9752RChristensen Craig H · Webster, MNBuilt 1959 · S/N D-6240N9753RMasterson James Patrick · Aptos, CAS/N D-6241N9754RStrojny Andrew P Jr · Strongsville, OHBuilt 1959 · S/N D-6248N9755RSalisbury Ronald · Newport Beach, CABuilt 1959 · S/N D-6250N9756REstes Aviation LLC · Vicksburg, MSBuilt 1959 · S/N D-6251N9757RVan Noy Stephen E · Alliance, NEBuilt 1960 · S/N D-6286N9757YVectair Aviation LLC · League City, TXBuilt 1963 · S/N D-7147N9758RTurner Richard Walser Trustee · Rocky Gap, VABuilt 1960 · S/N D-6304N9759RSanders Kenneth E · Millsap, TXBuilt 1959 · S/N D-6238N975QA2b Adventures Inc · Kennesaw, GABuilt 1961 · S/N D-6840N975QCYoung Billy G · Livingston, TXBuilt 1970 · S/N D-9114N975RMclane Norman B · Mesa, AZBuilt 1979 · S/N D-10276N9761YAllen Karen J · Walnut Grove, CAS/N D-7146N9763RSpencer Eric M · Glenrock, WYFirst renewal noticeBuilt 1960 · S/N D-6305N9763YSouth Delta Aviation Inc · West Helena, ARBuilt 1963 · S/N D-7148N9764RSchaffert Warren E · Trenton, NES/N D-6247N9765RHathorn Luther G · Corsicana, TXBuilt 1959 · S/N D-6243N9765YHutchinson Kevin J · Poplar Grove, ILBuilt 1963 · S/N D-7151N9766YGleo LLC · Downers Grove, ILBuilt 1963 · S/N D-7152N9767RRowell Jerome F · Winchester, VABuilt 1959 · S/N D-6254N9768RGeorge Raymond R · Shadow Hills, CABuilt 1959 · S/N D-6244N976DSFisher Samuel J · Nahant, MABuilt 1976 · S/N D-9931N9770RSmith Francis K · Saint Inigoes, MDBuilt 1960 · S/N D-6285N9772RAterianus Jacques · Suamico, WIS/N D-6264N9773YAirhart Michael · Justin, TXBuilt 1963 · S/N D-7155N9774YSpenle Robert L · New Auburn, WIBuilt 1963 · S/N D-7159N9775YHamilton Christopher S · Bowling Green, KYBuilt 1963 · S/N D-7156N9777RSingleton Shawn P · Nipomo, CABuilt 1959 · S/N D-6268N9777YNunneley Ian · Port Saint Joe, FLBuilt 1963 · S/N D-7160N9779RRhodes Orval D · Aztec, NMBuilt 1960 · S/N D-6284N977KMBusse Steve T · Cincinnati, OHFirst renewal noticeBuilt 1964 · S/N D-7366N977QVanderstel Richard J · Grand Haven, MIBuilt 1961 · S/N D-6923N9783RMoore Michael C · Brooklyn, MIBuilt 1960 · S/N D-6488N9785RShaul Kurt · Kelseyville, CABuilt 1960 · S/N D-6294N9786RLaguna Henry · Glendale, CAS/N D-6299N9787RThorny Oak Ranch LLC · Missouri City, TXBuilt 1960 · S/N D-6303N9787YMaeda Shinji · Mill Creek, WABuilt 1963 · S/N D-7235N9788YRichards Fletcher D III · Longmont, COBuilt 1963 · S/N D-7163N9789RBorth Christian D · Alameda, CABuilt 1960 · S/N D-6301N9789YParsons John C · Wichita, KSBuilt 1963 · S/N D-7164N9790RRorke David E · Benicia, CABuilt 1961 · S/N D-6320
Back to AD 94-20-04 R2