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.

N50138Kalb Brian A · Mechanicsburg, OHBuilt 1968 · S/N 15069083N50140Air Devices Company LLC · Alpena, MIS/N 15069084N50146Aero Sceince International LLC · Martinez, GABuilt 1968 · S/N 15069089N50150Above All Aviation Inc · Santa Barbara, CABuilt 1968 · S/N 15069092N50151Thums April M · Murfreesboro, TNBuilt 1968 · S/N 15069093N50155Haupricht Andy C · Sanford, NCBuilt 1968 · S/N 15069097N50156Humanic Thomas J · Columbus, OHBuilt 1968 · S/N 15069098N50160Morales-Escareno Rogelio · San Diego, CAS/N 15069102N50170Moroney Aviation LLC · Chugiak, AKBuilt 1968 · S/N 15069106N50171Evans Mark E · Heber Springs, ARS/N 15069107N50177Dudley Lee B · Passadumkeag, MEBuilt 1968 · S/N 15069110N50180Robbins Richard T · Ketchikan, AKS/N 15069112N50181Debelius Enemark Peter C · Crawfordville, FLBuilt 1968 · S/N 15069113N50184Wietecha Jack · Millington, ILBuilt 1968 · S/N 15069115N50188Ryburn Michael D · Basehor, KSBuilt 1968 · S/N 15069119N50194Brouillette Jakob D · Daleville, ALS/N 15069124N501PAChapman Anthony J · Henderson, NVBuilt 1975 · S/N 15077482N501WAFerrari Jason M · Medina, OHBuilt 1975 · S/N 15076640N50201Ahrens Brian T · Hainesport, NJBuilt 1968 · S/N 15069131N50202Velasquez Jorge · Brawley, CABuilt 1968 · S/N 15069132N50205Spruce Moose LLC · Salt Lake City, UTS/N 15069135N50209N Maple LLC · Kalispell, MTBuilt 1968 · S/N 15069139N50213Canarr Randall J · Anchorage, AKS/N 15069141N50219Sftb LLC · Miami, FLBuilt 1968 · S/N 15069145N50221Smith Wayne A · Uxbridge, MABuilt 1968 · S/N 15069146N50222Baldwin Kevin R · San Tan Valley, AZBuilt 1968 · S/N 15069147N50224Reshetar Ryan D · Evansville, INBuilt 1968 · S/N 15069149N50231Aaronflight LLC · Hillsboro, ORBuilt 1968 · S/N 15069153N50232Firby John E · Diamond, OHBuilt 1968 · S/N 15069154N50234Lloyd Barry C · Sacramento, CABuilt 1968 · S/N 15069156N50245Christian Martha J · Ham Lake, MNBuilt 1968 · S/N 15069163N50251Featherston Nicholas L · Chandler, AZBuilt 1968 · S/N 15069167N50252Price Benjamin A · Hattiesburg, MSBuilt 1968 · S/N 15069168N50255Andrews Michael E · Huron, OHBuilt 1968 · S/N 15069170N50258Willis Walter W · Kamiah, IDS/N 15069172N50261Copeland Joey A · Douglas, GABuilt 1968 · S/N 15069174N50262Garrison Vincent Gray · Yadkinville, NCBuilt 1968 · S/N 15069175N50263Registered aircraftBuilt 1968 · S/N 15069176N50266Plentl Steve R · Shepherd, TXBuilt 1968 · S/N 15069179N50267Buckner Natasha · Locust Grove, VABuilt 1968 · S/N 15069180N50268Mach Steven William · Chicago, ILBuilt 1968 · S/N 15069181N50269Joerger Dannie L · Greensburg, INBuilt 1968 · S/N 15069182N50270Flanagan Elizabeth M · Coronado, CABuilt 1968 · S/N 15069183N50274Currie William O · Lumberton, NCBuilt 1968 · S/N 15069186N50276Pense Richard L · Katy, TXBuilt 1968 · S/N 15069188N50283Sanchez Oscar A Blanco · Portsmouth, VAS/N 15069194N50284Dunaire LLC · Mechanicsburg, PABuilt 1968 · S/N 15069195N50286Baue Michael G · Foristell, MOBuilt 1968 · S/N 15069197N50292Wheeler Richard Edmond III · Norfolk, VABuilt 1968 · S/N 15069201N50297Eddleston Ryan · Winter Haven, FLBuilt 1968 · S/N 15069206
Back to AD 2009-10-09 R2