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.

N50299Wood Thomas J · Overland Park, KSBuilt 1968 · S/N 15069208 N502KWWhite Kenneth E · Lakeland, FLBuilt 1976 · S/N 15079064 N502RKKuehne Tracy · Pensacola, FLBuilt 1973 · S/N 15075370 N50304Reuben Abraham · Flushing, NYBuilt 1968 · S/N 15069211 N50308Villano Frank P · Wappingers Falls, NYBuilt 1968 · S/N 15069215 N50310Richards Lyle · San Diego, CABuilt 1968 · S/N 15069217 N50311Khamo Josef · Running Springs, CABuilt 1968 · S/N 15069218 N50316Foster Reynolds Sw · Winona, MNBuilt 1968 · S/N 15069222 N50318Florida Fast Boats LLC · Palm Coast, FLBuilt 1968 · S/N 15069224 N50323Got Valentin L · Olivehurst, CAFirst renewal noticeS/N 15069228 N50326Thompson Arthur W · Paris, TXBuilt 1968 · S/N 15069229 N50328Neiger Steven · Ocean View, NJBuilt 1968 · S/N 15069231 N50331Sale Reported · Nashotah, WISale reportedBuilt 1968 · S/N 15069233 N50335Joung Kweon · Cumming, GABuilt 1968 · S/N 15069235 N50337Nava Alfred Joseph II · Gig Harbor, WABuilt 1968 · S/N 15069236 N50345Stanley345 LLC · Esko, MNS/N 15069242 N50347Garrett Dennis R · Hudson, FLS/N 15069244 N50354N50354 LLC · Key West, FLBuilt 1968 · S/N 15069249 N50355Kurpgeweit William E · Ewing, NEBuilt 1968 · S/N 15069250 N50356Meyers Meade M · Rockwood, PABuilt 1968 · S/N 15069251 N50367American Sky Aviation LLC · Anna, TXBuilt 1968 · S/N 15069255 N50368Rogers Warren R · Manti, UTS/N 15069256 N50375Mcburney Cleland V · Kingman, KSBuilt 1968 · S/N 15069260 N50379Grosdidier Rolland J · Kenai, AKBuilt 1968 · S/N 15069263 N50382Eastside Aero Inc · Eatonville, WABuilt 1968 · S/N 15069264 N50390Dillard Clayton B · Talkeetna, AKBuilt 1968 · S/N 15069269 N503SDSimmons Mark · Madison, MSFirst renewal noticeBuilt 1974 · S/N 15076056 N503TCForetich Joseph J · Baker, LAS/N 15069261 N50400Bostick Alva D H · Portsmouth, OHBuilt 1968 · S/N 15069274 N50403Reis Gavin · Conway, SCS/N 15069277 N50404Mcflight Aviation LLC · Highland, UTBuilt 1968 · S/N 15069278 N50405Und Aerospace Foundation · Grand Forks, NDBuilt 1968 · S/N 15069279 N50406Aeroplanes Over Idaho Inc · Carson City, NVS/N 15069280 N50407Coombs Kevin A · Knoxville, TNS/N 15069281 N50413Rafi Adnan · Olean, NYS/N 15069286 N50418Forrest City Aircraft Club · Rockton, ILS/N 15069289 N50419Hamilton Richard Paul · Laredo, TXBuilt 1968 · S/N 15069290 N50421Franco Gary R · Chico, CABuilt 1968 · S/N 15069291 N50425Keneston Mark G · Ballston Spa, NYBuilt 1968 · S/N 15069295 N50431Board Susan W · Moundsville, WVBuilt 1968 · S/N 15069298 N50432Mountain Air Flying Club Inc · Clarksburg, WVBuilt 1968 · S/N 15069299 N50434Summerville Daniel · Millersville, MDBuilt 1968 · S/N 15069301 N50438Roche Thomas A · Bardstown, KYBuilt 1968 · S/N 15069303 N50465Howard Wayne A · Loon Lake, WABuilt 1968 · S/N 15069322 N50467Hastings Stephen J · Palmer, AKBuilt 1968 · S/N 15069324 N50471Honsperger Karl J Trustee · Fremont, OHBuilt 1968 · S/N 15069327 N50473Cobrinik Adam · Whites Creek, TNBuilt 1968 · S/N 15069329 N50474Mother Lode Flying Club · San Andreas, CABuilt 1968 · S/N 15069330 N50475Mc Ironworks Welding And Fabrication Inc · Chico, CABuilt 1968 · S/N 15069331 N50488Fratti Robert B · Nampa, IDBuilt 1968 · S/N 15069340

Back to AD 2009-10-09 R2