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.

N61RWAerial Services Inc · Cedar Falls, IABuilt 1966 · S/N 320E0001N61WWKingsboro David · Menifee, CABuilt 1973 · S/N 340-0203N6209XMiller Aviation LLC DBA · Huntington, INBuilt 1978 · S/N 310R1339N620CAFar West Leaseco LLC · Kalispell, MTS/N 414-0916N620JPPreiss Aviation Inc · Poplar Grove, ILBuilt 1972 · S/N 310Q0639N621SPKokkas Athanasios · Ocala, FLBuilt 1974 · S/N 310R0075N622LPClear Skies Avionics Inc · Clearwater, FLS/N 310L-0131N622QTSol Aerial Surveys LLC · Las Vegas, NVS/N 310R0828N6249QKnudsen Russell G · East Troy, WIBuilt 1969 · S/N 401A0049N624CAClarke Cecil Jr Trustee · Katy, TXBuilt 1975 · S/N 402B0876N624PKBas Part Sales LLC · Greeley, COBuilt 1971 · S/N 421B0144N6255QValiair Limited Company Trustee · Casper, WYBuilt 1969 · S/N 401A0055N6268QChuss Edward J · Metamora, MIS/N 310Q0526N6272TBernaiche Travis · Caribou, MEBuilt 1969 · S/N 421A0141N6277QFly Me LLC · Sparta, TNBuilt 1973 · S/N 310Q0747N6283QOn Glidepath Properties LLC · Gilbert, AZBuilt 1972 · S/N 310Q0492N628BWWings Like Eagles LLC · Wilmington, DES/N 310R0682N628RJJanak Jeffrey · Corpus Christi, TXBuilt 1974 · S/N 421B-0503N628RKNicholas Adam J · Loomis, CAS/N 340A0946N62DWSagamore Sky LLC · Jericho, NYS/N 4210188N631FHayes Terry E · Rockport, TXBuilt 1963 · S/N 39169N635RRobertello Gerald W · Centreville, VABuilt 1955 · S/N 35092N636BTWestwind Digital Corp · Mahwah, NJBuilt 1972 · S/N 340-0168N6375XMiliano Air LLC · Lewes, DEBuilt 1978 · S/N 402B1338N6384XPro Aire Cargo & Consulting Inc · Oshkosh, WIBuilt 1978 · S/N 402B1347N6387XAir Exec Inc · Mount Pleasant, IABuilt 1978 · S/N 402B1350N6396XAviation Tech Services LLC · Edgewater, FLBuilt 1978 · S/N 402B1355N639FTotal Generator Service Inc · Strafford, MOBuilt 1956 · S/N 35400N639SCSale Reported · Glen Allen, VASale reportedBuilt 1969 · S/N 421A0102N63CXAerodata LLC · Wilmington, DES/N 4140388N63DETri-Air LLC · Cedartown, GABuilt 1972 · S/N 310Q0675N63ENEcho November Inc Trustee · Wilmington, DES/N 340-0063N63GTBrown Jamie Alan · Oak Island, NCS/N 35802N64310Aldrich Curtiss R · Big Oak Flat, CABuilt 1964 · S/N 310I0134N645WCWest Louis G · Amity, ORBuilt 1975 · S/N 414-0645N647TWWeigle Gerald V Jr Trustee · Cincinnati, OHBuilt 1973 · S/N 310Q0815N650RHill Tool LLC · Missoula, MTBuilt 1956 · S/N 35299N651RMackey Aviation LLC · Talking Rock, GABuilt 1960 · S/N 39261N652KWHauser Zachary D · Camp Verde, AZBuilt 1969 · S/N 310P0077N654DEDill Brice R · Glendale, AZBuilt 1978 · S/N 310R1428N6554XFly Like A Boss Aviation LLC · Minden, NVBuilt 1967 · S/N 310L0179N655RScott Timothy L · Princeton, KSS/N 35066N65AEMorris Charles J · Rutherford, TNBuilt 1975 · S/N 421B0953N65CPSparrowhawk Aviation LLC · Sugar Creek, MOS/N 310R0878N65DBrowndog LLC · Lksid Marblhd, OHBuilt 1972 · S/N 3400092N6610BP R Air Corp · San Mateo, CABuilt 1958 · S/N 35710N6625BRegistration Pending · Stephenville, TXRegistration pendingS/N 35725N6627BVmc Aviation · Yorba Linda, CABuilt 1958 · S/N 35727N662RKlotz Douglas · Incline Village, NVBuilt 1960 · S/N 39102N6633BNeel Aviation LLC · Lakeland, FLBuilt 1958 · S/N 35733
Back to AD 76-08-02 R2