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.

N352TImpact Aviation LLC · Ballwin, MOBuilt 1973 · S/N 340-0227N352TSBoss Contract Services LLC · Terry, MTBuilt 1972 · S/N 414-0352N353DCulver Marc D · Anchorage, AKBuilt 1956 · S/N 35353N3540MDybel William P · Frankfort, ILS/N 421B0472N3556GBenard Richard D · Lakeville, MAS/N 310R0869N355RTBeechwood Aviation LLC · Wilmington, DEBuilt 1974 · S/N 421B0633N355SCSmith Loren D · Great Falls, MTBuilt 1973 · S/N 310Q0795N3563GSkaya Aircraft LLC · Kalispell, MTS/N 310R0871N3587GAtor Robert W · Beach City, TXS/N 310R0874N358MNKeystone Aerial Surveys Inc · Philadelphia, PAS/N 310R0881N35FSSelistli LLC · San Mateo, CABuilt 1974 · S/N 421B0831N35TGPerkins David A · Locust Grove, OKS/N 340A1203N35VCGomez Victor · Isabela, PRBuilt 1969 · S/N 401A0126N3607DCusick Christopher J · La Jolla, CABuilt 1956 · S/N 35307N3616DRobinson Mark V · Vacaville, CABuilt 1956 · S/N 35316N3618GIndustrial Consulting LLC · Repton, ALBuilt 1956 · S/N 35313N361GCFff Leasing LLC · Dover, DES/N 414-0616N3631DMortgage Experts LLC · Homestead, FLBuilt 1956 · S/N 35331N3636CSale Reported · Galena, KSSale reportedBuilt 1966 · S/N 310K0137N3639DOlah Michael J DBA · Mazomanie, WIBuilt 1956 · S/N 35339N363RMMash Kity J LLC · Grand Rapids, MIBuilt 1974 · S/N 310R0046N3640GTailwind Flight Center - Sue LLC · Sturgeon Bay, WIBuilt 1977 · S/N 310R0880N3641DAdkins Steven · Oriental, NCBuilt 1956 · S/N 35341N3642DCorre Training Industries Inc · Federal Way, WABuilt 1956 · S/N 35342N3647DVmc Aviation · Upland, CAS/N 35347N3648DFerry Theodore D · Bellevue, WABuilt 1956 · S/N 35348N364APMartin John T · Paradise, CAS/N 35340N364NYMarc Inc · Bolton, MSS/N 310R-0718N3667DBpm Rentals Inc · Lincoln, CABuilt 1956 · S/N 35367N366DHummer Family Capital Aviation LLC · Boonton, NJBuilt 1966 · S/N 310K0230N3674DUS Flight Academy International Inc DBA · Post, TXBuilt 1956 · S/N 35374N3679DCheney Joseph F · Daphne, ALS/N 35379N367ATL&R Aircrafts Corp · Boynton Beach, FLBuilt 1972 · S/N 310Q0522N3681DGcsw Holdings Inc · Poplar Grove, ILBuilt 1956 · S/N 35381N3682DLasseter Granville D II · Richmond, TXBuilt 1956 · S/N 35382N36846Armbruster LLC · Amherst, OHBuilt 1979 · S/N 310R1600N36862Linville Keith · Bend, ORBuilt 1979 · S/N 310R1605N3696GTfa Holding Corp · Daytona Beach, FLS/N 310R0898N36CGDay Edwin Daniel · Richland, WABuilt 1969 · S/N 310P0075N36DLCroll Robert H III · Jacksonville, ORBuilt 1969 · S/N 310P0113N36EWSalzer Dustin J · Weatherford, TXS/N 310Q0521N36KWEastern Aviation Publishing Inc · Center Harbor, NHS/N 310R0296N3705GSouthern Illinois University DBA · Murphysboro, ILS/N 310R0900N3720GPersonal Space Aviation LLC · Nokomis, FLBuilt 1977 · S/N 310R0955N37237Hudson Bay Holdings LLC · Lebanon, TNBuilt 1977 · S/N 310R0968N37242Sol Aerial Surveys LLC · Las Vegas, NVS/N 310R0969N37256Patriot Air Inc · Belleville, ILBuilt 1977 · S/N 310R0977N37268H & S Aircraft LLC · Lewes, DEBuilt 1977 · S/N 310R0983N372CCLemieux Kenneth G · Oneida, TNBuilt 1974 · S/N 310Q1071N372FCHeartland Aviation Inc · Alliance, NEBuilt 1971 · S/N 310Q0215
Back to AD 76-08-02 R2