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.

N7188GVrechek Joseph D · Fort Lauderdale, FLS/N 17258888N7188MFilter Keith Jr · Lake Havasu City, AZS/N 55488N7188QToles Chad · Austin, TXFirst renewal noticeBuilt 1972 · S/N 17260488N7188XSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1961 · S/N 15059288N71890Rich Lucas Aircraft Sales LLC · Lincoln Park, NJBuilt 1969 · S/N 18259794N71896Silver Eagles Flying Club Inc · Armonk, NYBuilt 1969 · S/N 18259795N7189APierson Janice R Trustee · Scio, ORBuilt 1956 · S/N 29289N7189FTello Ricardo · Mission, TXBuilt 1966 · S/N 15063789N7189GSky Hawk Flying Club · Grand Rapids, MNBuilt 1969 · S/N 17258889N7189QMontgomery Paul · Fredericksburg, VABuilt 1972 · S/N 17260489N7189XZephyr Air Corp · Dellwood, MNBuilt 1961 · S/N 15059289N718APAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1977 · S/N 21061857N718CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281713N718DFTurning Point @ Sonrise Inc · Hartsville, TNBuilt 1964 · S/N 17251190N718EHChristiansen Aviation LLC · Wilmington, DEBuilt 1997 · S/N 17280061N718EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2023 · S/N 172S13022N718JSBrewster Scott · Sedona, AZS/N 18265417N718LULiberty University Inc · Lynchburg, VABuilt 2022 · S/N 172S12778N718RWWestern Skymasters LLC · Salt Lake City, UTS/N P3370211N71900Savage David E · American Falls, IDBuilt 1968 · S/N U206-1217N71908Mielke Martin W · Valley City, OHBuilt 1973 · S/N 33701500N7190EBrown Hector M · Glenwood Springs, COS/N 52190N7190GM T Machinery Inc · Porter, TXBuilt 1969 · S/N 17258890N7190MDiener John M · Stephenville, TXBuilt 1958 · S/N 55490N7191GHis Grace LLC · San Angelo, TXBuilt 1973 · S/N 15074621N7191SBuchanan Kenneth W · Yucca Valley, CABuilt 1976 · S/N 18265079N7191TLawson Isaiah · Roswell, NMBuilt 1959 · S/N 46791N7191XMiller William D · Blacksburg, VABuilt 1961 · S/N 15059291N71924Keystone Aerial Surveys Inc · Philadelphia, PABuilt 1968 · S/N U206-1226N7192EBailey Jackson Thomas · Willow Springs, MOS/N 52192N7192QMansfield Heliflight Inc · Milton, VTBuilt 1972 · S/N 17260492N7193EErickson Kirk E · Lake Havasu City, AZBuilt 1959 · S/N 52193N7193TJones Wade T · Wichita, KSBuilt 1959 · S/N 46793N7193XRound Engine Aero · Nashville, MIS/N 15059293N7194Ajayi Samuel O · Fredericksburg, VAS/N 15063922N7194AGuillermo A Pliego M · Corpus Christi, TXS/N 29294N7194GAvco Patrol LLC · Lyndon, KSBuilt 1969 · S/N 17258894N7194QOzarks Auto Show Inc · Hollister, MOBuilt 1973 · S/N 17260494N7194THall William A · Puyallup, WAS/N 46794N7195FAustin Richard K · Ludington, MIBuilt 1966 · S/N 15063795N7195GBurnside George C II · Hattiesburg, MSBuilt 1969 · S/N 17258895N7195MFussy Bernie P · Bowlus, MNBuilt 1958 · S/N 55495N7195QPuget Sound Flyers · Everett, WABuilt 1972 · S/N 17260495N7195ST-Square Flights LLC · Tallahassee, FLBuilt 1976 · S/N 18265080N71967Lipan Creek Flying Service LLC · Eola, TXBuilt 1969 · S/N U206-1241N7196AL-Bird LLC · Hood River, ORBuilt 1956 · S/N 29296N7196EMile High Aviation LLC · Pahrump, NVBuilt 1959 · S/N 52196N7196FStarr Benjamin M · Somerset, OHBuilt 1966 · S/N 15063796N7196QBurdis W J · Beaver Falls, PABuilt 1972 · S/N 17260496N7196SSale Reported · Taylorsville, MSSale reportedS/N 15067896
Back to AD 79-10-14 R1