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.

N49123Ascend Aviation LLC · Bountiful, UTBuilt 1977 · S/N 15281152N49125Morey Airplane Co Inc · Middleton, WIBuilt 1979 · S/N 15283426N49126Flight Expo Inc · Princeton, MNS/N 15283427N49127Schaefer B C · Fairfield, TXS/N 15281154N49138Osborn Scott R · Rch Palos Vrd, CABuilt 1979 · S/N 15283430N49142Zion Summit Holdings LLC · Wesley Chapel, FLBuilt 1977 · S/N 15281161N49144Westfall Benjamin C · Coeur D Alene, IDBuilt 1977 · S/N 15281163N49150Skytrain Aviation LLC · Sumner, ILS/N 15281167N49151Zhang Victoria · Daytona Beach, FLBuilt 1979 · S/N 15283432N49159Comer Jacob W · Troy, MOBuilt 1977 · S/N 15281172N4915PAubry Nicolas L · Port Jefferson, NYBuilt 1981 · S/N 15284840N49161Rohan Gerard K Sr · Marion, WIBuilt 1978 · S/N 15281174N49164Wohali Aviation LLC · Monroe, GAS/N 15281176N49185New Horizon Aviation Inc · Warwick, RIS/N 15283435N49189Anderson Seth A · Buckeye, AZS/N 15281182N4918HMarks Aviation Corp · Beverly Hills, CABuilt 1979 · S/N 15284020N49191Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1977 · S/N 15281184N49194Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1977 · S/N 15281186N49197Wilt Aviation Consulting LLC · Sebastian, FLBuilt 1977 · S/N 15281188N49199Wygant Amanda N · Copper Center, AKBuilt 1977 · S/N 15281189N4919PRiggs Charles A · Pembroke Pines, FLBuilt 1981 · S/N 15284841N49202Skylogix Aircraft LLC · La Verne, CABuilt 1977 · S/N 15281191N49215Dukelow Thomas W · Bad Axe, MIBuilt 1979 · S/N 15283437N49226Parrish Aviation Flight Academy LLC · Southlake, TXBuilt 1979 · S/N 15283439N4922BAvcorp Holdings Inc · Jackson, MIBuilt 1979 · S/N 15283706N49230US Flight Academy International Inc DBA · Post, TXBuilt 1977 · S/N 15281205N49249Krawczak Kyle C · Littleton, COBuilt 1979 · S/N 15283442N49260Youth Aeronautics Education Foundation · Mattaponi, VABuilt 1977 · S/N 15281209N49261Salem Oregon Flight Training LLC · Salem, ORBuilt 1977 · S/N 15281210N49268Fox John E · Boonville, CABuilt 1977 · S/N 15281213N49276Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1977 · S/N 15281217N4927BAviation Capital Management LLC · San Jose, CABuilt 1979 · S/N 15283709N49285Fullerton Airport Pilot Association · Fullerton, CABuilt 1979 · S/N 15283445N49288Wisconsin Aviation Inc · Watertown, WIBuilt 1977 · S/N 15281226N4928BWings Over Texas Holdings LLC · Denton, TXBuilt 1979 · S/N 15283710N49292Johnson Scott W · Saline, MIS/N 15283446N4930BSkyranch Knoxville Youth Inc · Knoxville, TNS/N 15283712N4931BWojtowicz Tomasz · Bronx, NYBuilt 1979 · S/N 15283713N49328Air Puerto Rico Corp · Aguadilla, PRFirst renewal noticeBuilt 1979 · S/N 15283448N49341Dale Michael E · Murrieta, CABuilt 1979 · S/N 15283449N4937PMorcom Aviation Services Inc · Everett, WABuilt 1981 · S/N 15284849N4938HAir Poueir LLC · Amarillo, TXBuilt 1979 · S/N 15284033N49404Central Virginia Aviation Inc · North Dinwiddie, VABuilt 1977 · S/N 15281240N49417Rich John E · Dunnellon, FLS/N 15281248N49419Ds Flight Services LLC · Battle Ground, WAS/N 15281250N49423Johnson Shem E · Bonners Ferry, IDBuilt 1978 · S/N 15281254N49424Xin Han Aviation LLC · Atwater, CABuilt 1978 · S/N 15281255N4942HFlorida Flyers Flight Academy Inc · Saint Augustine, FLBuilt 1979 · S/N 15284036N49432Northshore Group LLC · Wilmington, DEBuilt 1978 · S/N 15281262N49434California In Nice Inc · San Jose, CABuilt 1979 · S/N 15283458
Back to AD 2009-10-09 R2