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.

N61804Skyhawk Virginia LLC · Chester, VABuilt 1975 · S/N 17264813N61808Cape Island Aviation LLC · Millville, NJBuilt 2008 · S/N 172S10709N6180BNewton Raymond C Jr · Heath, TXBuilt 1978 · S/N 21062699N6180EUtica Township Vol Firefighter Assn Inc · Jeffersonville, INBuilt 1958 · S/N 46280N6180KHutton Stephen · Madison, MSBuilt 1975 · S/N 15077573N6180NMargiotta Russell A Trustee · Woodside, CABuilt 1978 · S/N 21062951N6180TInternational Air Services Inc Trustee · Carson City, NVS/N 172S12389N6180WChristiansen Aviation LLC · Wilmington, DEBuilt 2008 · S/N 172S10706N6180XLewis University · Romeoville, ILBuilt 2008 · S/N 172S10707N61811Schok Jr Richard N · Fairbanks, AKBuilt 1981 · S/N 18504259N61812Craft Robert L · Cynthiana, KYBuilt 1975 · S/N 17264818N61813Nationwide Aviation LLC · Hudson Oak, TXBuilt 1975 · S/N 17264819N61814On Glideslope LLC · Middletown, DEBuilt 1975 · S/N 17264820N61817Rb Aviation LLC · Vassar, MIBuilt 1975 · S/N 17264821N6181FTarchinski James E · Rochester Hills, MIBuilt 1979 · S/N 17273161N6181RTrahan Gregory M · Rayne, LABuilt 1979 · S/N 172RG0106N6181ZDittrich James G · Anchorage, AKBuilt 1981 · S/N U20606178N6182Olson Gary P · Lanesboro, MNBuilt 1965 · S/N 18256342N61822Wings Over Texas Holdings LLC · Denton, TXBuilt 1975 · S/N 17264822N61825Prestage Michael J · Hondo, TXBuilt 1975 · S/N 17264824N6182BPipkin Chester L · Boise, IDBuilt 1957 · S/N 34182N6182FAllsouth Aviation LLC · Buford, GABuilt 2008 · S/N 18282079N6182TLuxaire Center Inc · Deland, FLS/N 15060882N6182UEfi Aviation LLC · Wilmington, DEBuilt 2008 · S/N 18282080N61832Prop Wash Aero Inc · Senoia, GABuilt 1975 · S/N 17264828N61834Offerman Leo · Emily, MNBuilt 1975 · S/N 17264829N61835Epic Aviation Leasing LLC · Puyallup, WAS/N 17264830N61837Park Richard J · Devol, OKBuilt 1975 · S/N 17264831N61839Fixen Jimmie Trustee · Lynd, MNBuilt 1975 · S/N 17264833N6183ECivil Air Patrol Inc · Maxwell Afb, ALBuilt 1983 · S/N 18268351N6183NLewis A Everett Jr · Chico, CAFirst renewal noticeBuilt 1978 · S/N 21062954N6183SFarm Air LLC · Gridley, CABuilt 2004 · S/N 18281389N61840Jimenez Cruz Juan C · Mayaguez, PRS/N 17264834N61841Burggraf Sean Hj · Grand Rapids, MNS/N 17264835N61842Skywalker Flight Schoool LLC · Adrian, MIBuilt 1975 · S/N 17264836N61846Wood James P · Greenbank, WAS/N 17264838N6184CRegistered aircraftBuilt 1979 · S/N 21063824N6184ERosborough Todd D · Medford, ORBuilt 1958 · S/N 46284N6184TBormann Wayne T · Valley Center, KSBuilt 1964 · S/N 15060884N61851C-180 Kbn LLC · East Lyme, CTBuilt 1977 · S/N 18052804N61852Knight-Graham Michael L Trustee · Truckee, CABuilt 1975 · S/N 17264844N61854Timm Robert S · Minneapolis, MNBuilt 1977 · S/N 18052805N61856Paraclete Sky Adventures LLC · Raeford, NCBuilt 1975 · S/N 17264847N61859Jprg Aviation Inc · Orlando, FLBuilt 1975 · S/N 17264849N6185BGust William J DBA · Monument, COBuilt 1978 · S/N 21062701N6185FLyford Charles A IV · Bellevue, WABuilt 1977 · S/N 18265984N6185GJuel Thomas Gavin · Everett, WAS/N 15071685N6185KLa Porta John R · Des Moines, WABuilt 1975 · S/N 15077576N6185RSkywalker Ranch LLC · Dover, DEBuilt 1979 · S/N 172RG0108N6185TRobinson David B · Fair Oaks, CABuilt 1964 · S/N 15060885
Back to AD 79-10-14 R1