OpenAirDocs.org
AD 79-12-08

Registered aircraft · 1,036

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-12-08')
    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-12-08')
  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.

N1020HHw Barnhouse Inc · Vero Beach, FLBuilt 1968 · S/N 30-1569N103PGHnd Operations LLC · Henderson, NVBuilt 1969 · S/N 30-1858N104CPN7293l LLC · Waxahachie, TXBuilt 1966 · S/N 30-1276N1100LRaider Aviation LLC · Lubbock, TXS/N 30-12N110LLFlight Level 7 Inc · Wilmington, DEBuilt 1971 · S/N 39-89N110WWTorba Jacob · Citrus Heights, CABuilt 1969 · S/N 30-1846N1111HBielamowicz John Kolbe · Waxahachie, TXBuilt 1964 · S/N 30-427N111PLColumbia Asset Trust Corp Trustee · Wichita, KSBuilt 1969 · S/N 301929N1147N7371y LLC · Waterford, MIBuilt 1964 · S/N 30-423N114CDNorwest Ventures LLC · Santa Cruz, CABuilt 1963 · S/N 30-37N114RSLuggelle Michael · Hull, MABuilt 1966 · S/N 30-1094N1188YSkylark Flight Training LLC · Panama City, FLBuilt 1964 · S/N 30-403N118BLEdge Aviation LLC · Hawthorne, FLBuilt 1965 · S/N 30-913N11KYKlad-Air LLC · Catlett, VABuilt 1966 · S/N 30-1181N11PYCuller John T · Arvada, COBuilt 1964 · S/N 30-533N11QTAv8rs LLC · Sugar Valley, GABuilt 1968 · S/N 30-1780N11YYAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1967 · S/N 30-1573N1206APelham Aircraft LLC · Dallas, TXBuilt 1966 · S/N 301206N1236Entwistle Brian V · Knoxville, TNS/N 30-1167N123MKSolomon Steven · Cherry Hill, NJBuilt 1965 · S/N 26-141N126MAWinter Kristin A · Spring Lake Park, MNBuilt 1969 · S/N 30-1865N126PFPylant Ruth A · Lubbock, TXS/N 30-1122N128LBWareham Andrew John · Wasilla, AKBuilt 1966 · S/N 30-1132N12FSLawley Frederick E · Bozeman, MTBuilt 1966 · S/N 30-1226N12MPMarcus Robert L · Dallas, TXBuilt 1963 · S/N 30-284N130MMMighty Mike LLC · Maysville, KYBuilt 1964 · S/N 30-550N132CTausch Roger M · Saint Charles, MIBuilt 1963 · S/N 30-62N13GPWeidner Kevin G · Bunker Hill, ILBuilt 1967 · S/N 30-1535N142EN142e LLC · Page, AZBuilt 1967 · S/N 30-1479N143MMPalo Michael Scott · Melbourne, FLBuilt 1970 · S/N 39-18N148SBGriner Warren D · Pinson, ALBuilt 1966 · S/N 30-1148N156LMLoup Technologies Inc · Longmont, COBuilt 1966 · S/N 30-1017N160MJFoley Robert A · Columbia, NJS/N 30-1410N161REVornholt David · New Richmond, OHBuilt 1969 · S/N 30-1952N162PMFrench Loren · Gypsum, COBuilt 1963 · S/N 30-72N166SPSwitzer James DBA · Costa Mesa, CABuilt 1964 · S/N 26-79N16AMAnimal Health Supply Inc · Vinita, OKBuilt 1968 · S/N 30-1693N16NJBurke Bryan E · Broomfield, COBuilt 1969 · S/N 30-1845N16TWBaughman Kevin · Avinger, TXBuilt 1964 · S/N 30-527N178EGagan Samrat LLC · Charlotte, NCS/N 30-1727N178UDavis Roger W · Felton, DEBuilt 1969 · S/N 30-1779N178XSs Aviation LLC · Sulphur, LAS/N 30-1950N17BDRegistered aircraftBuilt 1967 · S/N 30-1520N17CMAbernathy Laurence K · Wills Point, TXBuilt 1964 · S/N 30-437N17MBAerocorp LLC · San Antonio, TXBuilt 1966 · S/N 30-1215N1956RCorrech Jose Pedro · Cape Coral, FLBuilt 1971 · S/N 39-85N19VSGardner James R · League City, TXBuilt 1963 · S/N 30-144N1MEHall James C · Redington Beach, FLBuilt 1967 · S/N 30-1439N1NTDmac Aircraft LLC · Savannah, GABuilt 1964 · S/N 30-262N1WUN1wu LLC · Loganville, GABuilt 1966 · S/N 30-1383
Back to AD 79-12-08