AD 79-10-14 R1

Registered aircraft · 56,582

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.

N9296HSmith Richard A · Burnsville, MNBuilt 1975 · S/N 17266076N9296XJasuma Farms · Maxwell, CABuilt 1961 · S/N 18253696N92970Elizabeth City State University · Elizabeth City, NCBuilt 2011 · S/N 172S11124N9297TSutton Aircraft Salvage LLC · Palmer, AKBuilt 1960 · S/N 50797N9297UNorthwest Wings LLC · Hillsboro, ORBuilt 1976 · S/N 15078247N9297XJohnson Durwood D · Beaumont, TXBuilt 1962 · S/N 18253697N9298AHenderson Larry V · Highland Village, TXBuilt 1949 · S/N 19059N9298GA&A Aviation LLC · Mountain Brk, ALS/N 18260838N9298ZFrederick Ag LLC · Humboldt, KSS/N 17701215N929AEColman Steve · Alamosa, COBuilt 1959 · S/N 50457N929BMSuntops Aircraft Holding LLC · Lakeland, FLBuilt 1975 · S/N 17265826N929FRacoon Aviation LLC · San Antonio, TXBuilt 1953 · S/N 30188N929LSFlying Tigers Flight School Ltd · Houston, TXBuilt 1972 · S/N 17260660N929PMRegistered aircraftBuilt 1979 · S/N 18266844N929RHJohnson Merlin K Trustee · Mentone, CABuilt 1964 · S/N 206-0061N92ATBroquet Bruce L · Anchorage, AKBuilt 1981 · S/N 18053169N92CRodriguez Michael C · Drums, PAS/N P3370128N92CCCanadian Co Sheriffs Office · El Reno, OKBuilt 1965 · S/N 17253144N92CMN92cm LLC · Genola, UTS/N 18260420N92CPSlattery Richard E · Fountain Valley, CABuilt 1953 · S/N 30019N92DCAdams Bob L · Eagle River, AKBuilt 1975 · S/N 18502828N92DSBooty Bill · Idaho Falls, IDBuilt 1975 · S/N 21060847N92DWBurnette Jeffrey T · Big Lake, AKBuilt 1958 · S/N 55046N92FRGliem Robert E Jr · Eddystone, PABuilt 1979 · S/N 17273140N92FSEastern Kentucky University · Richmond, KYBuilt 1998 · S/N 17280308N92HFHeritage Asset Leasing LLC · Ronkonkoma, NYBuilt 2000 · S/N 172S8642N92LCEastern Kentucky University · Richmond, KYBuilt 1997 · S/N 17280153N92MMAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1975 · S/N 17266052N92NAOneill Laurie A · Pinckney, MIS/N 207-00093N92RHCrabtree Nathan J · Boise City, OKBuilt 1967 · S/N P206-0431N92SCMorrison Neil E · Port Townsend, WABuilt 1967 · S/N R172-0211N92WMGerhardt David C · Denver, COBuilt 1979 · S/N 18503859N9300BBenson Ryan Denson · New Carlisle, OHS/N 55100N9300NChristensen Hans · Enterprise, UTBuilt 1981 · S/N 18504328N9300XEdwards Karen Marie · Mcminnville, ORS/N 18253700N93010Davis Russell C · Odessa, TXBuilt 1976 · S/N 18503158N93018Joy Austin J Jr · Anchorage, AKBuilt 1976 · S/N 18503161N9301BGimli Son LLC · Fort Lauderdale, FLBuilt 1980 · S/N 172RG0786N9301ERyan Aircraft Holding LLC · Orlando, FLBuilt 1979 · S/N 17272216N9301XShaunkoe LLC · Merrill, ORBuilt 1961 · S/N 18253701N93020Red Leasing LLC · Juneau, AKS/N 20700385N93022Red Leasing LLC · Juneau, AKBuilt 1979 · S/N U20605463N93023Ward Air Inc · Juneau, AKBuilt 1976 · S/N U20603526N93024Ward Air Inc · Juneau, AKS/N U20604392N93025Kiesel Edward K · Juneau, AKBuilt 1976 · S/N 18503163N93027Indy Air LLC · Blaine, MNBuilt 1976 · S/N 18503164N93030Cathey Wacey D · Polson, MTBuilt 1976 · S/N 18503165N93033Kaval John P Jr · Duxbury, MABuilt 1976 · S/N 18503166N93035Des Aircraft LLC · Marianna, ARBuilt 1974 · S/N 21060232N93039Dorris Michael R · Mccall, IDBuilt 1977 · S/N 18503169
Back to AD 79-10-14 R1