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.

N571BPulis Ryan J · Spring, TXBuilt 1957 · S/N D-5397N571TIvey Martin J · Millsap, TXBuilt 1961 · S/N D-6754N5720KCrumpler Chad C · Wichita, KSBuilt 1964 · S/N D-7520N5724VN5724v LLC · Kalispell, MTBuilt 1966 · S/N D-8103N5726KRegistered aircraftBuilt 1964 · S/N D-7571N5727VCulver Investments LLC · Gordon, TXBuilt 1966 · S/N D-8186N572TPaterson Eric G · Blacksburg, VABuilt 1964 · S/N D-7400N5730VBooher Tabitha O · Livingston, TNBuilt 1966 · S/N D-8101N5732KAndrus Ralph · Denison, TXBuilt 1964 · S/N D-7518N5732VErps Jason D · Blue Springs, MOBuilt 1966 · S/N D-8104N5736VLom-Ajan Vicente A · Plantation, FLS/N D-8105N5737KNeubauer Accounting LLC · Wray, COBuilt 1964 · S/N D-7540N5738VBailey Frederick D · Fayetteville, ARBuilt 1966 · S/N D-8109N5739KLyn Alden Cleveland · Kansasville, WIBuilt 1964 · S/N D-7519N5741VSjr Properties LLC · Reno, NVBuilt 1966 · S/N D-8106N5742VAllen Bruce C · Anna, TXBuilt 1966 · S/N D-8111N5745KGreen Mountain Avionics Inc · Middlebury, VTBuilt 1964 · S/N D-7555N5745VBonanza N5745v LLC · Colorado Springs, COBuilt 1966 · S/N D-8187N5747KDel Martin Lp · Spring, TXBuilt 1964 · S/N D-7534N5749KBase To Final LLC · Mesa, AZBuilt 1964 · S/N D-7536N574JPThompson Phillip · Lakeway, TXBuilt 1977 · S/N D-10054N574TMcallister Todd K · Grangeville, IDBuilt 1961 · S/N D-6748N5750KSamons David M · Phoenix, AZBuilt 1964 · S/N D-7538N5751KDetloff Martin P · Kaukauna, WIBuilt 1964 · S/N D-7539N5753KSale Reported · Fort Worth, TXSale reportedBuilt 1964 · S/N D-7542N575SLPhipps Vaughn Pago · Chattanooga, TNBuilt 1964 · S/N D-7342N5762KBagwell Jason R · Garner, NCBuilt 1964 · S/N D-7550N5769KHepburn Jeffrey T · Atlanta, GABuilt 1964 · S/N D-7553N5770KStevens Eugene E IV · Silver Spring, MDBuilt 1964 · S/N D-7707N5777KMayes Mark E · Bisbee, AZBuilt 1964 · S/N D-7546N5778KSimpson Fredrick L · Olympia, WABuilt 1964 · S/N D-7558N5783KSullivan Peyton C · Alamogordo, NMBuilt 1964 · S/N D-7565N5784KN5784k LLC · Kalispell, MTBuilt 1964 · S/N D-7567N5786KRocket Investments LLC · Independence, MOBuilt 1964 · S/N D-7570N578UHawley Elizabeth · Wichita Falls, TXBuilt 1978 · S/N D-10206N5797KBank Of Utah Trustee · Salt Lake City, UTBuilt 1964 · S/N D-7586N5799KCain Christopher · Colleyville, TXBuilt 1964 · S/N D-7590N57CFTurbett Theodore T · Houston, TXBuilt 1972 · S/N D-9358N57EDWebster Chad E · Coronado, CABuilt 1957 · S/N D-5140N57HBSkeeler William Tyler · Austin, TXBuilt 1957 · S/N D-5268N57RSmith Gregory C · Geneva, ILBuilt 1955 · S/N D-4404N57TCNiemi Aviation LLC · Glyndon, MNBuilt 1968 · S/N D-8693N5802CRackham Alan Scott · Foresthill, CABuilt 1951 · S/N D-2754N5803KWhittock Tyson H · Anchorage, AKBuilt 1965 · S/N D-7830N5804KHarrell Jeff E · Cedar Park, TXBuilt 1965 · S/N D-7831N5805KDoran James V · Saint John, KSBuilt 1965 · S/N D-7833N5806CPasztalaniec Matt · Monterey, CABuilt 1951 · S/N D-2758N5806SAg Solutions Of West Texas LLC · Roby, TXBuilt 1964 · S/N D-7720N5808CDeasy John F Jr · Doylestown, PABuilt 1951 · S/N D-2760N5809SRegistered aircraftBuilt 1964 · S/N D-7717
Back to AD 94-20-04 R2