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.

N5319EKing Mark B · Lewisville, TXS/N D-5878N531ALClark Terry W · Palmer, AKS/N D-6062N531BFLouis F Olberding Dds Pc · Lincoln, NEBuilt 1973 · S/N D-9541N5322EBlackwell Aviation Inc · Rostraver Township, PABuilt 1959 · S/N D-5806N5324EFox James M · Centreville, VABuilt 1959 · S/N D-5819N5325EThese Knots Aviation LLC · Bullard, TXBuilt 1959 · S/N D-5820N5326ESpiegel Jacob · San Francisco, CABuilt 1959 · S/N D-5868N5327EStone Robert T Trustee · Brookville, OHBuilt 1958 · S/N D-5792N532TBosse Don R · Bellville, TXS/N D-6598N5331EMangum Contracting Inc · El Dorado, ARBuilt 1959 · S/N D-5807N5333EBeech Bums LLC · Brookings, SDBuilt 1959 · S/N D-5824N5334ESchroeder Deon E · Vancouver, WABuilt 1959 · S/N D-5798N5335BDarter Lloyd R · Slater, IAS/N D-7161N5336ENorthstar Ministries Inc · Fairbanks, AKBuilt 1959 · S/N D-5830N5339ENbc Investments Ltd · Granbury, TXFirst renewal noticeBuilt 1959 · S/N D-5822N533SZilz Tammy S · Saint Peters, MOBuilt 1965 · S/N D-8028N5341EKatz-Braunschweig Daniel A · Staten Island, NYBuilt 1959 · S/N D-5795N5342EJenkins Douglas III · Lancaster, CABuilt 1959 · S/N D-5804N5347EShashikanth Srinivas · Birmingham, ALBuilt 1959 · S/N D-5851N5349EHutchison Herbert IV · Wichita, KSBuilt 1959 · S/N D-5831N534EGilday Aviation LLC · West Harrison, INS/N D-7825N5351EDelta Vee LLC · Savannah, GABuilt 1959 · S/N D-5832N5353EDillard Enterprises Inc · Pensacola, FLBuilt 1959 · S/N D-5856N5354EBisson Scott E · Livermore, CABuilt 1959 · S/N D-5853N5356ERedden Zana R · Sacramento, CABuilt 1959 · S/N D-5869N5359ESchaperkotter Harold M Jr · Nashville, TNBuilt 1959 · S/N D-5875N535BEValiair Lc Trustee · Casper, WYBuilt 1970 · S/N D-9170N535PTaylor Jim A · Kernersville, NCBuilt 1966 · S/N D-8119N535SBSpeedy Bonanza LLC · Waitsfield, VTBuilt 1964 · S/N D7485N535TXCoolidge Robert P · Rio Vista, TXBuilt 1960 · S/N D-6396N535VBSchellenger Jonathan H · Port Saint Lucie, FLBuilt 1975 · S/N D-9742N535WNichols David A · Oneonta, ALBuilt 1965 · S/N D-7897N5360EStrahm Ralph E · Holtville, CABuilt 1959 · S/N D-5848N5364EGaddis Jason · North Las Vegas, NVBuilt 1959 · S/N D-5836N5365EOsborne Steven V · Douglas, WYBuilt 1959 · S/N D-5854N5367EHentges Anthony · Canby, MNBuilt 1959 · S/N D-5846N5368EHarris Adventures LLC · El Prado, NMS/N D-5847N5369EKing Curtis M · Tenino, WABuilt 1959 · S/N D-5850N5372EThief River Aviation Inc · Thief River Falls, MNBuilt 1959 · S/N D-5905N5373EMoyer Thomas L · Fayetteville, GABuilt 1959 · S/N D-5861N5377EHamilton Chris · Livermore, CABuilt 1959 · S/N D-5863N5379EMahoney Blair P · Columbia Station, OHBuilt 1959 · S/N D-5877N537DStonebraker Properties LLC · Sierra Vista, AZS/N D-8791N5382EGmoser Michael T · Hamilton, OHBuilt 1959 · S/N D-5876N5383ERegistered aircraftBuilt 1959 · S/N D-5886N5385EGeiger William G · New Castle, KYBuilt 1959 · S/N D-5933N5386EAllen Karen J · Walnut Grove, CAS/N D-5917N5388EGandy Dale D · Aurora, MOBuilt 1959 · S/N D-5894N5389EWagner Paul A Jr · Madison, ALBuilt 1959 · S/N D-5890N5391EGosser James A · Nicholasville, KYBuilt 1959 · S/N D-5873
Back to AD 94-20-04 R2