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.

N86894Williamson K R · Bellefonte, PAS/N 68-6894N8689BTeynor Jason J · Ontario, WIBuilt 1957 · S/N 36389N868LBPatriot Leasing LLC · Abilene, TXBuilt 1969 · S/N 18259911N868MTBas Part Sales LLC · Greeley, COBuilt 1973 · S/N 33701561N868SAS O W Aviation LLC · Crystal River, FLS/N 17266439N868SPWestbank Fishing LLC · Kiln, MSBuilt 1999 · S/N 172S8128N868TBSo Cal Leasing LLC · El Cajon, CABuilt 2003 · S/N 172S9311N868TCDlg Enterprises LLC · Iota, LABuilt 2002 · S/N 18281168N8690SSandy River Flying Club · Phillips, MEBuilt 1965 · S/N 15061990N8690TFlanagan Enterprises (Nevada) Inc · Zephyr Cove, NVBuilt 1960 · S/N 52590N8691BHeller Teena · Granbury, TXBuilt 1957 · S/N 36391N8691GWings Over Texas Holdings LLC · Denton, TXBuilt 1966 · S/N 15062791N8691SBonner John A III · Ocala, FLBuilt 1965 · S/N 15061991N8692BCogan Walter J Jr · Shelter Island, NYBuilt 1957 · S/N 36392N8692SRobinson Deon D · Mesquite, TXBuilt 1965 · S/N 15061992N8693TEgmond Aircraft LLC · Lewes, DEBuilt 1960 · S/N 52593N8693UCone Randall D · Salida, COBuilt 1965 · S/N 17252597N8694BMiller Jason M · Eaton, OHBuilt 1957 · S/N 36394N8695JN8695j LLC · Buckeye, AZS/N 15066595N8695TAtarah LLC · Tucson, AZBuilt 1960 · S/N 52595N8696SBartel Duane M · Ocean Shores, WAS/N 15061996N8697BHillis Gary D · Brookland, ARBuilt 1957 · S/N 36397N8697GAeronautical Technical Service Inc · Collierville, TNS/N 15062797N8697XAmboni Sinesio Jr · Wasilla, AKBuilt 1962 · S/N 18051097N8698GPriddle Kody W · Norfolk, VABuilt 1966 · S/N 15062798N8698JWaddey Caleb M · Cottage Grove, TNBuilt 1967 · S/N 15066598N8698TTimwatco LLC · Orland, CABuilt 1960 · S/N 52598N8699GFayette Aviation Inc · Lemont Furnace, PABuilt 1966 · S/N 15062799N8699TSims William L · Hobart, OKBuilt 1960 · S/N 52599N8699XFronius Douglas L · Poway, CABuilt 1962 · S/N 18051099N8699ZEdaero LLC · Bangor, MEBuilt 1968 · S/N P206-0499N869CPExecutive Flight Institute LLC · Murrieta, CABuilt 1999 · S/N 17280641N869EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2021 · S/N 172S12679N869FGMustang Sally Aviation LLC · Camden, SCBuilt 2006 · S/N 172S10346N869JRRiver City Flying Club · Glen Allen, VABuilt 1968 · S/N 18259441N86AGGarlow Terry J · Granbury, TXBuilt 1975 · S/N 21060966N86AQTwo Js Aviation LLC · Moses Lake, WAS/N 18261787N86BJWings Over Texas Holdings LLC · Denton, TXBuilt 1997 · S/N 17280238N86CMoskwa William F Trustee · Durant, OKBuilt 1973 · S/N P3370117N86DBMchugh John J · Camano Island, WABuilt 1970 · S/N 17259123N86DDJasair LLC · Scottsdale, AZBuilt 1980 · S/N 18267647N86DHHolloway'S Tire And Auto Service Inc · Thomaston, GABuilt 1984 · S/N 21064832N86DTEby Cattle LLC · Tonto Basin, AZBuilt 1977 · S/N 18265632N86EBBannen Edward · Westerville, OHBuilt 1975 · S/N 18263675N86ERInnovative Aerial Solutions LLC · Saint Johns, FLBuilt 1983 · S/N 17276027N86FPGateway Flight Center LLC · Port Lavaca, TXBuilt 1978 · S/N 17271406N86HJEarly Bird Aviation Inc · Chicago, ILBuilt 1961 · S/N 18051035N86MRThompson Charles E II · Elizabeth City, NCBuilt 1979 · S/N 18267299N86PRAdams Bob L · Chugiak, AKBuilt 1977 · S/N 18503281N86RPPetree Aviation LLC · Shreveport, LABuilt 1999 · S/N 18280651
Back to AD 79-10-14 R1