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.

N9518DJaugust Vladimir · Somerville, MABuilt 1998 · S/N 18280126N9518GKomer Thomas B Jr · Woodburn, ORBuilt 1971 · S/N U20601718N9518TParks Paul E · Titusville, FLBuilt 1960 · S/N 57318N951CEaston Robert C · Lasalle, COBuilt 1963 · S/N 18051336N951CCBrouchoud Jayson R Trustee · Ridgecrest, CABuilt 1979 · S/N 18266998N951HCUsweixin · Sheridan, WYBuilt 1980 · S/N 172RG0282N951JAAerochatt LLC · Cleveland, TNBuilt 2007 · S/N 172S10496N951MCSky Mates Inc · Wilmington, DEBuilt 2001 · S/N 172S8951N951SCJuliet Charlie Aviation LLC · Scottsdale, AZBuilt 2013 · S/N 172S11252N951SPN591sp LLC A Series Of Aero Lease LLC · San Antonio, TXS/N 172S8151N951TAKb Land And Cattle Company LLC · Hood River, ORBuilt 2003 · S/N 172S9518N9520DHodge Flight Services LLC · Pittsburg, CABuilt 1998 · S/N 17280385N9520WAmeriflyers Of Texas Inc · Addison, TXBuilt 1998 · S/N 17280407N9520ZK2 Aviation LLC · Greenwood Village, COBuilt 2013 · S/N 172S11278N9521AWadsworth Harley · Albuquerque, NMBuilt 1949 · S/N 19082N9521HJordan Recreation Development LLC · Clinton, TNBuilt 1975 · S/N 17266197N9521XTailwynns LLC · Lake Placid, FLBuilt 1961 · S/N 21057821N9522ADunn Legacy Inc · Saint Petersburg, FLBuilt 1998 · S/N 17280411N9522CToornburg Van W · College Grove, TNBuilt 1969 · S/N 18260111N9522HUrbas Robert M · Rockford, ILBuilt 1975 · S/N 17266198N9522LYellow Jacket Flying Club Inc · Atlanta, GAFirst renewal noticeS/N 17276570N9522SSnohomish Flying Service Inc · Snohomish, WABuilt 1998 · S/N 17280432N9522XNorthwoods Air LLC · Orono, MEBuilt 1986 · S/N 18268544N9523HVictor James A · Kingsville, OHBuilt 1975 · S/N 17266199N95242Kane Aviation Holdings LLC · Bernardsville, NJBuilt 1998 · S/N 18280146N9524AHamel Ryan A · Klamath Falls, ORBuilt 1949 · S/N 19085N9524BMeierotto Jeff T · Two Rivers, AKBuilt 1957 · S/N 32821N9525DFlying Neutrons LLC · Lebanon, OHBuilt 1998 · S/N 18280147N9525PGeorgetown Flying Club LLC · Pawleys Island, SCBuilt 1997 · S/N 18280177N9525VFirst Eclipse Ltd · Richmond, VABuilt 1998 · S/N 17280315N9525XKuest Louis J · Anchorage, AKBuilt 1961 · S/N 21057825N95260Barr Air Patrol LLC · Mesquite, TXBuilt 1998 · S/N 18280182N9526BWildenberg Ronald · Beloit, WIBuilt 1981 · S/N 172RG0855N9526GAtlas Aviation Tampa Inc · Tampa, FLBuilt 1998 · S/N 17280434N9526HAbove The Haze LLC · San Lorenzo, CABuilt 1975 · S/N 17266201N9527MWhitetail LLC · Anchorage, AKBuilt 1981 · S/N 20700701N9527TTechnical Education Services Inc · Virginia Beach, VABuilt 1960 · S/N 57327N9528BNorris John R · Anchorage, AKBuilt 1957 · S/N 32825N9528WWings Over Texas Holdings LLC · Denton, TXBuilt 1998 · S/N 17280467N9528YHunt William R · Tucson, AZBuilt 1981 · S/N 21064538N9529TGarcia Richard E · Atwater, CABuilt 1960 · S/N 57329N9529WFlight Operations Aircraft LLC · Wilmington, DEBuilt 1998 · S/N 17280470N952ASA2g International LLC · San Juan Capo, CABuilt 1978 · S/N 33701835N952CBCentral Business Jets Inc · Burnsville, MNBuilt 1979 · S/N 21063729N952CCNewell Charles W · Naperville, ILBuilt 1975 · S/N 18263638N952JAHuerta Holdings Inc · Santa Ana, CABuilt 2007 · S/N 172S10474N952RFArk Aviation LLC · Ladson, SCS/N 18259034N952SCMike Charlie Aviation LLC · Scottsdale, AZBuilt 2014 · S/N 172S11406N9530BSierra Alpha Aeronautical LLC · San Antonio, TXBuilt 1981 · S/N 172RG0858N9530HHorizon Aircraft Sales & Leasing Inc · Chesapeake, VABuilt 2013 · S/N 172S11295
Back to AD 79-10-14 R1