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.

N9797TBasham James L · Livingston, TXS/N 47597N9797XDeckpro LLC · Rexburg, IDBuilt 1962 · S/N 21058097N97981Grindstaff Aircraft Leasing Inc · Crossville, TNBuilt 1979 · S/N 18267266N97984Woody George R · Clinton, ARBuilt 1984 · S/N 17276244N9798ARupert Yuri · Lillian, ALFirst renewal noticeBuilt 1950 · S/N 19259N9798GJantz Merle Trustee · North Pole, AKBuilt 1972 · S/N 18052298N9798TRegistered aircraftBuilt 1960 · S/N 47598N9798ZWright Air Service Inc · Fairbanks, AKBuilt 1982 · S/N U20606665N97993N97993 LLC · Middleton, MABuilt 1979 · S/N 18267272N97995Lxs Farms LLC · El Paso, TXBuilt 1979 · S/N 18267273N97997Redline Aviation Inc · Sioux City, IABuilt 1979 · S/N 18267275N9799ESkyhigh Trade LLC · Wilmington, DEBuilt 1984 · S/N 18268447N9799HFriehe Berend · Moses Lake, WABuilt 1981 · S/N 18268033N9799TDeapen Jordan Derek · Clifton, TXBuilt 1960 · S/N 47599N979BCMacinnis Charles E · Harbor Springs, MIBuilt 1997 · S/N 17280060N979BVTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 172S13490N979CPCivil Air Patrol Inc · Maxwell Fb, ALBuilt 1997 · S/N 17280210N979EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2023 · S/N 172S13019N979JFGoodspeed Air Service LLC · Oxford, CTBuilt 1966 · S/N 17254071N979PTCappe Ivestment Group LLC · Homestead, FLBuilt 1974 · S/N 17264503N979WDDolphin Leasing LLC · Daytona Beach, FLBuilt 2005 · S/N 172S10077N97ATRainier Flight Service LLC · Renton, WABuilt 2005 · S/N 172S9853N97AVCertified Aviation LLC · Dawson, GAS/N 18266809N97BSSidewinder Services LLC · Genoa, NVBuilt 1973 · S/N 17262475N97DSWmg Aviation LLC · Ketchum, IDS/N 18504173N97EKern County Sheriffs Department · Bakersfield, CABuilt 1983 · S/N 21064788N97FAJalbert John E · Greenville, MEBuilt 1982 · S/N 18504373N97FCParker Cullen B · San Antonio, TXBuilt 1962 · S/N 18051106N97FFPeregrine Howard Fund V Owner LLC · New Orleans, LABuilt 2024 · S/N 172S13207N97FRSmith Ralph E · Lyndonville, NYBuilt 1980 · S/N 17274188N97HYFulghum Michael Eugene · Humble, TXBuilt 2004 · S/N 18281349N97JBVieira Nunes Da Silva Raphael · Ethel, LABuilt 1966 · S/N 17255305N97LFSpengler Raymond Francis Jr · Longview, TXBuilt 1997 · S/N 17280286N97MWRudderworks Aviation LLC · Fairfax Station, VABuilt 1975 · S/N 17264946N97PDBoeing Employees Flying Association Inc · Renton, WABuilt 2000 · S/N 172S8392N97RWWiplinger Robert D · Inver Grove Hts, MNS/N 18280387N97VACamps Bay Aviation LLC · Waukegan, ILBuilt 2005 · S/N 172S9906N9800JButts James Allen · Gainesville, GABuilt 1975 · S/N A1500609N9800THerr Garrick D · Wasilla, AKBuilt 1960 · S/N 47600N9801GTriad Aviation Academy LLC · Greensboro, NCS/N 17259701N9802EPouya Hamid · San Jose, CABuilt 1975 · S/N 18263916N9802HPatterson Aubrey III · Saltillo, MSBuilt 1981 · S/N 18268034N9802TSandford Graves M · Moberly, MOS/N 47602N9802XMeise Fred W · Moses Lake, WABuilt 1961 · S/N 1850002N9802ZBig Horn Aviation Group · Fort Worth, TXBuilt 1982 · S/N U206-06667N9803CWhite Traci M · Manasquan, NJBuilt 1971 · S/N 17259703N9803HCoburn Alan B · Plantation, FLBuilt 1981 · S/N 18268035N9803VKoinzan Enterprises Inc · Elgin, NEBuilt 1966 · S/N 188-0053N9803XPatrick Samuel Garrett · Durango, COBuilt 1961 · S/N 1850003N9803ZBig Horn Aviation Group · Fort Worth, TXBuilt 1982 · S/N U20606668
Back to AD 79-10-14 R1