OpenAirDocs.org
AD 2009-10-09 R2

Registered aircraft · 8,565

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:2009-10-09-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:2009-10-09-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.

N8124FMurray Mark J · Georgetown, GABuilt 1966 · S/N 15064224N8125STucker William F · Booneville, ARS/N 15061725N8126FWhite Guy B · Waxahachie, TXS/N 15064226N8126SSun Valley Aviation Inc · Harlingen, TXBuilt 1965 · S/N 15061726N8128FShowers Gregory S · Williamstown, PABuilt 1966 · S/N 15064228N8128SLawrence Jason C · Tecumseh, MIBuilt 1965 · S/N 15061728N8129FHigh Exposure Inc · Wilmington, DEBuilt 1966 · S/N 15064229N8131LGerber Aviation LLC · Winter Haven, FLBuilt 1971 · S/N 15072534N8132SHarris Gregory A · Aurora, COBuilt 1965 · S/N 15061732N8133FMagarian Mitchell · Jacksonville, FLBuilt 1966 · S/N 15064233N8133UDunaire LLC · Mechanicsburg, PAS/N 15077897N8134FHammond Steven R · Trenton, MOBuilt 1966 · S/N 15064234N8135SMcjunkin John Michael · Portland, ORRegistration revokedBuilt 1965 · S/N 15061735N8136FRawson Aviation LLC · Ardmore, OKBuilt 1966 · S/N 15064236N8136SPockrus Pat B · Mineral Wells, TXS/N 15061736N8138LN8138l LLC · Metairie, LABuilt 1978 · S/N A1520828N8138UBurner Dwight L · Mc Gaheysville, VABuilt 1976 · S/N 15077899N8139USemanskee Grant W · Snohomish, WABuilt 1976 · S/N 15077900N8141SRegistration Pending · La Porte, TXRegistration pendingBuilt 1965 · S/N 15061741N8142SRebich Jason F · Overton, NVBuilt 1965 · S/N 15061742N8142VKing Kevin J · Angle Inlet, MNBuilt 1974 · S/N A1500538N8143SElite Aeronautics LLC · Carolina, PRBuilt 1965 · S/N 15061743N8143VCenterline Holdings Inc · Camden, DEBuilt 1974 · S/N A1500539N8144SRegistered aircraftBuilt 1965 · S/N 15061744N8144UHansen Kermit E · Ryder, NDBuilt 1976 · S/N 15077901N8144VLundahl Frederick B · Langley, WABuilt 1974 · S/N A1500540N8145SBissat Rishid H · Visalia, CABuilt 1965 · S/N 15061745N8146VAnthony Michael L · Sanger, TXBuilt 1974 · S/N A1500541N8147SHoehn Ronald T · Perryville, MOS/N 15061747N8151FMitchell John F · Shannon, ILBuilt 1966 · S/N 15064251N8152VBrowning Lonnie O IV · Allendale, SCBuilt 1974 · S/N A1500543N8153SBelli Tony G · Huron, OHBuilt 1965 · S/N 15061753N8154FWilson Gary L · Levant, MES/N 15064254N8155FJapundza Bob · Kokomo, INBuilt 1966 · S/N 15064255N8155SSale Reported · Cherry Valley, CASale reportedS/N 15061755N8156FKindlon Aviation Inc · Glenmont, NYBuilt 1966 · S/N 15064256N8156SPyanov Mark · Clinton, MSS/N 15061756N8157SAntal Frank Jr · Delta, COBuilt 1965 · S/N 15061757N8160FRydell Leonard A · Newberg, ORBuilt 1966 · S/N 15064260N8162FWeishuhn Charlie D · La Grange, TXBuilt 1966 · S/N 15064262N8162MMeggers Darin R · Baker, MTBuilt 1972 · S/N 15073212N8165FMoat William A · Braselton, GAS/N 15064265N8165SDickey Jenni M · Willow, AKBuilt 1965 · S/N 15061765N8166FHassan Nabil Ibrahim · Victorville, CABuilt 1966 · S/N 15064266N8167SReid Bryce · Oklahoma City, OKBuilt 1965 · S/N 15061767N8168USale Reported · Three Rivers, MISale reportedBuilt 1976 · S/N 15077905N8169FRegistration Pending · Parker, KSRegistration pendingBuilt 1966 · S/N 15064269N8171SLeavitt Adam · Boulder City, NVS/N 15061771N8172FButler Donald S · Oak Ridge, NCBuilt 1966 · S/N 15064272N8172VStanford Jay J · Kingsland, GAS/N A1500553
Back to AD 2009-10-09 R2