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.

N9217KR & R Air Inc · Wilmington, DEBuilt 1976 · S/N 28-7615183N9217MMullenbach Arnold D · Tucson, AZBuilt 1966 · S/N 3438N9217PGruber Joachim R · Elizabethtown, KYFirst renewal noticeBuilt 1967 · S/N 24-4713N9217TRegistered aircraftBuilt 1991 · S/N 14020CN9217WMartin Joe T Jr · Chandler, AZBuilt 1967 · S/N 28-10882N9217XSkyborne Airline Academy Inc · Vero Beach, FLNon-citizen corporation, flight hours not reportedBuilt 1988 · S/N 2841022N9218CArensmeyer Michael W · Longmont, COBuilt 1978 · S/N R18200448N9218DMaestas Jonathan M · Wright City, MOBuilt 1958 · S/N 22-6278N9218RFishe Flying Corp · Vero Beach, FLBuilt 1988 · S/N 2841023N9218SSurette Phillip · Vail, COBuilt 2021 · S/N 72354N9218VTerrell Aviation Inc · Terrell, TXBuilt 1969 · S/N 690051N9218WRitcheson Mark F · Tucson, AZBuilt 1967 · S/N 28-10883N9218YHubble Boeing Development Corp · Gallipolis, OHBuilt 1968 · S/N 31-282N9219EStahl Randy F · Fort Benton, MTBuilt 1977 · S/N 7140CN9219HKful Flyers Foundation Inc · Fullerton, CABuilt 1975 · S/N 17266021N9219KJones Robert M · Brooksville, FLBuilt 1976 · S/N 28-7690229N9219PChrastka Keith · San Angelo, TXBuilt 1967 · S/N 24-4715N9219VChen Brian K · Bakersfield, CABuilt 1969 · S/N 690047N921AARegistration Pending · Deland, FLRegistration pendingBuilt 1973 · S/N 17261752N921BLLewis Bertrand V · Glendale, AZBuilt 1964 · S/N 30558N921CBDavis David G · Cresson, TXFirst renewal noticeBuilt 1980 · S/N 32R-8129019N921CTN921ct LLC · Elkton, KYS/N 18281220N921DCCarlson Donald A III · Lexington, TNBuilt 1975 · S/N AA5B-0039N921GDAir Charter Inc DBA · Culebra, PRBuilt 1974 · S/N 420N921JBC&Z Aero LLC · Des Plaines, ILBuilt 1976 · S/N 32R-7780099N921JKShackleford Wayne D · Riverside, CABuilt 1982 · S/N 921-80N921JMFlight Equity LLC · Fayetteville, ARBuilt 2004 · S/N 10565N921KCRocket City Helicopters LLC · Brownsboro, ALBuilt 1992 · S/N 2180N921KPCenturion N709jm LLC · Minneapolis, MNBuilt 1978 · S/N R18200298N921LCCrum Robert W · Lake Havasu City, AZBuilt 1969 · S/N 28-25939N921LGHertz David · Dix Hills, NYBuilt 2012 · S/N 40790N921LJGossett Chase · Centre, ALBuilt 1977 · S/N 32R-7780449N921NDUniversity Of North Dakota · Grand Forks, NDBuilt 2025 · S/N 2881885N921PABird Acquisition LLC · Phoenix, AZBuilt 1999 · S/N 2843268N921PCProppe Karl H · Needham, MABuilt 1992 · S/N 1809058N921RSSpry Mark W · Elkmont, ALBuilt 2020 · S/N 221MSN921SJDavis Brandon Grey · Huntsville, ALBuilt 2010 · S/N 20208N921TAAtp Aircraft 4 LLC · Wilmington, DEBuilt 1997 · S/N 17280244N921TCBell Charles S · Fort Payne, ALS/N 23695N921TTRed Baron LLC · Middletown, DEBuilt 2001 · S/N 2012N921UTumbleweed Leasing Co Inc · Salt Lake City, UTBuilt 2004 · S/N 3566N921UN921un Ventures LLC · Mercer Island, WABuilt 2004 · S/N T20608501N921WC7 Corp · Orlando, FLBuilt 1964 · S/N 2878N921WJJones Wesley C · Yuba City, CABuilt 2016 · S/N 90822N921XPLengler Aviation LLC · Fort Myers, FLBuilt 1962 · S/N 1905N922Tjk Enterprises LLC · Helena, MTBuilt 1977 · S/N 965-77N9220BSchmalenberger Jason R · Hebron, NDBuilt 1993 · S/N 3213048N9220CDixon Aviation LLC · Oakland, MDBuilt 1978 · S/N 32-7840091N9220DEllis Harvey Airport Inc · Guthrie, OKS/N 22-6280N9220MBeaty David · Santa Fe, NMBuilt 1966 · S/N 1181
Back to AD 87-10-06 R1