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.

N704RMHarwood F Douglas · Hartford, NYBuilt 1976 · S/N 15078814N704RPGreenstein Jeffrey P · Centennial, COBuilt 1976 · S/N 15078816N704RQBilbrey Todd B · Tulsa, OKBuilt 1976 · S/N 15078817N704RSBreaking Ground Ministries Inc · Fayetteville, ARBuilt 1976 · S/N 15078819N704RVPalmer Don W · Penhook, VABuilt 1976 · S/N 15078822N704RYBoeing Employees Flg Assoc Inc · Renton, WABuilt 1976 · S/N 15078825N704SEMichler Jon D · Jasper, TXS/N 15078831N704SJBellas Business LLC · Kalispell, MTBuilt 1976 · S/N 15078835N704SLPhelps Clay DBA · Santa Paula, CABuilt 1976 · S/N 15078837N704SSFatell David Aaron · Ottawa Lake, MIBuilt 1976 · S/N 15078843N704SUWeiser Leonard · Westminster, MABuilt 1976 · S/N 15078845N704SXPropeller Enterprises LLC · Gilbert, AZBuilt 1976 · S/N 15078847N704SYMiller Dale R · Highland, ILBuilt 1976 · S/N 15078848N704TDFlight Gear Aviation LLC · Pickerington, OHS/N 15078853N704THCalderon Ed · Tracy, CABuilt 1976 · S/N 15078857N704TMZubrod John W · Ebony, VABuilt 1976 · S/N 15078861N704TQDolphin Capital LLC · Brooksville, FLS/N 15078864N704TUFilkins Randy A · Wellsburg, WVBuilt 1976 · S/N 15078868N704TVStrickland Kenneth Louis · Cary, NCBuilt 1976 · S/N 15078869N704TXGenna Vito V Jr · Newfield, NJBuilt 1976 · S/N 15078871N704TZBrekke Ryan · Edmore, NDBuilt 1976 · S/N 15078873N704UAPrince John R · West Chester, OHBuilt 1976 · S/N 15078874N704UCFirst South Partners Inc · Melbourne Beach, FLBuilt 1976 · S/N 15078876N704UDDavis Norman E · Dunnellon, FLBuilt 1976 · S/N 15078877N704UEWillpower Aviation LLC · Litchfield Park, AZBuilt 1976 · S/N 15078878N704UFKimani Derrick M · Panorama Village, TXBuilt 1976 · S/N 15078879N704UHCappiello Robert M · Santa Clarita, CAS/N 15078881N704UPHayenga Sandra A · Granbury, TXBuilt 1976 · S/N 15078887N704URWalker Richard D · Houston, TXBuilt 1976 · S/N 15078889N704UTCp Aviation Inc · Santa Paula, CABuilt 1976 · S/N 15078891N704UWJahawk Leasing LLC · Sugar Grove, ILBuilt 1976 · S/N 15078894N704UXHlavac Mathew B · Ramona, CABuilt 1976 · S/N 15078895N704UYTotal Aircraft Service Inc · Sherwood, ARBuilt 1976 · S/N 15078896N704VFRegistered aircraftS/N 15078903N704VLHattayer John M · Plainfield, CTBuilt 1976 · S/N 15078908N704VMRegistration Pending · Navarre, FLRegistration pendingBuilt 1976 · S/N 15078909N704VTNye Andre Marcus · Naples, FLS/N 15078914N704VUBlue Raven Aviation LLC · Anderson, SCBuilt 1976 · S/N 15078915N704VYPiryk Christopher M · Ocklawaha, FLBuilt 1976 · S/N 15078919N704WBEyster Christian Charles · Sweetwater, TNBuilt 1976 · S/N 15078922N704WCLegacy Pilot Training LLC · Annandale, MNS/N 15078923N704WDMcdonald David R · Duluth, MNBuilt 1976 · S/N 15078924N704WFFoxtrot Flight Training LLC · Berrien Springs, MIBuilt 1976 · S/N 15078926N704WHEvanson Scot A · Monroe, TNBuilt 1976 · S/N 15078928N704WNN704wn LLC · Panama City, FLBuilt 1976 · S/N 15078933N704WRGroves Malcolm Duane · Spring Hill, FLBuilt 1976 · S/N 15078936N704WTRodriguez Oswaldo · Tifton, GABuilt 1976 · S/N 15078938N704WUWalker James O · Lovell, WYBuilt 1976 · S/N 15078939N704WWLay Lawrence W · Douglass, KSBuilt 1976 · S/N 15078941N704XBSivert Leslie A · Richmond, VABuilt 1976 · S/N 15078946
Back to AD 2009-10-09 R2