AD 87-20-03 R2

Registered aircraft · 54,015

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-20-03-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:87-20-03-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.

N94227Dodson International Parts Inc · Rantoul, KSBuilt 1974 · S/N 21060549N9422BFallbrook Air Service · Fallbrook, CAS/N 55222N9422HFort Smith Flying Club Inc · Fort Smith, ARBuilt 1981 · S/N 18267946N9422KFaulkner Harry E Jr · Bethel, AKS/N U20604395N9422TGraves Frank C · Nocona, TXBuilt 1960 · S/N 57222N9422UHortman Ryan Davis · Summerville, SCBuilt 1976 · S/N 15078370N9422XLittle Bird Airways LLC · Hamburg, NYBuilt 1962 · S/N 21057722N94237Brett Ryan J · Wasilla, AKBuilt 1977 · S/N 18503294N9423BDrean Alelandre C · Ajo, AZS/N 55223N9423MPaquette Ralph H Jr · Apalachin, NYBuilt 1976 · S/N 18264749N94244Bryant Kenneth D · Black Diamond, WAS/N 21060559N94247Solberg Aviation Co Inc · Whitehouse Station, NJBuilt 1982 · S/N 15285630N9424EAero Equities LLC · Ventura, CABuilt 1979 · S/N 17272259N9424TGill Melvin L Jr · Nashville, TNS/N 57224N9425BGloeckler Alex · Pearl City, ILBuilt 1958 · S/N 55225N9425CInternational Air Services Inc Trustee · Carson City, NVBuilt 1955 · S/N 31823N9425HWingsleasing LLC · Wichita, KSBuilt 1975 · S/N 17266153N9425TBlue Skies Flying Services LLC · Blandon, PABuilt 1960 · S/N 57225N9425XOatney Jared C · South Hutchinson, KSBuilt 1985 · S/N 18268518N94260Sutton Aircraft Salvage LLC · Palmer, AKBuilt 1977 · S/N 18503296N94263Hitch Aviation Inc · Malta, MTBuilt 1974 · S/N 21060569N94266Braun Kristy J · Fairbanks, AKBuilt 1977 · S/N 18503297N94267Hop Props LLC · Houston, TXBuilt 1974 · S/N 21060571N9426CBenson Fred B · Cle Elum, WABuilt 1955 · S/N 31824N9426EDarcy Aviation LLC · Danbury, CTBuilt 1979 · S/N 17272261N9426KO Max Aviation · Willowbrook, ILBuilt 1974 · S/N 21060572N9426XBradley Brunhilde K Trustee · Litchfield Park, AZBuilt 1961 · S/N 21057726N94270N94270 LLC · Chesterfield, NJBuilt 1982 · S/N 15285634N9427MWillthedrill LLC · Las Vegas, NVBuilt 1976 · S/N 18264751N94285Great Lakes Enterprises · Heron, MTBuilt 1974 · S/N 21060584N94286Purdue Aviation LLC · West Lafayette, INBuilt 1982 · S/N 15285639N9428CJones Kathleen W · Springfield, ORBuilt 1955 · S/N 31826N9428GSecond Wind Aviation Corp · Friday Harbor, WABuilt 1970 · S/N U20601628N94292My Way Aviation LLC · Weston, FLBuilt 1982 · S/N 15285643N9429CLanham Rex E Jr · Boise, IDBuilt 1955 · S/N 31827N9429UTangleport LLC · Amarillo, TXBuilt 1976 · S/N 15078377N9429XWorld Missions Outreach · Brownsville, TXBuilt 1985 · S/N 18268521N942AZAz2025 LLC · Miami, FLS/N 17276530N942JMPogany Steve C · Chugiak, AKBuilt 1976 · S/N U20603365N942SAWalker John A · Kotzebue, AKS/N TU2060553N942SMMackie Jonathan M · Manistique, MIBuilt 1969 · S/N T210-0416N942XAClymer Jordan · Cape Canaveral, FLS/N 15070510N94303Nelson Ryan L · League City, TXBuilt 1978 · S/N 18266404N94304Hamilton Francis D III · Olney, TXBuilt 1978 · S/N 18266405N9430BFuture Flyers Of Connecticut LLC · Simsbury, CTBuilt 1958 · S/N 55230N9430CRoberts Creek Holdings LLC · Bakersfield, CABuilt 1955 · S/N 31828N9430MKruschwitz David A · Anchorage, AKBuilt 1974 · S/N 15075669N9430TRmb Leasing Inc · Dover, DEBuilt 1960 · S/N 57230N9431MMeridian Airport Authority · Meridian, MSBuilt 1976 · S/N 18264752N9431XShives Investments LLC · Zavalla, TXBuilt 1985 · S/N 18268523
Back to AD 87-20-03 R2