AD 94-05-05 R1

Registered aircraft · 26,230

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-05-05-R1')
    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-05-05-R1')
  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.

N90LLPate Donald P Trustee · Edmond, OKBuilt 1946 · S/N 18810N90PPN90pp LLC · Titusville, FLBuilt 1973 · S/N A1500419N90RLBarrett Patricia · Arroyo Grande, CAS/N 2544N90SQMills Christopher D · Brookshire, TXBuilt 1989 · S/N 91N90TNMike Rinker Aircraft LLC · Union City, TNBuilt 2015 · S/N 001N9100ARettzo Bernard J · Chandler, AZBuilt 1949 · S/N 18859N9101UAura LLC · Elsie, MIBuilt 1976 · S/N 15078052N9101YSafeflite Aviation LLC · Glenwood, IAS/N 5-710N9103UMonica Aviation LLC · Cambridge Springs, PABuilt 1976 · S/N 15078054N9105AHerr Andrew A · River Ridge, LABuilt 1949 · S/N 18864N9105BVeretto Michael A · Odessa, TXBuilt 1958 · S/N 36605N9106ARegistered aircraftBuilt 1949 · S/N 18865N9106BRegistered aircraftBuilt 1958 · S/N 36606N9106USpafford Luke · Pontiac, ILBuilt 1976 · S/N 15078057N9107BGrace Community Church · Fremont, OHS/N 36607N9107UAnderson Christopher · Janesville, WIBuilt 1976 · S/N 15078058N9108AHendrickson Larry L · Chester, MTBuilt 1949 · S/N 18867N9108URegistration Pending · Studio City, CARegistration pendingBuilt 1976 · S/N 15078059N9109ADra Classic Aircraft LLC · Gravette, ARBuilt 1949 · S/N 18868N9109UBrotherson Brian C · Independence, KYBuilt 1976 · S/N 15078060N910DCClair Daniel · Loraine, ILBuilt 2012 · S/N 75-8535N9110ASmith Sidney R · Rllng Hls Est, CABuilt 1949 · S/N 18869N91111Strawn Dale L · Live Oak, FLFirst renewal noticeBuilt 1964 · S/N A-1000N9111UKingdom Air Corps Inc · Sutton, AKBuilt 1976 · S/N 15078062N9112BFosgate Helen Hines · Bogart, GABuilt 1958 · S/N 36612N9112UOstrander William P · Millerton, PABuilt 1976 · S/N 15078063N9113AMulqueen John · Fort Wayne, INBuilt 1978 · S/N 415N9113BBrown David L · Spring City, TNBuilt 1958 · S/N 36613N9114AHayes Sean M · Kodiak, AKBuilt 1949 · S/N 18873N9114UMarek John M · Tucson, AZBuilt 1976 · S/N 15078065N9114ZLarson Richard W · Sioux Falls, SDBuilt 1965 · S/N 17252869N9115BParker Justin S · Elko, NVBuilt 1958 · S/N 36615N9115UWigley Ben F Jr · Huntington, ORFirst renewal noticeS/N 15078066N9116BS Dacy Enterprises Inc · Harvard, ILBuilt 1958 · S/N 36616N9117BPartridge John R · Manchester, NHS/N 36617N9117UBahr Timmy A · Crandon, WIBuilt 1976 · S/N 15078068N9118BCulpeper Aviation LLC · Queen Creek, AZBuilt 1958 · S/N 36618N9118U9118u LLC · Dover, IDBuilt 1976 · S/N 15078069N911HGGibson Robert L · Murfreesboro, TNBuilt 1970 · S/N 2AN9121ECunningham Frank D · Okeechobee, FLBuilt 1946 · S/N 11AC-752N9123BStockton Clifford A · Anchorage, AKBuilt 1958 · S/N 36723N9124AWest Kevin B · San Antonio, TXBuilt 1949 · S/N 18883N9126ARehm William J · Bluffton, OHBuilt 1950 · S/N 19417N9126EAlajoki Roger W · Menahga, MNBuilt 1946 · S/N 11AC-759N9127ABehrens Gary K · Slidell, LABuilt 1949 · S/N 18886N9127BBassham Rick D · Bluff Dale, TXBuilt 1958 · S/N 36727N9128AAl-Banna Reyadh David · Huntingtown, MDFirst renewal noticeBuilt 1949 · S/N 18887N9128RExtraspecial LLC · Wilmington, DEBuilt 1958 · S/N 7FC-230N9128UHarrell Brian · Donalsonville, GABuilt 1976 · S/N 15078079N9129BBoughroum Youssef · Grovetown, GABuilt 1958 · S/N 36729
Back to AD 94-05-05 R1