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.

N963TASvetfur Aviation LLC · Camden, SCBuilt 2004 · S/N 172S9610N963WMMorrison William S · Aliquippa, PABuilt 1980 · S/N R1723344N96403Skylens LLC · Hammond, LABuilt 1978 · S/N 18266708N9640BHanson Glen W · Anchorage, AKBuilt 1957 · S/N 32937N9640HCorriher Mark B · Mocksville, NCBuilt 1975 · S/N 17266287N9640QFour Zero Quebec Inc · Cheyenne, WYBuilt 1969 · S/N 18259642N9640TJohnson Joshua S · Lake Jackson, TXBuilt 1960 · S/N 57440N9640VN9640v LLC · Ann Arbor, MIS/N 17264420N96410Penny John C Jr · Sterling, COBuilt 1978 · S/N 18266709N96411Zz Top Rentals Inc · Missoula, MTBuilt 1978 · S/N 18266710N96416Wolstenholme Ralph E · Westfield, PABuilt 1978 · S/N 18266713N96418Twin City Cloud 7 Inc · Eden Prairie, MNBuilt 1978 · S/N 18266714N96419Thompson Steven · Rockwall, TXBuilt 1978 · S/N 18266715N9641AIsler Jerry L · Donalsonville, GABuilt 1949 · S/N 15362N9641BFlying Brown Dog LLC · Boulder, COBuilt 1957 · S/N 32938N9641HBarton Alva L · Hollister, CABuilt 1975 · S/N 17266288N9641QBhairavi Aviation LLC · Santa Clarita, CABuilt 1975 · S/N 17265725N9641VRink Douglas B · Woolwich, MEBuilt 1974 · S/N 17264421N9641ZWhitehead Michelle W · Centralia, WABuilt 1982 · S/N U20606592N9642TDavidow Clifford A · Portland, ORBuilt 1960 · S/N 57442N9643AMaples Jeffery · Wilmington, DES/N 15364N9643HMor Aviation N9643h LLC · Gaithersburg, MDBuilt 1975 · S/N 17266290N9643QLeading Edge Flight Academy LLC · Bend, ORBuilt 1975 · S/N 17265727N9643TDunn Meghan Elizabeth · Mckinney, TXBuilt 1960 · S/N 57443N9643VBrazos Valley Flight Services LLC · College Station, TXBuilt 1974 · S/N 17264423N9643ZAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 1982 · S/N U20606594N9644ASchindler Patrick E · West Valley City, UTBuilt 1950 · S/N 15478N9644GKatmai Air LLC · Anchorage, AKS/N U20601844N9644QSkyhawks Inc · Chippewa Falls, WIBuilt 1975 · S/N 17265728N9644TFloyd Andrew W · Mesa, AZBuilt 1960 · S/N 57444N96455Haeussler Arne · Chandler, AZBuilt 1978 · S/N 18266726N9645GConnolly Michael T · Ferndale, WABuilt 1974 · S/N 18263413N9645HSantiago Diana L · Juana Diaz, PRBuilt 1975 · S/N 17266292N9645VOak Ridge Flyers Inc · Oak Ridge, TNBuilt 1974 · S/N 17264425N9645XCall The Ball Aviation LLC · Phoenix, AZS/N 21057945N96462Skylens LLC · Hammond, LABuilt 1978 · S/N 18266728N9646BN9646b LLC · Wilmington, DEBuilt 1981 · S/N 172RG0942N9646XKomko Randy M · Mckenna, WABuilt 1962 · S/N 21057946N96474Skylane 4 LLC · Leesburg, FLBuilt 1978 · S/N 18266730N96475Gregg Flying Service Inc · Durango, COBuilt 1978 · S/N 18266731N96476After Global Holdings Corp · Wichita, KSBuilt 1978 · S/N 18266732N9647ASilver Minnow LLC · Farmington, MNBuilt 1950 · S/N 15480N9647BLakewood Investments LLC · Victorville, CAS/N 172RG0943N9647QKaeni Law Group Inc · Santa Ana, CABuilt 1975 · S/N 17265731N96480Mfkc182 LLC · Lantana, TXBuilt 1978 · S/N 18266733N9648HSaunders Larry F · Sulphur Springs, ARBuilt 1975 · S/N 17266294N9648QGreen Bay Flying Club Inc · Krakow, WIBuilt 1975 · S/N 17265732N9648VGrove Kaylene · San Diego, CABuilt 1974 · S/N 17264428N9648XWilt Michael J · Windham, NHBuilt 1962 · S/N 21057948N96490Schabacker Charles W · Jerome, IDBuilt 1978 · S/N 18266737
Back to AD 79-10-14 R1