Skip to content

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

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

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.

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

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N60624Ketter Kevin M · Bloomington, MNBuilt 1969 · S/N 15070456 N60628Aukeman Mark C · Georgetown, MEBuilt 1969 · S/N 15070460 N60630Bichell Kevin C · Corsicana, TXBuilt 1969 · S/N 15070461 N60632Lawlyes Bill · Aguanga, CABuilt 1969 · S/N 15070463 N60633Newby Terry · Kokomo, INBuilt 1969 · S/N 15070464 N60639International Air Services Inc Trustee · Carson City, NVBuilt 1969 · S/N 15070468 N60640Lazarus Benjamin · Blaine, WAS/N 15070469 N60641Motory Group LLC · Alachua, FLBuilt 1969 · S/N 15070470 N60649Anglin Cheryl L · Jackson, MSFirst renewal noticeBuilt 1969 · S/N 15070477 N6064JTreger Mark · Dallas, TXFirst renewal noticeBuilt 1972 · S/N A1500364 N60650St Arneault Carmen M · Milton, NHBuilt 1969 · S/N 15070478 N60652Broughton Stanley K · Salt Lick, KYBuilt 1969 · S/N 15070479 N60653Russo Joseph M · Pleasant Grove, CABuilt 1969 · S/N 15070480 N6065JBrown Charles A · Boise, IDBuilt 1972 · S/N A1500365 N6065KMiller Durwood B · Screven, GABuilt 1975 · S/N 15077505 N6066GGisselman Scott D · Lago Vista, TXBuilt 1969 · S/N 15071566 N60672Johnson Jeffry L · Eufaula, OKS/N 15070491 N6067GWildroot Aviation LLC · Bellingham, WABuilt 1969 · S/N 15071567 N6067JSale Reported · Ephrata, WASale reportedBuilt 1972 · S/N A1500367 N60681Hendrickson Robert T · Galesburg, ILS/N 15070496 N60682Sweeney Andrew H · Murray, KYBuilt 1969 · S/N 15070497 N60684Gunnarsson Elliott Gudni · Concrete, WABuilt 1969 · S/N 15070499 N60685Barton Steven Lewis · Ventura, CABuilt 1969 · S/N 15070500 N60687Luse Benjamin T · Newalla, OKBuilt 1969 · S/N 15070501 N6068GWilliams Daniel E Jr · Morehead City, NCS/N 15071568 N60693Conaway David J · Orange Park, FLBuilt 1969 · S/N 15070506 N60694Hodgkinson David · Tolland, CTBuilt 1969 · S/N 15070507 N606GSHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1979 · S/N 15284058 N606JCAsencio Garcia Enrique R · Fort Worth, TXBuilt 1976 · S/N 15078753 N60701Nichols Daniel H · Helen, GAFirst renewal noticeBuilt 1969 · S/N 15070511 N60704Discover Aviation LLC · Unionville, MOS/N 15070512 N60708Registration Pending · Wentworth, MORegistration pendingS/N 15070515 N6070GSimpson Michael · Chateaugay, NYBuilt 1969 · S/N 15071570 N60714Yoder Frederick David · Wellington, FLBuilt 1969 · S/N 15070520 N60716Evans Michael J · Greenville, MIBuilt 1969 · S/N 15070522 N6071KBlumhagen Myron M · Drake, NDBuilt 1975 · S/N 15077509 N60720Sedlak Christopher T · Lake City, FLBuilt 1969 · S/N 15070526 N60725Mcghie Kraig J · Sterling, AKS/N 15070527 N60729Parry Peter S · New Kent, VABuilt 1969 · S/N 15070530 N60735Ozarks Technical Community College · Springfield, MOBuilt 1969 · S/N 15070535 N60738Long William E · Old Town, FLBuilt 1969 · S/N 15070537 N60742Greene Daniel W · Somerton, AZBuilt 1969 · S/N 15070539 N60743Cowart Frederic D · Baytown, TXBuilt 1969 · S/N 15070540 N60748Flawless Aviation LLC · Loxahatchee, FLS/N 15070544 N60749Frazier Brian D · Jackson, MSBuilt 1969 · S/N 15070545 N60756Vanjara Obaid U · San Ramon, CABuilt 1969 · S/N 15070551 N60757Follman Aviation LLC · Waterport, NYBuilt 1969 · S/N 15070552 N6075GTango Aviation Rentals LLC · Austin, TXBuilt 1969 · S/N 15071575 N6075JLowrance Kathleen C · Plano, TXBuilt 1972 · S/N A1500375 N60761Code 1 Flight Training LLC · Canton, TXS/N 15070556

Back to AD 2009-10-09 R2