OpenAirDocs.org
AD 79-10-14 R1

Registered aircraft · 56,578

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.

N185WVScenic Air LLC · Kalispell, MTBuilt 1977 · S/N 18503252N185WWWright John M · Bellevue, IDBuilt 1981 · S/N 18504310N185WXChew Scott E · Estes Park, COBuilt 1975 · S/N 18502633N185WYBrantner Brian P · Spokane Valley, WABuilt 1967 · S/N 185-1229N185WZB H Hildebrand Construction Inc · Cataldo, IDBuilt 1980 · S/N 18504102N185XSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1982 · S/N 18504220N185XLBryant Theodore M · Wasilla, AKBuilt 1981 · S/N 18504211N185XSJepsen John S · Anchorage, AKBuilt 1977 · S/N 18503315N185XVN185xv LLC · Austin, TXS/N 18503778N185YLee Bryan D · Rexburg, IDFirst renewal noticeS/N 18502224N185YHMcdaniel Robert M · Tonasket, WAS/N 18503551N185YMBarber Michael E · Prescott Valley, AZBuilt 1977 · S/N 18503441N185YTSutton Aircraft Salvage LLC · Palmer, AKS/N 185-0145N185YVCul-Aircorp Inc · Wellington, FLBuilt 1978 · S/N 18503546N185YYDagostino Thomas J · Wasilla, AKS/N 18503195N185ZWab Air LLC · Butte, MTBuilt 1968 · S/N 1851363N185ZAPlane Fun Inc Tr Trustee · Snellville, GABuilt 1965 · S/N 185-0983N185ZMDragon Wagon LLC · Clackamas, ORBuilt 1981 · S/N 18504324N185ZZLeading Edge LLC · Scottsdale, AZBuilt 1966 · S/N 185-1029N18602Poston James M · Hixson, TNBuilt 1976 · S/N 17702544N1860YPeterson Jerad · Oshkosh, NES/N 17249460N18612Missoula Fliers LLC · Milltown, MTBuilt 1972 · S/N 15073987N18618Hammons Bryan S · Stephenville, TXBuilt 1972 · S/N 15073991N1861CSierra Flying Club LLC · Woodinville, WABuilt 1953 · S/N 26005N1861XCabreja Sanchez Elmer · Carolina, PRBuilt 1964 · S/N 18255961N1861ZPadden Geary L · Duluth, MNBuilt 1962 · S/N 205-0061N18623Fleischmann Fred · Racine, WIBuilt 1972 · S/N 15073994N18627Oberhansly Lucas C · Roy, WABuilt 1972 · S/N 15073998N18628Paul William A · Windfall, INBuilt 1972 · S/N 15073999N1862CCoffey Calvin A · Mckinney, TXBuilt 1953 · S/N 26006N1862QB & P Transportation LLC · Mount Blanchard, OHBuilt 1972 · S/N 177RG0262N1862XCose Gary D · Livermore, CABuilt 1964 · S/N 18255962N1862YVakalis Kevin A · Chugiak, AKBuilt 1962 · S/N 17249462N18630Gaddy Tyler Quintin · Advance, NCBuilt 1972 · S/N 15074000N18634Bagge William J · East Longmeadow, MABuilt 1972 · S/N 15074004N18637Vincent Addison J · Waynesburg, OHBuilt 1972 · S/N 15074006N1863CWalch Brian A · Anchorage, AKBuilt 1953 · S/N 26007N1863FAndersen Dana K · Scappoose, ORS/N 21058763N1863QCollins David A · Portland, ORBuilt 1972 · S/N 177RG0263N18640Smith David W · Elgin, SCBuilt 1972 · S/N 15074008N18643Registered aircraftN-number assigned, not yet registeredS/N 17702545N18645Sorenson Mark A · Senoia, GAS/N 15074011N18649Dixon Robert D · Derry, PABuilt 1972 · S/N 15074015N1864CRegistered aircraftBuilt 1953 · S/N 26008N1864FSwensen Nathan E · Winnemucca, NVS/N 21058764N1864VFrost Dennis J · Appleton, WIBuilt 1974 · S/N 17263774N1864YHeckendorf Jon W · Ordway, COBuilt 1962 · S/N 17249464N18656Larsen Steve · Colton, ORBuilt 1972 · S/N 15074019N1865XAria & Arjun LLC · Cumming, GABuilt 1964 · S/N 18255965N1865ZBpf Equipment LLC · Burnet, TXBuilt 1962 · S/N 205-0065
Back to AD 79-10-14 R1