AD 87-10-06 R1

Registered aircraft · 72,010

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-10-06-R1')
    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-10-06-R1')
  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.

N9522SSnohomish Flying Service Inc · Snohomish, WABuilt 1998 · S/N 17280432N9522WPrio Frank A · Milwaukee, WIBuilt 1967 · S/N 28-22949N95231Duncan Paul D · Norfolk, NEBuilt 1969 · S/N 28-25856N95236Plane Crazy LLC · Bennington, NEBuilt 1969 · S/N 28-25857N95237Klassen Glenn Kurt · Chandler, AZBuilt 1969 · S/N 28-25858N95238Date Greg · Spokane Valley, WABuilt 1969 · S/N 28-25859N9523DHauser Nathan S · Newark, DEBuilt 1958 · S/N 22-6431N9523HVictor James A · Kingsville, OHBuilt 1975 · S/N 17266199N9523JMichalka James R · Portage, MIBuilt 1966 · S/N 28-3648N9523LCnaa LLC · Mooresville, NCBuilt 1974 · S/N AA5-0523N9523WOberg Harry W C III · Evanston, WYBuilt 1967 · S/N 28-22950N95242Kane Aviation Holdings LLC · Bernardsville, NJBuilt 1998 · S/N 18280146N95244Banas Darryl P · Waco, TXBuilt 1969 · S/N 28-25861N9524JZanella Paul J · Ballston Spa, NYBuilt 1966 · S/N 28-3649N9524LHritz Michael G · Carlisle, PABuilt 1974 · S/N AA5-0524N9524QHernandez Joseph P · Arvada, COBuilt 1976 · S/N 61-0347-113N95253Mmou LLC · Fort Worth, TXBuilt 1969 · S/N 28-25862N95255Herren Robert H · Lexington, KYBuilt 1969 · S/N 28-25863N95259Erickson Landon S · Fairbanks, AKBuilt 1969 · S/N 28-25866N9525DFlying Neutrons LLC · Lebanon, OHBuilt 1998 · S/N 18280147N9525JSandpiper Nag LLC · Louisville, KYBuilt 1966 · S/N 28-3650N9525MVaughn Robert Bruce · Macon, GABuilt 1966 · S/N 670102N9525PGeorgetown Flying Club LLC · Pawleys Island, SCBuilt 1997 · S/N 18280177N95264Jorquez Andrew D · Santa Paula, CABuilt 1969 · S/N 28-25867N95265Red River Aviation Services LLC · Altus, OKS/N 28-25868N95266Walton Robert · Franklin Lakes, NJS/N 28-25869N9526BWildenberg Ronald · Beloit, WIBuilt 1981 · S/N 172RG0855N9526GAtlas Aviation Tampa Inc · Tampa, FLBuilt 1998 · S/N 17280434N9526HAbove The Haze LLC · San Lorenzo, CABuilt 1975 · S/N 17266201N9526JWorthington Brian · Las Vegas, NVBuilt 1966 · S/N 28-3652N9526LAnderson Jeffrey · Ann Arbor, MIBuilt 1974 · S/N AA5-0526N9526MRegistered aircraftBuilt 1966 · S/N 670103N9526PSlenicka Kevin B · Enterprise, ALBuilt 1958 · S/N 24-558N9526WMarch Theodore M · Fernley, NVBuilt 1967 · S/N 28-22954N9526YBeechcraft Heritage Museum · Tullahoma, TNBuilt 1962 · S/N TD-500N95270Get Away 1 LLC · St George, UTBuilt 1969 · S/N 28-25870N95271Ederer Martin J · Baraboo, WIBuilt 1969 · S/N 28-25871N9527JOklahoma Flight Academy LLC · Owasso, OKBuilt 1966 · S/N 28-3653N9527WDieck Michael J · Fayetteville, NCFirst renewal noticeS/N 28-22955N95285Bangerter James Alan · Indn Hbr Bch, FLBuilt 1969 · S/N 28-25875N9528DGreenhead Flight Services LLC · Bemidji, MNBuilt 1958 · S/N 22-6444N9528JGiles Dennis E II · Pearson, WIBuilt 1966 · S/N 28-3654N9528WWings Over Texas Holdings LLC · Denton, TXBuilt 1998 · S/N 17280467N9529DHeil Jay E · Brownton, MNBuilt 1958 · S/N 22-6445N9529LMcdaniel Mark O · Martinsville, INBuilt 1974 · S/N AA5-0529N9529MWilson Judy · Stamps, ARBuilt 1966 · S/N 670106N9529PCentral Air Parts Inc · Staunton, ILBuilt 1974 · S/N 25-7405615N9529SRegistered aircraftBuilt 1965 · S/N 331N9529WFlight Operations Aircraft LLC · Wilmington, DEBuilt 1998 · S/N 17280470N952AArcher Aero LLC · Wilmington, DEBuilt 2015 · S/N 2843804
Back to AD 87-10-06 R1