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.

N2632BHeubeck Associates Inc · New York, NYBuilt 1979 · S/N 310R1626N2634KKoeppel Steven Lynn Trustee · Mckinney, TXS/N 310R1637N26355Fay Andrew T · San Marcos, TXS/N 310R1645N2635XN2635x LLC · Eau Claire, WIS/N 310R1642N26370Gv Air Inc · Medford, ORBuilt 1979 · S/N 310R1659N2637DMcanulla Robert · Trabuco Canyon, CABuilt 1979 · S/N 310R1655N2638CPickett Joseph C · El Paso, TXBuilt 1955 · S/N 35038N2638XSoftware 2000 Inc · Arroyo Grande, CABuilt 1979 · S/N 310R1666N2638YLawson Sean E · Lexington, KYS/N 310R1667N2640FLaguna Verde Leasing Inc · Wilmington, DEBuilt 1979 · S/N 310R1676N2641PChandler David G · Phoenix, AZBuilt 1979 · S/N 310R1679N2641ZTfs Air LLC · Loveland, COBuilt 1979 · S/N 310R1804N2642ACronin LLC · Jacksonville, FLBuilt 1979 · S/N 310R1682N2642CMuniz Elmer · Port Saint Lucie, FLS/N 35042N2642YStallings Ted W · Seldovia, AKS/N 310R1684N2643YCompany Plane LLC · Wisconsin Rapids, WIS/N 310R1687N2643ZPolizzi Christopher I · Peachtree City, GABuilt 1979 · S/N 310R1688N2644VCrosby David · Potomac, MDBuilt 1979 · S/N 310R1812N2655CSmith Lionel J · Ironton, MOBuilt 1955 · S/N 35055N2664Lcj Holdings LLC · Youngsville, LAS/N 310R0195N26692Fields Douglas P Jr · Brooklyn, NYBuilt 1979 · S/N 310R1849N2671CHouchen Chris F · Palmer, AKBuilt 1955 · S/N 35071N2672CClipper Sky LLC · Las Vegas, NVS/N 35072N2674CTri County Sprayers Inc · Hamlin, TXBuilt 1955 · S/N 35074N2689CColvin Clu DBA · Big Cabin, OKS/N 35089N268YMilton Quincy N · Bellevue, WABuilt 1959 · S/N 35846N2694HRockingham Carriage Services Inc · Greenland, NHS/N 4140493N2695CNovak Peter A · Barrington, ILBuilt 1955 · S/N 35095N269FAir2615 LLC · Wilmington, DEBuilt 1968 · S/N 421-0177N269WTWillis James A · South Jordan, UTBuilt 1972 · S/N 340-0104N26STSky Condor Aviation LLC · Flatwoods, WVBuilt 1974 · S/N 414-0536N2700YEaton Air LLC · Spearfish, SDS/N 340A0793N2738BSonrise Aviation LLC · Portland, INBuilt 1979 · S/N 310R1828N2740TKraybill Paul D · Portola Valley, CABuilt 1979 · S/N 310R1843N275RMRodgers Kenneth · Appleton, WIBuilt 1974 · S/N 340-0511N277XSalopek Rett · Las Cruces, NMBuilt 1977 · S/N 414-0925N27JPWillis Roger · Bellview, FLS/N 39129N27KCLaperle Brian · Colebrook, NHBuilt 1974 · S/N 310Q1134N27ZZJohnson John C · Coeur D Alene, IDBuilt 1964 · S/N 310I0100N2836DSale Reported · Yucaipa, CASale reportedBuilt 1966 · S/N 411-0190N28409Gilmore Sherry · Sallisaw, OKS/N 310Q0666N285NTotem Air Inc · Seattle, WABuilt 1968 · S/N 421-0169N28835Waddingham William B · Rancho Cucamonga, CABuilt 1969 · S/N 421A-0050N28849Roonie Inc · Wilmington, DES/N 310Q0036N28913Bellas Business LLC · Kalispell, MTBuilt 1973 · S/N 340-0153N289VVBooth Emmett W · Waitsburg, WAS/N 320E-0110N28NTHammock Flying Service Inc · Black Rock, ARBuilt 1975 · S/N 310R0243N2901RBerry & Sons Trucking LLC · Eufaula, OKBuilt 1962 · S/N 310G0101N2905RKlassen Thomas · Corpus Christi, TXS/N 310G0105N2918RTown Thomas L · Chino Valley, AZBuilt 1968 · S/N 310G0118
Back to AD 76-08-02 R2