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.

N720FHParadigm Aviation LLC · Anchorage, AKBuilt 1982 · S/N 18504375N720GEHoucke Pascal · Newtown, PABuilt 1975 · S/N 21060671N720LULiberty University Inc · Lynchburg, VABuilt 2023 · S/N 172S13075N720RKLong Philip Charles · Ojai, CAS/N 18280055N720SBWhalen John F Jr · West Ossipee, NHS/N 337-0407N720WTBlain Monte W · Joliet, MTBuilt 1962 · S/N 18254350N721Department Of The Interior · Boise, IDBuilt 1981 · S/N U20606256N72106Dahl George Robert · Bethel, AKBuilt 1969 · S/N U206-1282N7210GOgle Howard J · Moorpark, CAS/N 17258910N7210MHensman Bruce E · Steamboat Springs, COBuilt 1958 · S/N 55510N7210NHansen Arthur R · Cheyenne, WYS/N 18263002N7210QAthol Orange Aero Club Inc · Athol, MABuilt 1972 · S/N 17260510N7210SAccelerated Aviation Instruction LLC · Owatonna, MNS/N 15067910N7210XStacey William B · Lebanon, TNBuilt 1961 · S/N 15059310N72113N72113 LLC · Harrah, OKS/N 33701521N72117Ott Steve G · Reedpoint, MTBuilt 1969 · S/N U206-1286N7211ATravis Michael B · Camano Island, WABuilt 1956 · S/N 29311N7211MGasvoda Richard S · Fairfield, MTBuilt 1958 · S/N 55511N7211NGallacci Jefry S · Mattawa, WAS/N 18263003N7211THargrove Nicholas A · Lago Vista, TXBuilt 1959 · S/N 46811N7211XJenkins Joe C · Wyoming, DEBuilt 1961 · S/N 15059311N7212ABlane Steven C · Rockville, INBuilt 1956 · S/N 29312N7212GMeister James A · Star Prairie, WIBuilt 1969 · S/N 17258912N7212MWarhus Donn M · Palmer, AKBuilt 1958 · S/N 55512N7212QLink Air Service LLC · Minong, WIBuilt 1972 · S/N 17260512N7212XBurgess Sheldon · Raymond, MSBuilt 1961 · S/N 15059312N7213NSouth Aero LLC · Albuquerque, NMBuilt 1979 · S/N 21063207N7213QChain O Lakes Flying Club & Co Inc · Waupaca, WIBuilt 1972 · S/N 17260513N7214MOldenkamp Timothy J · Palmer, AKS/N 55514N7214NThompson Jared N · Hayden, IDS/N 18263005N7214TKennedy John M · San Leandro, CABuilt 1960 · S/N 46814N7215EPatton James Jay · Sequim, WAS/N 52215N7215QRhynette Airways LLC · Key Largo, FLBuilt 1972 · S/N 17260515N7215SHitt Bruce A · North Augusta, SCBuilt 1967 · S/N 15067915N7215TSmith Jon O · Leavenworth, WAFirst renewal noticeBuilt 1959 · S/N 46815N7215XJackson Garrett J · Woodland, WABuilt 1961 · S/N 15059315N72160Mccauley Thomas I · Puyallup, WAS/N U206-1303N7216EZeus Air Inc · Wilmington, DES/N 52216N7216GLincoln Skyways Inc · Lincoln, CABuilt 1969 · S/N 17258916N7216MStanton Andrew J · Platte City, MOBuilt 1958 · S/N 55516N7216QElias Close Deanna · Kenilworth, ILBuilt 1972 · S/N 17260516N7216TRk Air LLC · Wilmington, DEBuilt 1959 · S/N 46816N7216XAmann David P · Wesley Chapel, FLBuilt 1961 · S/N 15059316N7217AMcguires Flying Service LLC · Obion, TNBuilt 1956 · S/N 29317N7217ERomo Daryl · Anchorage, AKBuilt 1959 · S/N 52217N7217GOne Niner Right LLC · Berkeley, CABuilt 1969 · S/N 17258917N7217QRegistration Pending · Fond Du Lac, WIRegistration pendingS/N 17260517N7217TDenney David W · Fowler, COS/N 46817N7217XGorman Byron E · Knife River, MNBuilt 1961 · S/N 15059317N7218AGurdak Paul J · Bristol, VTBuilt 1956 · S/N 29318
Back to AD 79-10-14 R1