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.

N1768ERoyal Air Freight Inc · Waterford, MIBuilt 1978 · S/N 310R1566N176MMRair Air Inc · Stateline, NVBuilt 1976 · S/N 310R0710N1777HFait Coleman B · Newport Beach, CABuilt 1959 · S/N 35877N1781ECallaham John · Broken Bow, OKBuilt 1979 · S/N 310R1571N1783HRegistration Pending · Anchor Point, AKRegistration pendingBuilt 1959 · S/N 35883N1784EHigh Road Time LLC · West Palm Beach, FLBuilt 1979 · S/N 310R1574N1791ESol Aerial Surveys LLC · Las Vegas, NVBuilt 1979 · S/N 310R1576N1795ERb Aviation LLC · Tyler, TXBuilt 1979 · S/N 310R1577N1796GHorowitch Alan · San Diego, CABuilt 1975 · S/N 310R0048N1797HRons Air Service Inc · Two Buttes, COS/N 35897N17AMFarmdog Aviation LLC · Lafayette, INBuilt 1974 · S/N 414-0524N17GWSalus Aviation LLC · Jupiter, FLBuilt 1975 · S/N 310R0555N17HLRiley Charles S · Littleton, COS/N 421B-0310N17MHEcho Aviation LLC · Verona, WIS/N 340A0797N17UAce Flight LLC · Houma, LABuilt 1964 · S/N 310I0093N1811HLeggett Jason · Bogue Chitto, MSS/N 35911N1816HKiever Robert P · Summerland Key, FLBuilt 1959 · S/N 35916N1821EHth Companies Inc · Union, MOBuilt 1979 · S/N 310R1581N1827HWard Austin · Kokomo, INBuilt 1959 · S/N 35927N1831HKulp Clayton H · Wichita, KSBuilt 1959 · S/N 35931N1837HYeagley Daun III · Moraine, OHBuilt 1959 · S/N 35937N1842SFry William A · Willmar, MNBuilt 1973 · S/N 414-0433N184PSStrama Aviation LLC · Ocala, FLBuilt 1965 · S/N 310J0111N1852EMarshall Dennis Ray Jr · Pottsboro, TXS/N 310R1587N1852HI Fly Stl LLC · Saint Louis, MOBuilt 1959 · S/N 35952N1856EGv Air Inc · Medford, ORBuilt 1979 · S/N 310R1591N1856HVieman John D · Owensville, MOBuilt 1959 · S/N 35956N1862TBradley Max T II · West Plains, MOBuilt 1959 · S/N 35962N1865SPima County Board Of Supervisors · Tucson, AZS/N 310R0897N186THSandy Hook Aviation LLC · Sandy Hook, MSBuilt 1966 · S/N 310L-0029N1873HBlue Canoe Aviation LLC · Chicago, ILBuilt 1952 · S/N 35973N1879HRegan Robert C · Kent, WABuilt 1959 · S/N 35979N187WWOsprey Aviation LLC · Riva, MDBuilt 1971 · S/N 310Q0252N1886HGoodwin Joseph N · Grass Valley, CABuilt 1959 · S/N 35986N189MWWilliamson Aviation Inc · Tullahoma, TNBuilt 1968 · S/N 310N-0003N18BKShandog Air LLC · Ashland, KYS/N 310R0981N18DLBelov Mikhail · Greenwood Village, COBuilt 1977 · S/N 310R1251N18EGBoanco Inc · Lafayette, INBuilt 1973 · S/N 414-0394N18SGBennett Jeannette DBA · Joiner, ARBuilt 1975 · S/N 310R0560N18TN18t Ltd · Wilmington, DEBuilt 1968 · S/N 421-0144N18VUVincennes University · Vincennes, INBuilt 1977 · S/N 310R0928N1908GAir Z Flying Service Inc · Richmond Heights, OHBuilt 1974 · S/N 310R0055N1915WPasha Mohammad A · Muscatine, IABuilt 1971 · S/N 310Q0429N1918JCoastal Satellite Inc · Woodland Hills, CABuilt 1976 · S/N 310R0703N1919JValiair Lc Trustee · Casper, WYBuilt 1979 · S/N 310R1554N1919LSmith Sydney O · Lithonia, GAS/N 411-0157N191CTBessemer Plywood Corp · Bessemer, MIBuilt 1974 · S/N 310R0057N191RAnderson Harold E · Phoenix, AZBuilt 1955 · S/N 35229N1925GEfi Technology Inc · Cave Creek, AZBuilt 1975 · S/N 421B0826N193DC310 Charter LLC · Zanesville, OHBuilt 1980 · S/N 310R1885
Back to AD 76-08-02 R2