OpenAirDocs.org
AD 79-10-14 R1

Registered aircraft · 56,580

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.

N35278Sparks Tommy R · Palestine, ILBuilt 1975 · S/N 17702305N3527FTuorila Tony C · Anderson, SCBuilt 1966 · S/N 18257527N3527JBurth Michael A · Verona, NYBuilt 1965 · S/N 15061227N3527LAiken Clifford M Jr · Loganville, GABuilt 1965 · S/N 15062327N3527YHrobak Robert F · Winter Garden, FLBuilt 1963 · S/N 18254427N3527ZLw Aviation LLC · Lewes, DEBuilt 2001 · S/N 172S8807N35281Freebird Wings LLC · Creswell, ORBuilt 1975 · S/N 17702306N35284Flying Redbirds LLC · Wentzville, MOBuilt 1975 · S/N 17702307N35287White James E · Eminence, KYBuilt 1975 · S/N 17702308N3528CAlvarez Fernando Perez · Santan Arecibo, PRS/N 18280959N3528DBank Of Utah Trustee · Salt Lake City, UTBuilt 2001 · S/N 18280960N3528FFair Paul R · Vacaville, CABuilt 1966 · S/N 18257528N3528JRipplinger Daniel D · Sarona, WIS/N 15061228N3528LTioga Land Development LLC · Tioga, NDS/N 15062328N3528SCoyer Company Inc · Orr, MNBuilt 1963 · S/N 17250728N35291Rochon Everette · Wesley Chapel, FLS/N 18280970N352964 Point Transportation LLC · Excelsior Springs, MOS/N 17702312N3529NOken Andrew · Corvallis, ORS/N 18280981N352AKKwartler Anatol · Maynard, MABuilt 2003 · S/N 172S9456N352CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281504N352GBDavis David N · Broken Arrow, OKBuilt 1976 · S/N 177RG1075N352JRegistration Pending · Coconut Creek, FLRegistration pendingBuilt 1974 · S/N 15075742N352MEFlying Start Aero Services LLC · Reno, NVBuilt 2000 · S/N 172S8587N352SPChristiansen Aviation LLC · Wilmington, DEBuilt 2003 · S/N 172S9499N35302William Benjamin LLC · Orono, MNS/N 17256701N35308Kress Gregory A · Sharpsburg, GABuilt 1968 · S/N 17256704N3530DVande Sandt Lloyd A · Gildford, MTBuilt 1956 · S/N 27073N3530FHeames Scott D · Simi Valley, CABuilt 1967 · S/N 18258030N3530JChristiansen Aviation LLC · Wilmington, DEBuilt 2001 · S/N 17281010N3530SMakosteako Holding Corp · Massapequa, NYBuilt 1963 · S/N 17250730N3530UKalmbach Justin J · Polson, MTBuilt 1963 · S/N 18254930N3530YScollon Brian F · Hudson, COFirst renewal noticeBuilt 1962 · S/N 18254430N35313Lyon W Bruce · Carterville, ILBuilt 1968 · S/N 17256706N35315Hubert Thomas D · Greenville, TXBuilt 1968 · S/N 17256708N35318Wings LLC · Scottsdale, AZBuilt 1968 · S/N 17256709N3531CPlowman Benjamin W · Raleigh, NCBuilt 1954 · S/N 26574N3531JAudi Salim M · Farmers Branch, TXBuilt 1965 · S/N 15061231N3531LLihs Austin R · Sioux City, IAS/N 15062331N3531YPetter David · Stuttgart, ARBuilt 1962 · S/N 18254431N35322Vincent Zachary T · Saint George, UTBuilt 1968 · S/N 17256710N35323Bourdon Greg · Henniker, NHBuilt 1968 · S/N 17256711N35324Schuster Darin D · New Castle, DEBuilt 1968 · S/N 17256712N35325Fly Cessna LLC · Peoria, AZS/N 172S8819N35326Harrison Keith D · La Grange, NCBuilt 1968 · S/N 17256714N3532DUreneck Paul M · Gray, MEBuilt 1956 · S/N 27075N3532EDubois William C · El Centro, CABuilt 1978 · S/N 17271576N3532KHattell George Curtis · Olympia, WAS/N 18280974N3532LPiab Inc DBA · Fresno, CAS/N 18254932N3532TNs Aviation Training And Rental Inc · Pembroke Pines, FLS/N 172S8820N35330Wilkerson Jeffrey D · Morning Sun, IABuilt 1968 · S/N 17256715
Back to AD 79-10-14 R1