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.

N9816GRicker Harry K · Turner, MEBuilt 1971 · S/N 17259716N9817GLester Matthew J · Gouldsboro, MEBuilt 1971 · S/N 17259717N9817HBurcham Timothy Scott · Encinitas, CABuilt 1981 · S/N 18268046N9817JDonahue Patrick J · Carriere, MSBuilt 1975 · S/N A1500626N98182Bena Christopher D Trustee · Wasilla, AKBuilt 1967 · S/N 18258531N98186Loyer Jeffrey W · Olympia, WAS/N 17276265N98188Usda Forest Service Fepp · Columbia, SCS/N R1720077N98189Kashmere Apartments LLC · Missouri City, TXS/N R172-0244N9818GGough Gregory · Emmett, IDBuilt 1971 · S/N 17259718N9818HFowler Raymond E · Smyrna, GABuilt 1981 · S/N 18268047N9818XPlath James F · Davenport, NDBuilt 1961 · S/N 1850018N9819HStanley Aero Club Gastonia Inc · Belmont, NCBuilt 1981 · S/N 18268048N9819JFranco Louise A · El Cerrito, CABuilt 1975 · S/N A1500628N981AKState Of Alaska · Anchorage, AKBuilt 1981 · S/N U20606248N981BCSilverhawk Aviation Academy LLC · Caldwell, IDBuilt 1998 · S/N 17280464N981BTPea-Wayman Flight LLC · Daytona Beach, FLBuilt 1998 · S/N 17280430N981CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1997 · S/N 17280215N981MARed Rose Flight Tours LLC · Lancaster, PABuilt 1978 · S/N 17271239N981MRJlove LLC · Vienna, VABuilt 2010 · S/N 18282212N981RDSunrise Adventures LLC · Stillwater, MNBuilt 1981 · S/N U20605872N981SCCarter Brooks LLC · Kalispell, MTBuilt 1963 · S/N 18051339N981SFAtp Aircraft 1 LLC · Wilmington, DEBuilt 2013 · S/N 172S11293N981SPLlp Leasing Group LLC · Lewes, DEBuilt 1999 · S/N 172S8183N981TWKent Mark · Holden, MABuilt 2002 · S/N 172S9081N981WBFlying Fortress Of Swfl LLC · Fort Myers, FLS/N U20606221N981WMFlying Fortress Of Swfl LLC · Fort Myers, FLS/N 21059911N981WSNayrmarc LLC · Linden, MIBuilt 1998 · S/N 18280328N981WUEastern Kentucky University · Richmond, KYBuilt 1998 · S/N 17280555N98207Perkins Robert T · Anchorage, AKBuilt 1977 · S/N 18052832N9820HSeghieri Richard T · Santa Rosa, CABuilt 1981 · S/N 18268049N9820JBenair LLC · Bonita Springs, FLBuilt 1975 · S/N A1500629N9820TSamson Robert C · Waterford, WIBuilt 1960 · S/N 47620N98219White Jeffrey M · Carlsbad, CABuilt 1984 · S/N 17276266N9821CN5965t LLC · Lehigh Acres, FLFirst renewal noticeBuilt 1969 · S/N 18259988N9821ERegistered aircraftBuilt 1975 · S/N 18263921N9821GGrubelich Mark C · Edgewood, NMBuilt 1971 · S/N 17259721N9821HDowning Darrell W · Drakesville, IABuilt 1981 · S/N 18268050N9822ESample John A · Gonzales, TXBuilt 1976 · S/N 18263922N9822HPetsche Tim E · Meridian, IDBuilt 1981 · S/N 18268051N9822JSiskiyou Pacific Inc · Central Point, ORBuilt 1975 · S/N A1500631N9822VJohnson Mark W · Valrico, FLBuilt 1974 · S/N 17264515N9822XHultquist Daniel D · Anchorage, AKBuilt 1961 · S/N 185-0022N9823LSilverhawk Aviation Academy LLC · Caldwell, IDBuilt 1986 · S/N 17276623N9823VSundance Aviation Inc · Moriarty, NMBuilt 1966 · S/N 188-0073N9823XTop Hand Inc · Laurel, MTBuilt 1961 · S/N 185-0023N9824HClimb LLC · Kalispell, MTS/N 18268052N9824JBarksdale James Alan · Florence, ALBuilt 1980 · S/N 17273925N9824LSt Pete Aviation Services LLC · Saint Petersburg, FLBuilt 1986 · S/N 17276624N9824TNeufeld Dwayne A · Coeur D Alene, IDBuilt 1960 · S/N 47624N9824VSafety In Motion Flight Center · Puyallup, WABuilt 1974 · S/N 17264516
Back to AD 79-10-14 R1