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.

N1106QOrellana Wilson · Hesperia, CAS/N 310H0106N1107QValiair Limited Co Trustee · Casper, WYBuilt 1963 · S/N 310H0107N110CSFlorida Keys Flight Academy LLC · Marathon, FLBuilt 1972 · S/N 310Q0616N110DHYingling Consultation LLC · Wilmington, DES/N 421B0137N1112QLastowski Gerald J · Gulf Breeze, FLBuilt 1963 · S/N 310H0112N1113TWirthlin Donald K · Sierra Vista, AZBuilt 1957 · S/N 35561N1119QKeeton Andrew · Palestine, TXBuilt 1963 · S/N 310H0119N111BXDonadio Robert F · Amherst, NHBuilt 1972 · S/N 414-0368N111EAExecutive Air Inc · Roanoke, VAS/N 310R0245N111GTMorgan Gerald W · Hillsboro, TXS/N 340-0188N111NCDaxair Aviation LLC · Scottsdale, AZBuilt 1975 · S/N 310R0182N111SDMarc Inc · Bolton, MSBuilt 1969 · S/N 310P0200N111TFPacific Aviation Aircraft Management Inc · Ontario, ORBuilt 1974 · S/N 421B0660N111TLNdk Global Holdings Corp · Dover, DEBuilt 1974 · S/N 421B0645N111XBoone Aviation Ltd · Denver, COBuilt 1965 · S/N 310J0108N1121QTwomey Kieran S · Coronado, CABuilt 1963 · S/N 310H0121N11220Southern Arkansas University Tech · Camden, ARBuilt 1957 · S/N 38037N1129QTippecanoe Valley Aero Inc · Delphi, INBuilt 1963 · S/N 310H0129N112HPBertagnole Karl R · Wright, WYBuilt 1964 · S/N 310I0104N112HRFlexer Howard · Monterey Park, CAS/N 35217N112WWAmerican Smooth Aviation LLC · Rock Hill, SCBuilt 1977 · S/N 310R1215N1133QHaggard Haley G · Springer, OKBuilt 1963 · S/N 310H0133N113KKolstad Christopher Van · Galata, MTBuilt 1975 · S/N 310R0107N114AMLon Air LLC · Longwood, FLBuilt 1977 · S/N 310R0887N114HVAerowerks LLC · Georgetown, TXBuilt 1973 · S/N 421B0371N115CKSchmick Kenneth R · Fond Du Lac, WIS/N 35281N116BGGood Bill T · Temecula, CABuilt 1955 · S/N 35116N116EALewistown Aviation Inc · Lewistown, PABuilt 1979 · S/N 340A0750N117JDVintage Motors Inc · Beattyville, KYBuilt 1967 · S/N 310L-0167N117KZRichards Robert · Waco, TXS/N 310Q0964N117TCChristensen Del S · Friendswood, TXBuilt 1973 · S/N 310Q0786N117WWNowak Jerome S · Elmhurst, ILS/N 320D0096N1181FPatel Jayesh V · Titusville, FLBuilt 1959 · S/N 35971N1188Persky Adam · New Bern, NCBuilt 1960 · S/N 39152N1189MQuality Aviation Inc · Marana, AZS/N 39180N119PARicciardi Brian P · Hyannis, MAS/N 402B0610N11DEPeile Kelly · Lakeview, ORS/N 38087N11GXWestrum Enterprises LLC · Norwalk, IABuilt 1976 · S/N 310R0645N11SLJohnson Randy L · Pikeville, KYBuilt 1960 · S/N 310-0029N11TJKubic Daniel W · Advance, NCBuilt 1979 · S/N 310R1683N1202GTyler Brenda · Mountain Top, PABuilt 1974 · S/N 310Q1057N1203GWestern Pilot Service Inc · Phoenix, AZBuilt 1975 · S/N 414-0649N1203WPro Aire Cargo & Consulting Inc · Oshkosh, WIBuilt 1980 · S/N 310R-2106N1205GKnapp James Ross · Apex, NCBuilt 1974 · S/N 310Q1060N12144Pittsburgh Institute Of Aeronautics · West Mifflin, PABuilt 1958 · S/N 31038118N1214G9791m LLC · Tacoma, WABuilt 1975 · S/N 414-0652N1216GNeel Aviation LLC · Lakeland, FLS/N 414-0653N121BKSeabee Training Corp · Birmingham, ALBuilt 1977 · S/N 310R0893N121DRJohnson And Son Enterprises · Dunn, NCBuilt 1974 · S/N 310Q1046N121LATgl Inc · Wilmington, DEBuilt 1973 · S/N 310Q0973
Back to AD 76-08-02 R2