OpenAirDocs.org
AD 76-08-02 R2

Registered aircraft · 2,553

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.

N85BGIsley Aviation Inc · Fort Myers, FLBuilt 1974 · S/N 310Q1068N85MJZundel Dana John · Watkins, COS/N 35772N85SRMccorkle Air LLC · Wilmington, DEBuilt 1974 · S/N 310Q0903N860RCCornell Christopher M · Corpus Christi, TXS/N 421B0035N863CPNet Quest Management Services LLC · Winter Haven, FLBuilt 1968 · S/N 421-0117N8670GRegistration Pending · Williams, AZRegistration pendingBuilt 1977 · S/N 310R0949N86HHigh Country Aviation LLC · Helena, MTBuilt 1960 · S/N 39087N86VSPlotkin Aviation LLC · Boca Raton, FLS/N 414-0955N871Registration Pending · Las Vegas, NVRegistration pendingBuilt 1958 · S/N 35700N87199Moss Herman D · Centreville, VABuilt 1975 · S/N 310R0298N87205Redskin Aviation LLC · Kalispell, MTS/N 310R0301N87208Heredia Rafael · Miami, FLBuilt 1975 · S/N 310R0302N87221Chester Darren Dw · Sioux Falls, SDS/N 310R0306N8727387273 LLC · Reno, NVBuilt 1975 · S/N 310R0330N87290Traverse City Helicopters LLC · Traverse City, MIS/N 310R0503N87293Dinaland Aviation · Vernal, UTS/N 310R0505N87316Wilson David L · Huntington, NYBuilt 1975 · S/N 310R0512N87332Odell Ronald W · Peachtree City, GABuilt 1976 · S/N 310R0516N87341N87341 LLC · Milford, MIBuilt 1975 · S/N 310R0520N87356Kovacs Endre · Plant City, FLBuilt 1975 · S/N 310R0527N87357Qualitair LLC Trustee · MichelstadtBuilt 1975 · S/N 310R0528N87358Braswell Eugene E III · Louisburg, NCBuilt 1975 · S/N 310R0529N87363Janeair LLC · Acworth, GABuilt 1975 · S/N 310R0530N87389Missouri River Holdings LLC · Fairview, MTS/N 310R0541N87393310 Amigos LLC · Stuart, FLS/N 310R0542N87397Smith Aviation LLC · Springer, OKBuilt 1975 · S/N 310R0545N87403Twin Oaks Aviation LLC · Oshkosh, WIBuilt 1975 · S/N 310R0547N87412Rmb Leasing Inc · Dover, DEBuilt 1975 · S/N 310R0552N87429Leite Glen · King George, VABuilt 1975 · S/N 310R0557N87443Keystone Aerial Surveys Inc · Philadelphia, PABuilt 1976 · S/N 310R0562N87454Burton Donald O · Mooresville, NCBuilt 1975 · S/N 310R0568N87461Cya Aviation LLC · Gainesville, FLBuilt 1975 · S/N 310R0573N87464Wells Legacy Consultants LLC · Hickory Creek, TXBuilt 1975 · S/N 310R0576N87481Petersen Donald W · Bullhead City, AZBuilt 1976 · S/N 310R0587N87490Starkey Tommy · Pocatello, IDS/N 310R0591N877SCGv Air Inc · Medford, ORS/N 310R0940N878SPC-140 Co LLC · Milton, FLBuilt 1974 · S/N 421B0634N87CGPro Aire Cargo & Consulting Co Inc · Oshkosh, WIBuilt 1975 · S/N 402B0883N87MKWind River Aviation LLC · Lawton, OKBuilt 1974 · S/N 421B0808N87RJNorris Aviation LLC · Mansfield, TXBuilt 1976 · S/N 310R0676N880AMj Aviation LLC · Denham Springs, LABuilt 1973 · S/N 414-0397N881PJJohnson Patrick Allen · Olive Branch, MSBuilt 1973 · S/N 310Q0754N881RMMadden Robert B · Eagleville, PABuilt 1966 · S/N 310K0114N881TJBarron Eddie T · Amarillo, TXBuilt 1972 · S/N 414-0259N882BCTechnology Aviation Services LLC · Covington, GABuilt 1973 · S/N 414-0470N882GLProctor Brian S · Leesburg, TXBuilt 1963 · S/N 320B0026N888EDGolden Eagle Express LLC · Dodge City, KSFirst renewal noticeBuilt 1973 · S/N 421B-0421N888GPPt Air LLC · Madison, WIBuilt 1977 · S/N 310R1245N888HCGolden Eagle 888hc LLC · Durham, CABuilt 1975 · S/N 421B0821N888KPRunway 321 LLC · Hilton Head Island, SCBuilt 1977 · S/N 310R0918
Back to AD 76-08-02 R2