OpenAirDocs.org
AD 87-08-08 R3

Registered aircraft · 22,416

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:87-08-08-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-08-08-R3')
  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.

N777CWKeidel Mark T · Redlands, CABuilt 1977 · S/N 28-7890233N777ESD&J Aviation LLC · Gotha, FLBuilt 1997 · S/N 2843088N777EZInternational Aviation Group LLC · Lake Wales, FLBuilt 1978 · S/N 28-7916216N777FGMarks Robert L · Ramona, CABuilt 1979 · S/N 28R-7931136N777FMBolduc John A · Port Saint Lucie, FLBuilt 1968 · S/N 32-1059N777JDFwm Aviation Inc · Washington, DCBuilt 1977 · S/N 28R-7703156N777KCWing It LLC · Carlisle, IABuilt 1976 · S/N 28-7625239N777LYUmpqua Flying Organization LLC · Roseburg, ORBuilt 1974 · S/N 32-7440079N777MDMateusz Dziuda · CambridgeBuilt 1981 · S/N 28R-8131117N777NFN777nf Aviation LLC · Fort Worth, TXS/N 3246206N777RZRapid 6 Flyers LLC · Rapid City, SDBuilt 1970 · S/N 32-40907N777SDBoomerang Air LLC · Cedar Park, TXBuilt 1980 · S/N 28-8190125N777SKDj Internet Commerce LLC · Crowley, LABuilt 1977 · S/N 32R-7780017N777SRWilkie David J · Nashua, NHS/N 28-20268N777VPFlightwing Equipment Corp · Beverly Hills, CABuilt 1974 · S/N 28-7415632N777VXGutierrez Ruben E · Fontana, CABuilt 1968 · S/N 28-24298N777WLucky Shot LLC · Dayton, OHBuilt 1977 · S/N 32R-7780297N777WBClark Lloyd E · Hanover, MDBuilt 1973 · S/N 28-7305219N777YUEvenhaim Ronen · Canoga Park, CABuilt 1980 · S/N 32R-8029065N7781NKns Asset Management LLC · Lumberton, TXBuilt 1968 · S/N 28-5229N7782WDavies Kenneth A · Oak Harbor, WABuilt 1964 · S/N 28-1789N7783NForbes Aviation LLC · Boise, IDBuilt 1968 · S/N 28-5231N7784WHarding Robert L · Nine Mile Falls, WABuilt 1964 · S/N 28-1792N7785NMorning Aviation LLC · Altoona, PABuilt 1968 · S/N 28-5232N7786NPearson Derek E · Rockwell City, IABuilt 1969 · S/N 28-5233N7786WRoger Dodger Vector Victor LLC · Fort Myers, FLBuilt 1964 · S/N 28-1794N7787NBarker Lynn Harvey · Sylmar, CABuilt 1969 · S/N 28-5235N7788NZwickel Claire · Catskill, NYBuilt 1968 · S/N 28-5236N7788WRichards Adam R · Mesa, AZBuilt 1964 · S/N 28-1797N7789NAntaya Adam N · Lakeland, FLS/N 28-5237N7789WNguyen Tu K · Huntington Beach, CAS/N 28-1798N778CWingnut Aviation Group LLC · Seymour, CTBuilt 2006 · S/N 3255046N778NDUniversity Of North Dakota · Grand Forks, NDBuilt 2018 · S/N 2881045N778RCBwear Enterprises LLC · Birmingham, ALBuilt 1978 · S/N 32-7940018N7790NSchmid Daniel J · Dodgeville, WIBuilt 1968 · S/N 28-5238N7790WSpratt Don · Groveland, FLBuilt 1964 · S/N 28-1800N7791NMinmill William J · Comfort, TXBuilt 1969 · S/N 28-5239N7791WLunceford Andrew · Morgan Hill, CABuilt 1964 · S/N 28-1801N7792NRise Aircraft 2 LLC · Tomball, TXBuilt 1968 · S/N 28-5240N7792WMoffit Matthew · West Memphis, ARFirst renewal noticeBuilt 1964 · S/N 28-1802N7793CPaolucci James H · Warwick, RIBuilt 1975 · S/N 28-7690082N7793WEa Aircraft Holdings LLC · Myrtle Point, ORBuilt 1964 · S/N 28-1804N7794NAnderson Ernie N · Troutman, NCBuilt 1968 · S/N 28-5243N7796WTuttle Jason D · Denver, COBuilt 1964 · S/N 28-1808N7797NSprague Joseph G · Hendersonville, NCBuilt 1968 · S/N 28-5246N7797WCameo Aviation Group LLC · Manchester, MOBuilt 1964 · S/N 28-1779N7798WLeopard James · Huntersville, NCS/N 28-1783N779AKJust Plane Partners LLC · Yorba Linda, CABuilt 1974 · S/N 28R-7435160N779GCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 2881222N779LKAtmospheric Vehicle & Spacecraft Flt Exploration · Rch Palos Vrd, CABuilt 1967 · S/N 28-24022
Back to AD 87-08-08 R3