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.

N5827XBechtold Norman J · Claremore, OKBuilt 1961 · S/N 3100127N5833XOttley Adam James · Montague, CAS/N 310-0133N583DWKinetic Systems Inc · Richmond Hill, GABuilt 1973 · S/N 421B0583N5843MEastern Aero LLC · Gibsonville, NCBuilt 1969 · S/N 310P0143N5843XPierson Janice R Trustee · Scio, ORS/N 310-0143N5845MPointhigh Partners Lp · Dallas, TXBuilt 1969 · S/N 310P0145N5845XCranton Larry J · Mesa, AZBuilt 1961 · S/N 310-0145N5850MJones Michael J · Cypress, TXBuilt 1969 · S/N 310P0150N5853XAnderson Douglas S · Gansevoort, NYBuilt 1961 · S/N 310-0153N5854MJantzen Equipment LLC · Madrid, NEFirst renewal noticeBuilt 1969 · S/N 310P0154N5857MVenturi Corp · Staunton, ILBuilt 1969 · S/N 310P0157N5859MJasper County Properties LLC · Jasper, TXBuilt 1972 · S/N 340-0057N5862MPortland Holdings LLC · Vista, CABuilt 1969 · S/N 310P0162N586JRHuerta Holdings Inc · Santa Ana, CABuilt 1969 · S/N 310P0165N5870MMcdonald Brian L · Van Alstyne, TXBuilt 1972 · S/N 3400058N5872MDixon Jack · Casa Grande, AZBuilt 1969 · S/N 310P0172N5874CVola Acosta LLC · Lake Forest, CAS/N 421C0882N5877MBrook Ash Inc · Waxahachie, TXS/N 310P0177N5878MKodiak Helo LLC · Kodiak, AKBuilt 1972 · S/N 340-0059N587GFReher David P · Arlington, TXBuilt 1975 · S/N 310R0246N587MWHammonds Mark · N Richlnd Hls, TXBuilt 1974 · S/N 421B0587N5882TDe Smet Vicki M · La Verne, CAS/N 421B0424N5885MButler Richard A · Portland, TXBuilt 1969 · S/N 310P0185N5889MKinney James R · Vermillion, SDBuilt 1969 · S/N 310P0189N588DMColeman Russell Ll · Saint Charles, ILBuilt 1973 · S/N 310Q0624N588RRGay Don F · Terrell, TXBuilt 1966 · S/N 310K0091N589DMGeorgescu Radu A · Louisville, KYS/N 310Q1048N58JASunergy Solutions LLC · Londonderry, NHBuilt 1975 · S/N 3400521N590FMTrrek Enterprises LLC · Sunriver, ORBuilt 1966 · S/N 320D0095N5910MCross Country Well Service LLC · Farmington, NMS/N 340-0067N5911MYataco Enrique · Dothan, ALS/N 310P0211N5913MWallace Larry Wayne · Millsap, TXBuilt 1969 · S/N 310P0213N5914MBogie Aviation LLC · Newton, NJBuilt 1969 · S/N 310P0214N5916MQuest Aviation Inc · Lake City, FLBuilt 1973 · S/N 402B0365N5925MDickerson Stephen R · Frisco, TXBuilt 1969 · S/N 310P0225N592GCFogelson Robert A · Tillamook, ORBuilt 1972 · S/N 340-0152N5931MSteven F Danz LLC · Encino, CABuilt 1972 · S/N 340-0071N5933MMonahan Robert J · Bulverde, TXBuilt 1969 · S/N 310P0233N5934M34m LLC · Young Harris, GABuilt 1969 · S/N 310P0234N5938MKarlen John R · Boring, ORS/N 340-0074N593DMLister John · Pipe Creek, TXS/N 402B1228N5949MSnflk Leasing LLC · Andrews, TXBuilt 1972 · S/N 421B0319N594WBUintacor Inc · Mesa, AZS/N 310Q0077N5951MMcdonnell Enterprises Inc · Wilmington, DEBuilt 1973 · S/N 310Q0737N5962MKitov Resources Corp · Shorewood, WIS/N 421B0205N5967MN5967m LLC · Chantilly, VAS/N 421B0210N5975JFreeland Christopher G · Brownwood, TXS/N 414-0028N5988MSaltzer Eric · Somerton, AZBuilt 1972 · S/N 421B0231N5996MMedcare Emergency Medical Services Inc · Mcallen, TXBuilt 1972 · S/N 421B0334N59DJBruce Matthew B · Arlington, TXBuilt 1959 · S/N 35915
Back to AD 76-08-02 R2