OpenAirDocs.org
AD 79-10-14 R1

Registered aircraft · 56,580

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.

N331DTTolkach Dennis G · Dunlevy, PAS/N 18504238N331GWFieldcrest Air LLC · Latrobe, PABuilt 2021 · S/N 18283147N331JCCsp Aviation Holdings LLC · Dallas, TXBuilt 1966 · S/N 15064821N331JKKenzy 2020 LLC · Aurora, ORBuilt 2021 · S/N 172S12751N331JTJuliet Tango Flying Services LLC · Walnut Creek, CABuilt 1972 · S/N 18501899N331KWHeritage Academy Inc · Monterey, TNBuilt 1963 · S/N 3360026N331LCEblc Aviation LLC · Hollywood, FLS/N U20605254N331MEHarrison Matthew T · Naponee, NEBuilt 2000 · S/N 172S8464N331MSAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2007 · S/N 18282021N331RPRaritan Valley Flying School · Princeton, NJS/N 172S9863N331SPReinfeldt Phillip R · Burnsville, MNS/N 18268441N3320DPara Tactics LLC · Shelton, WAS/N 32118N3320FPoock Jerry D · Spencer, IABuilt 1966 · S/N 18257320N3320JPollman Justin A · Sherwood, NDS/N 15066020N33212Burlingame Lloyd · Fort Atkinson, WIBuilt 1976 · S/N 177RG0920N33216Avarts LLC · New Castle, DES/N U20602676N3321DWood Steveno · Morgan, UTS/N 32119N3321FOwl Aviation LLC · Kingsport, TNBuilt 1966 · S/N 18257321N3321JFulton Ricky L · Alex, OKBuilt 1966 · S/N 15066021N3321RGray Kerry L · Granbury, TXBuilt 1967 · S/N 18258621N3321TWilks Donald Leon · Flat Rock, ALBuilt 1967 · S/N 17700621N3321VRegistered aircraftBuilt 1974 · S/N 15076462N33220Advanced Analytical Inc · Newbury Park, CABuilt 1976 · S/N 177RG0925N3322DObrien Aviation LLC · Moreno Valley, CABuilt 1955 · S/N 32120N3322FCrystalline Entity · Los Angeles, CABuilt 1966 · S/N 18257322N3322UPrecision Design Inc · Wilimington, DEBuilt 1963 · S/N 18254722N3322YFostair Inc · Ovid, NYS/N 18254322N33230Alaska Air Service LLC · Brookings, ORBuilt 1976 · S/N 177RG0930N3323DPrince Christopher E · Anchorage, AKBuilt 1955 · S/N 32121N3323FFly The Dream LLC · Sun Prairie, WIBuilt 1966 · S/N 18257323N3323JRichards Amy L · Union City, INBuilt 1966 · S/N 15066023N3323RD&J Air Adventures Inc · Koloa, HIBuilt 1967 · S/N 18258623N3323TDeese James K Jr · Charlotte, NCS/N 17700623N3323YMiellerie LLC · Bridgeport, TXBuilt 1962 · S/N 18254323N33247R House Leasing LLC · Stormville, NYBuilt 1975 · S/N U20602692N33248Wilson Harvey Lee · Gadsden, ALBuilt 1976 · S/N 177RG0932N3324UHaer Welton · Craig, MOBuilt 1963 · S/N 18254724N3324YVoge Michael · Chino Hills, CABuilt 1962 · S/N 18254324N3325RDresick Farms Inc · Huron, CABuilt 1968 · S/N 18258625N3325UWeber Donald E · Saint David, AZS/N 18254725N3326FRegistered aircraftBuilt 1966 · S/N 18257326N3326RAnderson Patrick Alan · Ripley, WVS/N 18258626N3326TGallman Doug M · Port Orange, FLBuilt 1967 · S/N 17700626N33272Explorco LLC · Evergreen, COBuilt 1976 · S/N 177RG0938N33273Dahl Neil A · Arlington, TXBuilt 1976 · S/N 177RG0939N33274Cooker Brian M · Gold Hill, NCBuilt 1976 · S/N 177RG0940N33277Niebuhr Bradley A · Morriston, FLS/N U20602708N3327DWelborn Mark G · Boonville, NCFirst renewal noticeS/N 32125N3327GWhitewater Aviation Inc · Harrison, OHBuilt 1972 · S/N 17261224N3327RLyman Gregory A Trustee · Traverse City, MIBuilt 1967 · S/N 18258627
Back to AD 79-10-14 R1