AD 79-22-01

Registered aircraft · 2,034

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-22-01')
    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-22-01')
  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.

N11667Winiarski Kenneth J · Forest Twp, MEBuilt 1972 · S/N 845-72N1166ELake Jeffrey W · Steamboat Springs, COBuilt 1977 · S/N 251-77N11670Michaud Paul K · Forest Lake, MNBuilt 1972 · S/N 846-72N11672Mooney Services LLC · Greenbush, MNS/N 848-72N11675Nilles Paul · Athens, OHBuilt 1972 · S/N 850-72N11680Adams Jonathan · Columbia, MOBuilt 1972 · S/N 21-72N11683Osborne Barry G · Brainerd, MNBuilt 1972 · S/N 852-72N11693Miller Robert A · Auburn, CAS/N 853-72N11695Rvi Aviation LLC · Clay Center, KSBuilt 1972 · S/N 856-72N11704Jackman William L · Newman Lake, WAS/N 857-72N11707Catfish Express Inc · Inverness, MSBuilt 1972 · S/N 15-72N11709Hutchins Reid C · Hanover, NHBuilt 1972 · S/N 859-72N11720Mcfarlane Kevin E · Dubuque, IABuilt 1972 · S/N 860-72N1174EInman James Dylan · Parsons, TNS/N 1228-78N1175ENannini Gary S · Lincoln City, ORBuilt 1977 · S/N 314-77N1177BTakacs John Paul III · Colorado Springs, COBuilt 1991 · S/N 651-91N1179EPlane Air LLC · Paducah, KYFirst renewal noticeBuilt 1977 · S/N 1220-77N117TMRegistered aircraftBuilt 2000 · S/N 874-2000N1184EHutchins Chad M · Colorado Springs, COBuilt 1977 · S/N 1217-77N11854Wildenberg Craig E · Menomonie, WIFirst renewal noticeBuilt 1972 · S/N 825-72N11861Haga Kim E · Karlsruhe, NDS/N 829-72N1186EHowatt Air Inc · Langdon, NDBuilt 1977 · S/N 257-77N11870Owens Eric D · Garland, TXFirst renewal noticeBuilt 1972 · S/N 12-72N118AC9 Echo LLC · Muskogee, OKBuilt 1992 · S/N 672-92N1199EThibodeaux Brian A · Eagle River, AKS/N 254-77N119BCW D Investments LLC · Sammamish, WAS/N 499-2007N11BWQuonset Aviation LLC · North Kingstown, RIBuilt 1978 · S/N 434-78N11MFCroom Aviation LLC · Port Saint Joe, FLBuilt 1972 · S/N 9-72N1217EJohnston Jason · Chugiak, AKS/N 255-77N1218EShibakov Alexander Y · Gainesboro, TNBuilt 1977 · S/N 324-77N121SGTaliaferro Leigh · Abilene, TXBuilt 2006 · S/N 1036-2007N1223EBatzer Chad M · Pewaukee, WIBuilt 1977 · S/N 325-77N1225WWaak Pamela J · Cleveland, WIBuilt 1998 · S/N 812-98N1230SSpecialized Aero Works LLC · Bend, ORBuilt 2005 · S/N 1011-2005N123BYRegistered aircraftBuilt 2003 · S/N 915-2003N123DAVanderpool Tyler · Edinburg, TXS/N 798-71N123WAAshem Aviation LLC · Wilmington, DEBuilt 1993 · S/N 726-94N124MCMonteleone Gene R · Mont Vernon, TXBuilt 1979 · S/N 502-79N124SCK2 Worldwide Inc · Simi Valley, CAS/N 8822001N124SGFull Props LLC · Ridgeland, SCBuilt 2008 · S/N 1071-2008N125CMKuester Austin · Oshkosh, WIBuilt 2005 · S/N 1392-2005N125RSAlexander William F · Chapmansboro, TNBuilt 1991 · S/N 657-91N125WB90er LLC · Wilmington, DEBuilt 2008 · S/N 505-2008N126WBFlying Blank LLC · La Crosse, WIBuilt 2005 · S/N 983-2005N127BDRegistered aircraftBuilt 2022 · S/N 620-2022N127SAVintage Tailwheel LLC · Wilmington, DEBuilt 2006 · S/N 1026-2006N127TMPlane Air LLC · Paducah, KYBuilt 2001 · S/N 427-2001N128DMTransnovia LLC · Haslett, MIBuilt 1999 · S/N 1375-99N128VMThomas Lucas G · Beebe, ARBuilt 2017 · S/N 585-2017N12KDDeeble Kenneth M · Dayton, MTBuilt 1979 · S/N 596-80
Back to AD 79-22-01