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.

N7347SRegistered aircraftAssigned, pending cancellationS/N 18265138N73481N73481 LLC · Eaton, COBuilt 1976 · S/N 17267497N73486Begley Edward · Glasgow, KYBuilt 1976 · S/N 17267501N73487Spiess Michael Trustee · Montague, CABuilt 1976 · S/N 17267502N73489Total Flight Aircraft Leasing LLC · Apex, NCBuilt 1976 · S/N 17267503N7348GHardy James H · Albany, NYBuilt 1970 · S/N 17259048N7348MCrosby Anthony Brian · Devine, TXBuilt 1958 · S/N 55648N73496Heartland Aviation Inc · Alliance, NEBuilt 1976 · S/N 17267506N7349814a Flying Club Inc · Mooresville, NCBuilt 1976 · S/N 17267508N7349ANorwood Brian B · Conway, ARBuilt 1956 · S/N 29449N7349CMcbride Patrick J · Anchorage, AKBuilt 1977 · S/N U20603888N7349TOsipov Vladimir A · Charlotte, NCBuilt 1959 · S/N 46949N7349XYaksh Haley · Tampa, FLS/N 15059449N734ACRich Lucas Aircraft Sales LLC · Lincoln Park, NJS/N 17268694N734AEFlight Club 502 Inc · Louisville, KYBuilt 1977 · S/N 17268696N734AHAnderson Zachary Q · Rudyard, MTBuilt 1977 · S/N 17268699N734AMGlobal Flight Training Solutions Inc · Immokalee, FLBuilt 1977 · S/N 17268703N734AQBarrans Daniel L · Glenmoore, PABuilt 1977 · S/N 17268705N734ASStory Larry W · Double Oak, TXBuilt 1977 · S/N 17268707N734AULeading Edge Aviation Inc · Doylestown, PABuilt 1977 · S/N 17268709N734AXPenel Aviation Corp · Baldwin, NYBuilt 1977 · S/N 17268712N734AYRico Aviation Services Inc · Miami, FLBuilt 1977 · S/N 17268713N734BBLeading Edge Flight Academy LLC · Bend, ORBuilt 1977 · S/N 17268716N734BFMortensen Jonathan J · Grovetown, GABuilt 1977 · S/N 17268720N734BGVancina Simon J · New Lenox, ILBuilt 1977 · S/N 17268721N734BHMy Way Aviation LLC · Weston, FLBuilt 1977 · S/N 17268722N734BNAlameda Aero Club · Alameda, CABuilt 1977 · S/N 17268727N734BQTri State Aviation Inc · Wahpeton, NDS/N 17268729N734BTSorbi Aviation Inc · El Cajon, CABuilt 1977 · S/N 17268732N734BUAirplanes And Attitude LLC · Mckinney, TXBuilt 1977 · S/N 17268733N734BVTurner Richard D · Panama City, FLS/N 17268734N734BWSuperior Aviation Gateway LLC · Tampa, FLBuilt 1977 · S/N 17268735N734BXGreene Travis Charles · Acworth, GABuilt 1977 · S/N 17268736N734BZBurleson Cameron Reynolds · Oak Island, NCBuilt 1977 · S/N 17268738N734CWilliams Jimmy D · Goodwell, OKBuilt 1967 · S/N 18258134N734CCFranks Janice G · Eagleville, TNBuilt 1977 · S/N 17268741N734CFRivertown Flying Partnership · Marine On St Croix, MNBuilt 1977 · S/N 17268744N734CHC & R Aircraft Llp · Perry Hall, MDBuilt 1977 · S/N 17268746N734CJWings Over Texas Holdings LLC · Denton, TXBuilt 1977 · S/N 17268747N734CLStates Construction Company · Indianola, IABuilt 1977 · S/N 17268749N734CP5280 Flying Club LLC · Castle Pines, COBuilt 1977 · S/N 17268752N734CQGuadagnola C Thomas Trustee · El Cajon, CABuilt 1977 · S/N 17268753N734CRBaker Thomas M · Knoxville, PAS/N 17268754N734CSBondurant Christopher T · Hendersonville, TNBuilt 1977 · S/N 17268755N734CTWalsh Thomas M · Rllng Hls Est, CABuilt 1977 · S/N 17268756N734CVHager David L · Barney, NDBuilt 1977 · S/N 17268758N734CXMount Crillon LLC · Juneau, AKBuilt 1978 · S/N U20604823N734DACalifornia In Nice Inc · San Jose, CABuilt 1977 · S/N 17268763N734DCSchmitt Jeffrey · Nordman, IDBuilt 1977 · S/N 17268765N734DESchneider Paul W · Holmen, WIBuilt 1977 · S/N 17268767
Back to AD 79-10-14 R1