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.

N8708SHall Tyler D · Citrus Heights, CAS/N 15062008N8710SKressin Ray H · Waunakee, WIBuilt 1965 · S/N 15062010N8711GBonno Douglas L · Iron River, MIBuilt 1966 · S/N 15062811N8712SMarys Airport Acres LLC · Neenah, WIBuilt 1965 · S/N 15062012N8715SAllen Thomas Page · Comer, GABuilt 1965 · S/N 15062015N8716SBores Scott J · Huron, OHS/N 15062016N8719GRosso Anthony J · Wallace, NCS/N 15062819N8721SPruden Larry J · Louise, MSBuilt 1965 · S/N 15062021N8723GEastham Gregory L · Columbia, KYBuilt 1966 · S/N 15062823N8723SCondor Aviation LLC · South Saint Paul, MNBuilt 1965 · S/N 15062023N8724URonald O Holcomb LLC · Lapeer, MIBuilt 1976 · S/N 15077974N8725SKolis Joseph E II · Springfield, ILBuilt 1965 · S/N 15062025N8726GJacks Benjamin Scott · Chanute, KSBuilt 1966 · S/N 15062826N8727GJstream Lc · Sheridan, WYBuilt 1966 · S/N 15062827N8727SMejia Jose Patricio · Meridian, IDBuilt 1965 · S/N 15062027N8730SDederer Laura · Valencia, PAS/N 15062030N8730UKachalsky Alan N · Rye, NYBuilt 1976 · S/N 15077975N8731GCard James D · Mc Cool, MSBuilt 1966 · S/N 15062831N8731SLawrenz Richard A · Mcpherson, KSS/N 15062031N8731USemet Marva S · Seattle, WABuilt 1976 · S/N 15077976N8732GPerkins Robert A · New Richmond, WIBuilt 1966 · S/N 15062832N8736GSantana Amaury · Winter Haven, FLBuilt 1966 · S/N 15062836N8738URhk Of Kansas · Jefferson City, MOBuilt 1976 · S/N 15077977N8739GKlott William D · Morris, ILBuilt 1966 · S/N 15062839N8740SBucks Flight Academy LLC · Cashion, OKS/N 15062040N8741GDahlberg James C · Ogilvie, MNS/N 15062841N8741SJohnson Zachary R · Burien, WABuilt 1965 · S/N 15062041N8742GReeve Howard E · Minot, NDS/N 15062842N8744SZiegler Jeffery A · Crescent Springs, KYBuilt 1965 · S/N 15062044N8745GWildcat Aviation LLC · Schoolcraft, MIBuilt 1966 · S/N 15062845N8747SEast County Communications Inc · Hurricane, UTBuilt 1965 · S/N 15062047N8747URegistration Pending · Indio, CARegistration pendingBuilt 1976 · S/N 15077978N8748SJones Joel K · Summer Shade, KYBuilt 1965 · S/N 15062048N8749SHart Richard G · Stoneham, MABuilt 1965 · S/N 15062049N8750GMoe Charles E · Rosebud, SDBuilt 1966 · S/N 15062850N8750SStarcher Paul E · Las Vegas, NVBuilt 1965 · S/N 15062050N8751GCrotts Joseph D · Mocksville, NCBuilt 1966 · S/N 15062851N8751SMorris Jeffery S · Ukiah, CABuilt 1966 · S/N 15062051N8755UDouglas-Carter Tammi A · Greenville, KYBuilt 1976 · S/N 15077980N8757SManna Anthony G · Hanover, MABuilt 1965 · S/N 15062057N8759SCrowell Jeremy M · Arlington, WABuilt 1965 · S/N 15062059N875MAGould Norman L Jr · Saunderstown, RIBuilt 1967 · S/N 15067754N8760UReid Gary M · Medford, ORS/N 15077982N8763GElliott Norman C · Stillwater, OKBuilt 1966 · S/N 15062863N8763SClinton Richard C · Fair Oaks, CAS/N 15062063N8764GStrait Media LLC · Anchorage, AKS/N 15062864N8765URebel Metals LLC · Croydon, NHBuilt 1976 · S/N 15077983N8766GGascho Wendell M · Bridgewater, VABuilt 1966 · S/N 15062866N8769GHeli Thrills LLC · Wills Point, TXBuilt 1966 · S/N 15062869N8771SGillette Robin A · Scio, ORS/N 15062071
Back to AD 2009-10-09 R2