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.

N7200EAircraft Structural Repair Inc · Hamilton, MTBuilt 1959 · S/N 52200N7200GWe Fly High LLC · Helena, MTBuilt 1969 · S/N 17258900N7200QFisher Eric C · San Francisco, CABuilt 1972 · S/N 17260500N7200RDelk George H Jr · Roseland, VAFirst renewal noticeBuilt 1968 · S/N 337M0320N7200TYavitch Barry E · Palmdale, CABuilt 1959 · S/N 46800N7200XGloris Robert J · Lago Vista, TXBuilt 1961 · S/N 15059300N7201ACarleson Jesse R · Wasilla, AKFirst renewal noticeBuilt 1956 · S/N 29301N7201THorton Rusty Ray · Monroe, GABuilt 1959 · S/N 46801N72027Candy Corn LLC · Missoula, MTBuilt 1968 · S/N U206-1259N7202EAlbertson James M · Westville, FLBuilt 1959 · S/N 52202N7202GUrmston Benjamin R · Sherborn, MABuilt 1969 · S/N 17258902N7202TArcangeli Harry L · Lakemont, NYBuilt 1959 · S/N 46802N7202XFielding John N · Scarborough, MEBuilt 1961 · S/N 15059302N72035Christiano Brett T · Pasco, WABuilt 1967 · S/N 17700240N7203AJohnson Lawrence F · Anchorage, AKBuilt 1956 · S/N 29303N7203GVenard Inc · Murdo, SDS/N 17258903N7203TRegistration Pending · Amarillo, TXRegistration pending, pending cancellationBuilt 1959 · S/N 46803N7204GGibson James E · Tenino, WABuilt 1969 · S/N 17258904N7204QTexas Air Rangers LLC · Mckinney, TXBuilt 1972 · S/N 17260504N7204SAerolab LLC · Hartwell, GAS/N 15067904N7204TGaponoff Mark A · Mercer Island, WAFirst renewal noticeBuilt 1960 · S/N 46804N72050Petty Line Const Co Inc · Clanton, ALBuilt 1969 · S/N U206-1266N7205GJones Keith · Tucson, AZBuilt 1969 · S/N 17258905N7205NMontgomery Gary Mark · Mineral Wells, TXBuilt 1974 · S/N 18262997N7205QN7205q LLC · Titusville, FLBuilt 1972 · S/N 17260505N7205SRegistration Pending · Dillingham, AKRegistration pendingBuilt 1967 · S/N 15067905N7206ABerle William M · White Hills, AZS/N 29306N7206GKane Gabriel · Yucaipa, CABuilt 1973 · S/N 15074622N7206QN7206q LLC · Myrtle Beach, SCBuilt 1972 · S/N 17260506N7206TSimmons William E · Port Orchard, WABuilt 1959 · S/N 46806N7206XChickasha Wings Inc · Chickasha, OKS/N 15059306N7207BThomas Conners · Melbourne Beach, FLBuilt 1999 · S/N 18280558N7207GCowden Flying Services Inc · Fort Worth, TXBuilt 1969 · S/N 17258907N7207NRuper Chad A · Horseheads, NYBuilt 1974 · S/N 18262999N7207QMountain Peaks Aviation LLC · Clancy, MTBuilt 1972 · S/N 17260507N7207SRademacher Kenneth J · Cleveland, TXBuilt 1967 · S/N 15067907N7207TMrzena Matthew D · Wasilla, AKBuilt 1959 · S/N 46807N7207XAbetz Jacob R · Tacoma, WABuilt 1961 · S/N 15059307N7208ECrockett Donald R · Artesia, NMBuilt 1959 · S/N 52208N7208GBurgess Keith · Arnoldsville, GABuilt 1969 · S/N 17258908N7208XReese Scott D · New London, MNBuilt 1961 · S/N 15059308N72091Peralta Jose Ramon · Sinking Spring, PAFirst renewal noticeBuilt 1974 · S/N 18801943TN72094Gibertoni James E · Fairbanks, AKBuilt 1969 · S/N U206-1281N7209GElite Planes LLC · Menifee, CABuilt 1969 · S/N 17258909N7209MColman Aviation LLC · Pocatello, IDBuilt 1958 · S/N 55509N7209QKimble Leon · Rocky Hill, CTBuilt 1972 · S/N 17260509N7209TBouchez Lawrence T · Manhattan Beach, CABuilt 1959 · S/N 46809N7209XSims Hollow M · Lithonia, GABuilt 1961 · S/N 15059309N720CAAero Equities LLC · Oxnard, CABuilt 2026 · S/N 172S13528N720CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 172S11564
Back to AD 79-10-14 R1