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.

N915DDWest Michigan Aviation Academy · Grand Rapids, MIBuilt 1999 · S/N 172S8149N915LCardinal Flying Corp · San Jose, CABuilt 1976 · S/N 17267355N915LSBlack Bear Aviation LLC · Camden, DEBuilt 2023 · S/N 18283235N915NGWillard Theron K · Anchorage, AKBuilt 1975 · S/N U20602946N915SCI P M Ministries · Dufur, ORBuilt 1954 · S/N 26131N915SPThin Air LLC · Hillsboro, WIBuilt 1969 · S/N 18259816N915TAAurora Aircraft LLC · Waterford, MIBuilt 2006 · S/N 172S10358N915WBBordelon Warren P · Breaux Bridge, LABuilt 1972 · S/N 17261221N915XKSk Aircraft LLC · Anchorage, AKBuilt 1958 · S/N 51506N91602Kreikemeier Michael L · Belgrade, MTBuilt 1969 · S/N 18259838N91604Veeref LLC · Temecula, CAS/N 18259840N91606Zoltak Aviation LLC · Perry, GABuilt 1969 · S/N 18259841N91607Parreira Paul Jr · Dos Palos, CABuilt 1969 · S/N 18259842N9160AAttitude Toys LLC · Wilmington, DEBuilt 1949 · S/N 18921N9160BS & J Investments LLC · Sardis, MSBuilt 1958 · S/N 36760N9160HTodd Media Inc · Tuscaloosa, ALBuilt 1975 · S/N 17265984N91614Hendrich Matthew G · Paso Robles, CABuilt 1969 · S/N 18259844N9161ACabral Aviation LLC · Milton, WABuilt 1950 · S/N 19355N9161BLee Mark S · Grove, OKBuilt 1958 · S/N 36761N9161CLatta Michael D · Auburn, WABuilt 1954 · S/N 31260N9161GBowling Gary L · Elk City, IDBuilt 1971 · S/N 18260701N9161HAir Athens LLC · Athens, GABuilt 1975 · S/N 17265985N9161TMenagerie Enterprises Inc DBA · Denison, TXBuilt 2011 · S/N 172S11093N91621Whitney Richard J · Mason City, ILBuilt 1969 · S/N 18259846N91626Tmstar Services LLC · Lewes, DEBuilt 1969 · S/N 18259850N9162BMedic Choppers LLC · Springdale, ARBuilt 1958 · S/N 36762N9162HStratus Aviation LLC DBA · Vacaville, CABuilt 1975 · S/N 17265986N9162UDag Arda Orcun · Mount Dora, FLBuilt 1976 · S/N 15078113N9163BWright Donald E · Greensboro, NCBuilt 1958 · S/N 36763N9163GHayssen Arthur H · Sebastopol, CABuilt 1971 · S/N 18260703N9164GZirjacks Winston L Jr · Gold River, CABuilt 1971 · S/N 18260704N9164UUnderwood Callum M · Canton, GABuilt 1976 · S/N 15078115N91651Cain Edward A · Pembroke, MABuilt 1969 · S/N 18259856N91657Webster Max S · Dalton, PAS/N 18259858N9165AAdams Harry J · Montgomery, TXBuilt 1952 · S/N 19359N9165ULudwiczak Damian · Medina, OHBuilt 1976 · S/N 15078116N9165XShults Jerry G · Kingsland, TXBuilt 1961 · S/N 18253565N91661James One Seventeen LLC · Fairview, OKBuilt 1969 · S/N 18259861N91667Dennis Robert · Rosamond, CAS/N 18259863N9166BWusterhausen Jerry L · Boynton Beach, FLBuilt 1958 · S/N 36766N9166RSchwend Brian · Forsyth, MTS/N 18802136TN9166UKsnl Aero LLC · Shawnee, OKBuilt 1976 · S/N 15078117N91670Sierrahotellima LLC · Farmingdale, MEBuilt 1969 · S/N 18259864N91672Baldridge Steven J · Edmonds, WAS/N 18259865N91673Martin Charles W · Twain Harte, CABuilt 1973 · S/N 17261506N9167BAshley-Nye Johanna I · Graham, WABuilt 1958 · S/N 36767N9167CNew Garden Township · Landenberg, PABuilt 1972 · S/N 15074232N9167GKgrd Aviators LLC · Greenwood, SCBuilt 1971 · S/N 18260707N9167UTobin Dustin J · Hesperia, CABuilt 1976 · S/N 15078118N9167XRichard I French · Eatonville, WABuilt 1961 · S/N 18253567
Back to AD 79-10-14 R1