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.

N8173FJohnson Jacob A · Shawnee, OKS/N 15064273N8174FRangefinder Aviation LLC · Fort Collins, COS/N 15064274N8175SAnderson Marcus D · Memphis, TNBuilt 1965 · S/N 15061775N8175VTaylor Charles G · Knoxville, TNBuilt 1974 · S/N A1500555N8177FLong Steven J · Amery, WIBuilt 1966 · S/N 15064277N8179SOllantair LLC · Chicago, ILBuilt 1965 · S/N 15061779N818High Alpha Airshows LLC · Santa Rosa Valley, CABuilt 1968 · S/N 15069651N8181SCopeland Kevin D · Vidalia, GABuilt 1965 · S/N 15061781N8183FArvizu Jason Arthur Scott · Bakersfield, CABuilt 1966 · S/N 15064283N8185SJanssen Christopher M · Manchester, IABuilt 1965 · S/N 15061785N8185VCryan Mark · Port Orange, FLBuilt 1974 · S/N A1500557N8187FCoady Michael J · Taylorville, ILBuilt 1966 · S/N 15064287N8187SCounter Kevin · Windsor, CAS/N 15061787N8187VNelson Brett R · Shoreview, MNBuilt 1974 · S/N A1500559N8189FArchuleta Michelle L · Las Cruces, NMBuilt 1973 · S/N A1500455N818MLTurning Point Northwest LLC · Stanwood, WABuilt 1966 · S/N 15064017N818TSlipstream Aviation LLC · Carrollton, GAS/N 15283216N8191FMoore Clayton P · Cayce, SCBuilt 1966 · S/N 15064291N8191SStang Daniel Jr · Lindale, TXBuilt 1965 · S/N 15061791N8193FMother Lode Flying Club · San Andreas, CABuilt 1966 · S/N 15064293N8193SVoshell Frank T · Freeport, MIBuilt 1965 · S/N 15061793N8193UClark Jason · West Valley City, UTBuilt 1976 · S/N 15077908N8195SMolina Manolo R · Fayetteville, ARBuilt 1965 · S/N 15061795N8195VHigh View Air LLC · Driftwood, TXBuilt 1974 · S/N A1500564N81963Larson Wayne M · Plymouth, MNBuilt 1966 · S/N 15063608N8197FHartman Eric J · Wilson, NYBuilt 1966 · S/N 15064297N8198FDesterfans Lance · Lodi, CAS/N 15064298N8198SHhd Aviation LLC · Hamilton, OHS/N 15061798N819EBWalker Kyle V · Bastrop, TXBuilt 1966 · S/N 15063984N8200FCallanan Craig E · Stillwater, NJBuilt 1966 · S/N 15064300N8200SPoms Maxfield David · Groveland, CABuilt 1965 · S/N 15061800N8201FYellott Jerry L Jr · Dequincy, LABuilt 1966 · S/N 15064301N8201SMann Derek W · Burwell, NEBuilt 1965 · S/N 15061801N8202F98x LLC · Caddo Mills, TXBuilt 1966 · S/N 15064302N8202SBell Tammy L · San Antonio, TXS/N 15061802N8205FRegistered aircraftBuilt 1966 · S/N 15064305N8205SMckay Christopher · Point Arena, CAS/N 15061805N8207BBodin Logan T · Lake Charles, LAS/N 15069004N8207FChantry Terrell A · Lake Havasu City, AZFirst renewal noticeBuilt 1966 · S/N 15064307N820MPPrice Michael Wade · Elkton, VABuilt 1975 · S/N 15076861N820STTwente Ron K · Saint Peters, MOBuilt 1976 · S/N 15078376N8213SMcilrath Paul J · Des Moines, IABuilt 1965 · S/N 15061813N8214FHoneycutt David · Columbus, MSBuilt 1966 · S/N 15064314N8218FDel Rosario Jose · Hackettstown, NJBuilt 1966 · S/N 15064318N8219FKietzer Tyler L · Mankato, MNS/N 15064319N8220SHammack Lindsey M · Westlake, TXBuilt 1965 · S/N 15061820N8221FSale Reported · Eau Claire, MISale reportedBuilt 1966 · S/N 15064321N8223FSoderman David W · Gilby, NDBuilt 1966 · S/N 15064323N8223SRedditt William L · Erie, PABuilt 1965 · S/N 15061823N8224FDiamond David Z · Wrentham, MABuilt 1966 · S/N 15064324
Back to AD 2009-10-09 R2