OpenAirDocs.org
AD 79-10-14 R1

Registered aircraft · 56,580

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:79-10-14-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:79-10-14-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.

N389WAOlsen Donald Jr · Silverdale, WABuilt 1966 · S/N 337-0389N38ALAirloc LLC · Atlanta, GABuilt 2004 · S/N 18281450N38BGCary Aviation LLC · Myrtle Beach, SCS/N 18281334N38CKHartsfield Amy G · Pace, FLS/N 17263959N38FCEagle Aero Inc · Lafayette, LABuilt 1980 · S/N 18504145N38FGPatten Mark Samuel · Anchorage, AKBuilt 1979 · S/N 18503920N38FRHenry Scott · Kingman, AZBuilt 1978 · S/N 17270698N38PAMarine Flyer LLC · Eddyville, KYBuilt 1977 · S/N 17270182N38PDRichmond Pilots Corp · Linden, NJBuilt 2000 · S/N 172S8381N38PFSycan Corp DBA · Paso Robles, CABuilt 1980 · S/N 21063979N38RAAb Prop Plane II LLC · Metairie, LABuilt 2024 · S/N 172S13272N38RZGgt Aviation LLC · Saint Paul, MNBuilt 1977 · S/N 18265430N38SBAb Prop Plane II LLC · Metairie, LABuilt 2024 · S/N 172S13261N38TDLewis Brian D · Bumpass, VAS/N 15073098N38USUnited States Aviation Underwriters Inc · New York, NYBuilt 2002 · S/N 18281173N38WTReed Brian A · Kilgore, TXBuilt 1969 · S/N 15071384N38ZZZulu Zulu Av8 Inc · Las Vegas, NVS/N 18262727N3900FNolen Parker · Manson, WABuilt 1958 · S/N 36800N3900GCoyle Jerry Lee · Prairie Grove, ARBuilt 1967 · S/N U206-0900N3900LShaw Flying Club LLC · Cleveland, MSS/N 17254069N3900SCrowe Tim · Winchester, KYBuilt 1964 · S/N 17251100N3900UHeston Jeffrey W · Warren, OHBuilt 1965 · S/N 15061300N3900VMays Kevin E · West Liberty, KYBuilt 1948 · S/N 18210N3901CAero II Inc · Spartanburg, SCBuilt 1968 · S/N 15069096N3901DDanford Scott M · Chickamauga, GAS/N 34601N3901FCda Maine LLC · Winthrop, MEBuilt 1958 · S/N 36801N3901JHolladay Leonard · Greeley, COBuilt 1966 · S/N 15065201N3901LSan Fernando Aviation LLC · Van Nuys, CAS/N 17254070N3901RMuth Joseph A · Richmond, KYS/N 17255401N3901SEggett Glade · Brigham City, UTBuilt 1963 · S/N 17251101N3901YCentruion Express LLC · North Port, FLS/N 21058401N3902CRegistration Pending · Post Falls, IDRegistration pendingBuilt 1968 · S/N 15069101N3902FMagaw David N · Sacramento, CABuilt 1958 · S/N 36802N3902JUltimate Aviation LLC · Lowell, ARBuilt 1966 · S/N 15065202N3902RBotero Jorge · Alexandria, VAS/N 17255402N3902SGooding Flying Club · Gooding, IDBuilt 1963 · S/N 17251102N3903FSlattery Gordon C · Chippewa Falls, WIBuilt 1958 · S/N 36803N3903QWashington Chinook LLC · Bellingham, WABuilt 1973 · S/N 18502209N3903RDanielson Bradley K · Willmar, MNBuilt 1966 · S/N 17255403N3903SAt Aero LLC · Wilmington, DEBuilt 1963 · S/N 17251103N3903VMiller Charles G · Anchorage, AKBuilt 1948 · S/N 18213N3904DOreilly Thomas P · Oscoda, MIS/N 34604N3904FPedersen Blake A · Clackamas, ORBuilt 1958 · S/N 36804N3904QKern Bruce A · Collinsville, OKBuilt 1971 · S/N 17260004N3904SLambert Aviation Service LLC · Washington, PABuilt 1963 · S/N 17251104N3904UKunkel Keith R · Bay City, MIS/N 15061304N3904VObloy James J · Brunswick, OHBuilt 1975 · S/N 15076649N3904YOtto William R · Ontario, CABuilt 1964 · S/N 21058404N3905CWind Walker LLC · Tucson, AZBuilt 1968 · S/N 15069294N3905DKoehn Jerry L · Cimarron, KSBuilt 1957 · S/N 34605
Back to AD 79-10-14 R1