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.

N724RTBrown Robert · Wayne, OKS/N 56160N724SPCandace A Larned Enterprises Inc · Long Beach, CABuilt 2000 · S/N 172S8658N724TMiller Neil · Plymouth, MNBuilt 1998 · S/N 18280250N724TJPellow James A · Dixie, WAS/N 17254147N724TMMorcom Aviation Services Inc DBA · Everett, WABuilt 1974 · S/N 17262971N724TXStratus Aviation LLC DBA · Vacaville, CABuilt 1974 · S/N 17263381N725Butler Harris K III · Towanda, KSBuilt 1964 · S/N 185-0737N7250NSimon Jevon · Buckley, WABuilt 1979 · S/N 21063213N7250QSale Reported · Crystal, MNSale reported, pending cancellationBuilt 1972 · S/N 17260550N7251AHoward F Bret · Albany, OHBuilt 1956 · S/N 29351N7251EFord Michael G · Doerun, GABuilt 1959 · S/N 52251N7251MSkoglun Jon E · Cashmere, WABuilt 1958 · S/N 55551N7251NThornton Chad · Seattle, WABuilt 1974 · S/N 18263042N7251QGarcia Crystal M · Brownsville, ORBuilt 1972 · S/N 17260551N7251XCampbell Jennings R Jr · Bell, FLBuilt 1961 · S/N 15059351N7252ABarbaro Aaron J · Marcellus, NYBuilt 1956 · S/N 29352N7252GLeaders Flying Service LLC · Clear Lake, MNBuilt 1970 · S/N 17258952N7252MFoxglove Melanie Ann · Captain Cook, HIS/N 55552N7252QRobbins Aviation LLC · Scottsbluff, NEBuilt 1972 · S/N 17260552N7252SDorris Joseph · Lewisburg, KYBuilt 1999 · S/N 18280562N7253GOne Mile LLC · Canton, GABuilt 1970 · S/N 17258953N7253QHarry'S Hawks · Wells, MNBuilt 1972 · S/N 17260553N7254AStiffey Jason J · Port Orchard, WAS/N 29354N7254HVevani Aircraft LLC · Miami Gardens, FLBuilt 1999 · S/N 20608036N7254MPa Prospect Corp · Columbus, MTBuilt 1958 · S/N 55554N7254NChoice Aviation LLC · Hamilton, MTBuilt 1974 · S/N 18263044N7254QRegistration Pending · Phoenix, AZRegistration pendingBuilt 1972 · S/N 17260554N7254SNickels Robert D · Fayetteville, TNBuilt 1967 · S/N 15067954N72559Welch Paul · Oldsmar, FLBuilt 1999 · S/N 18280654N7255ANunziato Anthony J · Tewksbury, MABuilt 1956 · S/N 29355N7255EValley Pilots Flying Club Inc · Martinez, CABuilt 1959 · S/N 52255N7255MLdg Aviation LLC · Carefree, AZBuilt 1958 · S/N 55555N7255QSierra Sky Aviation LLC · Kalispell, MTS/N 17260555N7256GAvstar Inc · Seattle, WABuilt 1999 · S/N 18280560N7256HChaparral Aviation LLC · Edmond, OKBuilt 1999 · S/N 18280556N7256QAustin Ferrel Stephen · West Monroe, LABuilt 1999 · S/N 18280552N7256WRoswall James B · Bristol, TNBuilt 1999 · S/N 18280507N7256YGupta Vivek · Shelton, CTBuilt 1999 · S/N 18280485N72579Allee Mark J · Gillette, WYBuilt 1967 · S/N 15067593N7257AJones William Shane · Griffin, GABuilt 1956 · S/N 29357N7257EAerospring Leasing LLC · Wasilla, AKBuilt 1999 · S/N 17280760N7257MParker Charles B · North Pole, AKBuilt 1958 · S/N 55557N7257NPeterson Winston Roy II · Arbuckle, CABuilt 1976 · S/N U20603588N7257QSmith Henry C III · Essexville, MIBuilt 1972 · S/N 17260557N7257SFidalgo Flyers LLC · Anacortes, WABuilt 1967 · S/N 15067957N7257TJet & Rotor Aviation LLC · Sacramento, CABuilt 1999 · S/N 17280787N7257XBuckelew James E · Gulf Breeze, FLBuilt 1961 · S/N 15059357N7257ZPrivate Pilot Aircraft Rentals LLC · Sanibel, FLBuilt 1999 · S/N 17280783N7258International Air Services Inc Trustee · Carson City, NVBuilt 1980 · S/N 172RG-0508N7258ANguyen Anthony V · Keyser, WVBuilt 1956 · S/N 29358
Back to AD 79-10-14 R1