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.

N8787PA B Helton Enterprises LLC · Warthen, GABuilt 1965 · S/N 24-4239N8788CSaflight Pilot Training Inc · Manchester, NHS/N 28R-7635182N8788DMartens Edwin L · Ogallala, NEBuilt 1958 · S/N 18-6325N8788ECoastal Fliers Inc · El Cajon, CABuilt 1976 · S/N 28-7690204N8788RRicher Ned A · Glendale, AZBuilt 2016 · S/N 91895N8788WMacken Jason P · Lancaster, NYBuilt 1964 · S/N 28-10335N8788YAerotransit Inc · Milwaukee, WIS/N 30-1946N87898Scott Shawn · Darrington, WAS/N 440301N8789DStrembicke Derek R · Owens Cross Roads, ALS/N 18-6326N8789PCannell John D · New Franken, WIBuilt 1965 · S/N 24-4241N878ACDecathlon LLC · Herndon, VABuilt 2001 · S/N 878-2001N878BTBlue Paradise Aviation LLC · Clive, IABuilt 2005 · S/N 3257402N878CBPollux Aviation Ltd · Wasilla, AKBuilt 2004 · S/N 10404N878DZSlayback Eric J · Florence, KYBuilt 2004 · S/N 81885N878MAAgri Med LLC · Belgrade, MTBuilt 2006 · S/N 1415-2006N878MCHelicopter Leasing LLC · Henderson, NVBuilt 2005 · S/N 3782N878MJJackson Air LLC · Paragould, ARBuilt 1976 · S/N 32-7640078N878WSWallace State Community College · Hanceville, ALBuilt 2021 · S/N 28020033N878ZCrawford Chris M · Petersburg, VAS/N 80096N8790EFenty Brandon · Normandy, TNBuilt 1976 · S/N 28R-7635214N8790PBison Reserved LLC · Chicago, ILBuilt 1965 · S/N 24-4243N8791EKl&Z Farms LLC · Littleton, NCBuilt 1976 · S/N 32-7600012N8791LMarkes Tim · Douglas, OKBuilt 1970 · S/N 25-5278N8791NVetter Daniel W · Dayton, NVBuilt 1969 · S/N 28-25631N8791WRegistration Pending · Johns Island, SCRegistration pendingBuilt 1964 · S/N 28-10339N8791YGeboy Alan R III · Baxley, GABuilt 1969 · S/N 30-1949N8792DAndresen Elouise H · Anchorage, AKBuilt 1958 · S/N 18-6333N8792EMann Joshua A · Montgomery, TXBuilt 1976 · S/N 32R-7680178N8792NPiotrowski Nicholas S · Poplar Grove, ILBuilt 1969 · S/N 28-25633N8792PPrivette Richard E · Oak Hill, FLBuilt 1965 · S/N 24-4245N8792WHale Mitchell D · Chugiak, AKBuilt 1964 · S/N 28-10340N8793LVoerman Joseph R Jr · Cambridge, NYBuilt 1974 · S/N 18-7409125N8793PFlaagan Kevin D · Beulah, NDBuilt 1965 · S/N 24-4246N8794FMundell Terry D Trustee · Rosston, OKBuilt 1962 · S/N 103-0002N8794GBarrymore Blake · Hailey, IDBuilt 2019 · S/N JA515-12-17N8794NCopeland Kevin D · Vidalia, GABuilt 1969 · S/N 28-25637N8794PDelaware Mark P · Phoenix, AZBuilt 1965 · S/N 24-4247N8795NCycle-Moto Inc · Gilbert, AZBuilt 1969 · S/N 28-25639N8795PJejgr LLC · Presho, SDBuilt 1965 · S/N 24-4248N8795WKessel Run Holdings LLC · Seminole, FLBuilt 1964 · S/N 28-10343N8795YJohnson Paul · Wichita Falls, TXS/N 30-1954N8796DNelson Rohn R · Salmon, IDBuilt 1958 · S/N 18-6341N8796NMitchell Michael R · Swanville, MEBuilt 1969 · S/N 28-25640N8796PAllie Doug B · Glasgow, MTBuilt 1965 · S/N 24-4249N8796WRegistered aircraftBuilt 1964 · S/N 28-10345N8797BDalton Robert Frank · Jackson, CAS/N 32-40149N8797CMeadowlake Airpark LLC · Lenoir City, TNBuilt 1976 · S/N 32-7640071N8797DDuflo Spray Chemical Inc · Lowville, NYS/N 18-6342N8797EVan Beckum Peter · Farmington, CTBuilt 1976 · S/N 28-7690209N8797PPlant Curtis W · Runge, TXBuilt 1965 · S/N 24-4250
Back to AD 87-10-06 R1