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.

N12TNEgret Aero Inc · Colorado Springs, COBuilt 2013 · S/N 1127-2013N130ACBilco Air LLC · Danville, ILBuilt 1992 · S/N 663-92N130VUSwords Kyle · New Albany, MSBuilt 1975 · S/N 180-75N131DWWeitz David M · Caldwell, IDBuilt 2015 · S/N 569-2015N131GSStanley Gerald L · Littleton, COBuilt 1999 · S/N 839-99N131PMDodge Sean · Littleton, NHS/N 462-2004N131RAFlorida Institute Of Technology · Melbourne, FLBuilt 2003 · S/N 1389-2003N131RCNordman Clay DBA · Catheys Valley, CAFirst renewal noticeBuilt 1996 · S/N 376-96N131SEHouseman Steven · Chillicothe, OHBuilt 2006 · S/N 490-2006N1322XGrecor LLC · Ashville, ALBuilt 2015 · S/N 1163-2015N132ACScott John A · Odebolt, IABuilt 1992 · S/N 675-92N132DPKarl Mark G · Wilbraham, MABuilt 1999 · S/N 822-99N132PAAumont Eric J · Yucca Valley, CABuilt 1998 · S/N 817-98N132PJPierson Ted · Gooding, IDBuilt 2007 · S/N 496-2007N133JFWindsock Capital LLC · Bertram, TXBuilt 1973 · S/N 73-73N133NO'Brien Daniel R · Naples, FLS/N 1113-2012N133PJAmerican Liquid Concentration Operations LLC · Lewes, DEBuilt 2006 · S/N 486-2006N134MAMike Alpha LLC · Lewes, DEBuilt 2001 · S/N 429-2001N134RCScout Aviation LLC · Twin Falls, IDS/N 314-79N135DLOver And Under Flying Service Inc · Knox, INS/N 3372N135TMMowbray Jerry H · Reno, NVBuilt 2001 · S/N 1384-2001N136ACPreacher John R · Jackson, GAS/N 673-92N137ACHare Michael Aubrey · Foley, ALBuilt 1992 · S/N 676-92N137JWNetwork Sales & Leasing Inc · Newtown, PABuilt 2011 · S/N 537-2011N138ACZimmerman Gerald M · Savannah, GABuilt 1992 · S/N 677-92N138GBBurgan Grover W · Jacksonville, FLBuilt 2005 · S/N 473-2005N139ACDavis Mark A · Lubbock, TXBuilt 1992 · S/N 686-92N139BCTrombley Steven T · Worland, WYBuilt 2008 · S/N 506-2008N13JHL J H Consulting LLC · Greenleaf, IDBuilt 2021 · S/N 617-2021N13PMFly High Aviation LLC · Melrose Park, ILBuilt 1977 · S/N 305-77N13RHChrist Graham Charles · Mandeville, LABuilt 1973 · S/N 973-73N13WLRegistration Pending · Bristol, SDRegistration pendingBuilt 2020 · S/N 605-2020N141BCAtkinson Air LLC · Dixon, CABuilt 2020 · S/N 602-2020N141BHBob Hannah Aviation LLC · Caldwell, IDBuilt 2022 · S/N 623-2022N141CHRegistered aircraftBuilt 1979 · S/N 324-79N141SEHydro Flyers LLC · Woodside, CABuilt 2006 · S/N 1024-2006N142ACFly For Fun LLC · Rockville, MDBuilt 1992 · S/N 683-92N145ACTrusler William L · Magnolia, TXBuilt 1992 · S/N 684-92N145BCMazur Steve J · Fairbanks, AKBuilt 2004 · S/N 456-2004N145RWHolder Robert W · Pittsfield, PABuilt 1971 · S/N 800-71N146MAHong Ted · San Jose, CABuilt 2002 · S/N 903-2002N146MCGibson William V · Aberdeen, MSS/N 54-73N1470ZBig Tree LLC · Caldwell, IDS/N 189-76N147BCCard Logging Co Inc · Eugene, ORFirst renewal noticeBuilt 2003 · S/N 447-2003N147TPPatty Wagstaff Aviation Safety LLC · Saint Augustine, FLBuilt 2008 · S/N 10602008N147TQIron Thermal LLC · Hogansville, GABuilt 2003 · S/N 920-2003N148ACMach 1 Aircraft LLC · Malibu, CABuilt 1993 · S/N 717-93N148AKMurphy Patrick · Englewood, COBuilt 2014 · S/N 1140-2014N148BCWalker Dean M · Fort Collins, COBuilt 2008 · S/N 507-2008N148PCSuperd LLC · Everett, WABuilt 2005 · S/N 996-2005
Back to AD 79-22-01