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.

N721VGB & W Aerial Spray Inc · Dimmitt, TXS/N 421B0847N721YGRunway Aviation Flight Training USA Corp · Rockwall, TXBuilt 1974 · S/N 340-0342N726LAValiair Lc Trustee · Casper, WYBuilt 1974 · S/N 421B0651N728FRRoyal Air Freight Inc · Waterford, MIBuilt 1977 · S/N 310R1248N728SCQuist David Andrew · Lake Jackson, TXS/N 310Q0989N730AFB Fam LLC · Texico, NMBuilt 1976 · S/N 414-0853N7316UDarvek LLC · Las Vegas, NVBuilt 1965 · S/N 411-0016N737MASipes Gary C · Livingston, TXS/N 310N-0093N73EPColburn & Associates LLC · Woodruff, SCBuilt 1973 · S/N 340-0240N740AGStefenelli Aviation N-Tr Inc Trustee · AtterseeS/N 421A-0033N741DFSeeding Operations And Atmospheric Res (Soar) LLC · San Angelo, TXBuilt 1975 · S/N 414-0633N745EPSumner Michael · Hahira, GABuilt 1974 · S/N 414-0498N747RMJones Roy F · Benson, AZBuilt 1960 · S/N 39097N747YKYk Flight Inc Trustee · Wilmington, DEBuilt 1975 · S/N 310R0138N748MGEl Paso Aero Inc · El Paso, TXBuilt 1974 · S/N T310Q1128N749SDewitt Scott · Corpus Christi, TXBuilt 1964 · S/N 320C0016N74HJRegistration Pending · Sheridan, WYRegistration pendingBuilt 1974 · S/N 340-0333N7505QJohnson Michael L · Jefferson, TXBuilt 1969 · S/N 310Q0005N7508QZulu Hours LLC · Moneta, VABuilt 1969 · S/N 310Q0008N750DRLukowski Zachary L · Gainesville, FLBuilt 1975 · S/N 310R-0064N750PCMarilyn Merlot LLC · Kalispell, MTBuilt 1972 · S/N 340-0189N7510QOne Zero Q LLC · Mount Pleasant, MIBuilt 1969 · S/N 310Q0010N7512QGorge Winds Aviation Inc · Fairview, ORBuilt 1969 · S/N 310Q0012N7516QS Flight LLC · Evergreen, COBuilt 1972 · S/N 310Q0530N7517QQuay Ventures LLC · Alto, TXBuilt 1969 · S/N 310Q0017N7525QBuckin Donald L · Phoenix, AZS/N 310Q0025N7526QWhat A Day To Travel LLC · Edgerton, WIS/N 310Q0026N752DTBreak Even Aircraft Resourcing LLC · Olathe, KSBuilt 1958 · S/N 35752N7530QBas Part Sales LLC · Greeley, COBuilt 1970 · S/N 310Q0030N7531QSantiago Jose G Jr · Woodstock, GABuilt 1969 · S/N 310Q0031N7537QRegistration Pending · Defiance, OHRegistration pending, pending cancellationBuilt 1970 · S/N 310Q0037N7549QAlford Air Transportation LLC · Kernersville, NCBuilt 1972 · S/N 421B0341N754JSDy34 LLC · Adamsville, TNBuilt 1975 · S/N 414-0643N7552QTaylor Randy L · Upland, CABuilt 1969 · S/N 310Q0052N7554QSky Farmer LLC · Culleoka, TNBuilt 1970 · S/N 310Q0054N7556QKent Schreiber Company · Greencastle, PABuilt 1972 · S/N 310Q0604N7557QCircle C Aviation LLC · Orlando, FLBuilt 1972 · S/N 421B0345N755ACAirswiss Inc · Wilmington, DEBuilt 1968 · S/N 402A0001N7564QFairchild Chad E · Logandale, NVBuilt 1970 · S/N 310Q0064N7568QJughead Aircraft LLC · Salina, KSBuilt 1970 · S/N 310Q0068N757CAKenyon Walter C · Eureka Springs, ARBuilt 1972 · S/N 310Q-0535N7584QArnold Brandon M · Roswell, NMBuilt 1970 · S/N 310Q0084N7586QTyler Rdh Investments LLC · Tyler, TXBuilt 1970 · S/N 310Q0086N7589QTemptation Motors Ltd · Hayward, CABuilt 1970 · S/N 310Q0089N758DCSale Reported · Altoona, FLSale reportedBuilt 1972 · S/N 310Q0471N759JSIsland 414 LLC · St Simons Island, GAS/N 414-0936N75CBEastmann Transport Services LLC · El Paso, TXBuilt 1975 · S/N 421B0861N75GBPro Aire Cargo & Consulting Inc · Oshkosh, WIBuilt 1975 · S/N 402B0912N75SKRick Broke Entertainment LLC · Conyers, GABuilt 1974 · S/N 421B0646N75SUSchleinig Andras · Arlington, WAS/N 38110
Back to AD 76-08-02 R2