OpenAirDocs.org
AD 76-08-02 R2

Registered aircraft · 2,552

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:76-08-02-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:76-08-02-R2')
  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.

N340PRFly Yawa Aviation LLC · Statesboro, GABuilt 1976 · S/N 340A0123N340PTMach Air LLC · Townsend, GABuilt 1972 · S/N 340-0014N340RDDeaton Courtney · London, KYS/N 340-0019N340RGSteggs Garret E · Edmond, OKBuilt 1973 · S/N 340-0239N340RHMy Toy Box Inc · Debary, FLBuilt 1972 · S/N 340-0086N340RRCustom Data Engineering Inc · Phoenix, AZS/N 340-0107N340VVYouth Aviation Academy · Roseville, CABuilt 1972 · S/N 340-0087N340WPraetorian Aviation Services LLC · Alva, FLBuilt 1973 · S/N 340-0317N340WAFoshay Laird · Paso Robles, CABuilt 1972 · S/N 340-0035N340WDKnoxville Air Charter Service LLC · Strawberry Plains, TNBuilt 1974 · S/N 340-0509N340WGBartlein & Co Inc · Santa Barbara, CABuilt 1972 · S/N 340-0182N340WHN340dg LLC · Spanish Fork, UTBuilt 1974 · S/N 340-0366N340WPNnk Holdings LLC · San Antonio, TXBuilt 1981 · S/N 340A1240N3412QPoulsen Melvin J · Orem, UTS/N 320E0012N3417GDemark Aviation Inc · Wilmington, DEBuilt 1976 · S/N 310R0825N3417QGholami Amir H · Santa Rosa, CABuilt 1966 · S/N 320E0017N3418GOppermann William A · Derby, KSBuilt 1976 · S/N 310R0826N341BCAbeflies LLC · Montvale, NJBuilt 1972 · S/N 340-0015N341BGAttack Jack Enterprises LLC · Wilmington, DEBuilt 1973 · S/N 340-0233N3437QJamerson Kendall L · Bovina, TXBuilt 1966 · S/N 320E0037N3444QKeystone Aerial Surveys Inc · Philadelphia, PABuilt 1966 · S/N 320E0044N344AHAdams Flying Service Inc · Rayville, LABuilt 1978 · S/N 310R1371N344JPCentral Virginia Aviation Inc · North Dinwiddie, VAS/N 35713N3452QGolden Arrow Transportation Co · Plainfield, NJBuilt 1966 · S/N 320E-0052N3456QL & J Aviation Inc · Atwater, CABuilt 1971 · S/N 340-0004N3457BChase Dennis A · Naperville, ILBuilt 1955 · S/N 35032N3458GAmerican Aircraft Sales LLC · Livermore, CABuilt 1976 · S/N 310R0842N3458QIngram John · Los Angeles, CABuilt 1966 · S/N 320E-0058N3463GBuckles Robert F · Boseman, MTBuilt 1976 · S/N 310R0843N3465GGv Air Inc · Medford, ORS/N 310R0844N3471GPage Garrett A · Rhodes, MIBuilt 1976 · S/N 310R0845N3472GLosko Patrick J · Tustin, CABuilt 1976 · S/N 310R0846N3473GThayer John P · Columbus, GABuilt 1976 · S/N 310R0847N3474QLyle Timothy · Lakewood Ranch, FLBuilt 1966 · S/N 320E-0074N3478QCsc Aviation LLC · Parker, COS/N 320E-0078N3489QPlane Progress LLC · Waterloo, IABuilt 1967 · S/N 320E-0089N3491QOuter Marker Inc · Sandy, UTS/N 320E-0091N3492QLadet William D · Las Vegas, NVS/N 320E-0092N3494QRodcon Aircraft Sales LLC · Kalispell, MTBuilt 1967 · S/N 320E-0094N3495QBoswell Alan · Chrisney, INBuilt 1967 · S/N 320E-0095N34MMSchubee Air Inc · Watkins, COBuilt 1967 · S/N 401-0125N34NYKeys Robert · Menifee, CABuilt 1973 · S/N 340-0196N34WEWildes Thomas O · Chippewa Falls, WIBuilt 1979 · S/N 310R1597N34WWChute Aviation LLC · Prescott, AZBuilt 1973 · S/N 340-0258N350CHFly Bye LLC · Georgetown, DEBuilt 1973 · S/N 310Q0910N350JCWear On Earth Aviation LLC · Potsdam, NYBuilt 1975 · S/N 310R0606N350SDAmerican Aircraft Sales LLC · Lincolnshire, ILExpired dealer, pending cancellationBuilt 1970 · S/N 310Q0065N3517GGv Air Inc · Medford, ORS/N 310R0860N3522GJ.A. White & Son Aviation LLC · Powder Springs, GAS/N 310R0862N352LBurdick Rich · Montrose, COBuilt 1958 · S/N 35769
Back to AD 76-08-02 R2