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.

N4049JWashington Aero Club Inc · South Park, PAS/N 15065349N4049VJustin William R · Sauk Rapids, MNBuilt 1975 · S/N 15076685N4055JStrobel Oliver K · Fishers, INBuilt 1966 · S/N 15065355N4057JTurner Jeremy A · Rancho Murieta, CABuilt 1966 · S/N 15065357N40583Grald Jonathan A · New Hampton, NYS/N 15065358N4060JDooley Bob A · Alexander, ARFirst renewal noticeBuilt 1966 · S/N 15065360N4061JConley Rocky · Swanton, OHS/N 15065361N4063JPoules Alexander · Hope Valley, RIBuilt 1966 · S/N 15065363N4065VStiletto Beaver Touchdown LLC · Evanston, ILBuilt 1975 · S/N 15076689N4067JSkyway Inc · Wilmington, DEBuilt 1966 · S/N 15065367N4068JSutton Thomas A · Gaylord, MIBuilt 1966 · S/N 15065368N4069JFdp Productions LLC · Atlanta, GABuilt 1966 · S/N 15065369N4070JClark Philip M · Caldwell, OHBuilt 1966 · S/N 15065370N4071JMilhous Walter L · Carmichael, CABuilt 1966 · S/N 15065371N4075JB&R Aircraft LLC · Wadsworth, OHBuilt 1966 · S/N 15065375N4076VPennington Charles A · Fort Smith, ARBuilt 1975 · S/N 15076691N4081VLark Thomas S · Coppell, TXBuilt 1975 · S/N 15076694N4086JBell Robert A Jr · Scotland Neck, NCBuilt 1966 · S/N 15065386N4086VBoyd Darrell M · Claremore, OKBuilt 1975 · S/N 15076695N4088JLampasona Brendan T · Citrus Springs, FLBuilt 1966 · S/N 15065388N4088VSlezak Daniel S · Santa Margarita, CABuilt 1975 · S/N 15076696N4092VGroves Donald L · Butler, PABuilt 1975 · S/N 15076697N4093JGarcia Joseph Donald · Okeana, OHS/N 15065393N4094JSquires Janis R · Amherst, OHBuilt 1966 · S/N 15065394N4095JParks Richard C · Salem, MOBuilt 1966 · S/N 15065395N4098JFrench Darrell L · Easton, MDS/N 15065398N40HFVogel Essex Nathaniel B · Berkeley, CAS/N 15072309N40WLBentley Thomas F · Lockport, ILBuilt 1976 · S/N 15078056N4100VSanders Keith · Palm Bay, FLS/N 15076701N4103A501st Flight Solutions LLC · Kaysville, UTBuilt 1966 · S/N 15063859N4103VMoore Israel · Pasco, WABuilt 1975 · S/N 15076702N4115FHogan Darrel R · Ash Grove, MOBuilt 1972 · S/N 15074003N412CDOppegard Nicholas D · Eagle River, AKBuilt 1967 · S/N 15067488N417CBWings Over L A Aviation LLC · West Hills, CAS/N 15281010N419CALind William · Los Angeles, CAS/N 15069273N41WPSale Reported · Copper Center, AKSale reported, pending cancellationS/N 15068019N420WWFlying Colors Airparts Inc · Leesburg, FLS/N 15069243N4224HWharton William R Jr · Dresden, OHBuilt 1978 · S/N 152-80324N422JPWings Over Texas Holdings LLC · Denton, TXBuilt 1980 · S/N 15284589N424MKMkt Aviation LLC · Mankato, MNBuilt 1978 · S/N 15281808N425MKNorth Star Aviation Inc · Mankato, MNBuilt 1977 · S/N 15280650N4265CHunt Delbert O · Dillon, MTBuilt 1968 · S/N 15068178N426XARound Engine Aero · Nashville, MIS/N 15063198N4278LIron Compass Aviation LLC · Gallatin, TNBuilt 1978 · S/N 15281218N427JWDyer Ray R · Kalispell, MTBuilt 1972 · S/N 15073873N428HCNott Terry · Overland Park, KSBuilt 1979 · S/N 15283916N4291WN4291w LLC · Orlando, FLBuilt 1969 · S/N 15071397N431DKrause Derris O · Cumberland, MDS/N 15066583N432ZADunbar Stephen E Trustee · Broken Arrow, OKS/N 15073805N434CBYates David M · Haysi, VABuilt 1972 · S/N 15074214
Back to AD 2009-10-09 R2