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.

N3939JMidwest Aero Solutions LLC · Lake Saint Louis, MOBuilt 1966 · S/N 15065239 N3939VSaddler Joshua L · Lincoln, CABuilt 1975 · S/N 15076660 N3940JJess Lawrence A · Menomonie, WIBuilt 1966 · S/N 15065240 N3940VSoderman Brian · East Bethel, MNBuilt 1975 · S/N 15076661 N3951JJenani Industries LLC · La Verne, CABuilt 1966 · S/N 15065251 N3952JStewarts Aircraft Service Inc · Waynesville, OHBuilt 1966 · S/N 15065252 N3953JKearns Reno T · Jeannette, PAS/N 15065253 N3954JDroessler Anthony E · Lakota, IABuilt 1966 · S/N 15065254 N3955JLaird Charles L · Adelanto, CABuilt 1966 · S/N 15065255 N3956JStriplin James R Jr · Hartford, ALBuilt 1966 · S/N 15065256 N3957JMckinnon Benjamin G · Santaquin, UTS/N 15065257 N3959JBergin Aire · Shelter Island, NYBuilt 1966 · S/N 15065259 N3962JKrnavek Carl R · Dayton, TXBuilt 1966 · S/N 15065262 N3966JLee A Archer Jr Red Tail Youth Flying Programs Inc · New Windsor, NYBuilt 1966 · S/N 15065266 N3967JAbbott Cedric M · Buckfield, MEBuilt 1966 · S/N 15065267 N3968JFlying Forward LLC · New Carlisle, OHS/N 15065268 N3969JKhleb Hub LLC · Palm Coast, FLS/N 15065269 N3978PNicklas William T · Rllng Hls Est, CABuilt 1977 · S/N 15279647 N3980JMushrush Kim · Tarrytown, GABuilt 1966 · S/N 15065280 N3981JKruger Gerhard B · Lathrop, CAS/N 15065281 N3983JVoizin Thomas J · Toney, ALBuilt 1966 · S/N 15065283 N3984JMatta Figueroa Eduardo · Chapman, KSBuilt 1966 · S/N 15065284 N3984VRussell Steve · Harper, ORBuilt 1975 · S/N 15076671 N3985JS & S Aviation LLC · Roanoke, INS/N 15065285 N3987JRegistration Pending · Wylie, TXRegistration pending, pending cancellationS/N 15065287 N3988JTorrini Donald G · Edwardsville, ILBuilt 1966 · S/N 15065288 N3992JSabin Ronny L · Kennewick, WABuilt 1967 · S/N 15065290 N3993JWegner Eric E Trustee · Oconomowoc, WIS/N 15065293 N3995JWoodstock Air LLC · Monticello, FLBuilt 1966 · S/N 15065295 N3995VDesjardins James H · Troutdale, ORBuilt 1975 · S/N 15076674 N3996JThorman Joseph · Moorhead, MNBuilt 1968 · S/N 15065296 N3997VWestfall Lorn W III · League City, TXS/N 15076675 N3999JMurphy Arthur John III · Huntsville, ALBuilt 1966 · S/N 15065299 N399TXCherry Lane R · Vidor, TXS/N 15065205 N39TDHawk Meadow Aviation LLC · Sutton, AKBuilt 1971 · S/N 15073099 N3JTMcdannel Albert M · Laporte, INS/N 15070621 N3XZStrom Laurelin · Lexington Park, MDBuilt 1972 · S/N 15074013 N4006JGreenstreet Robert A · Lake Geneva, WIBuilt 1966 · S/N 15065306 N4013JMacomber Daniel · Chehalis, WABuilt 1966 · S/N 15065313 N4019JPowell Edward H · Potsdam, NYBuilt 1966 · S/N 15065319 N4020VDanielson Bradley M · Pelkie, MIBuilt 1975 · S/N 15076680 N4021JSharapan Ilya · Brooklyn, NYBuilt 1966 · S/N 15065321 N4023JHector Flyers LLC · Hector, MNBuilt 1966 · S/N 15065323 N4027JMcburney James H Jr · Horseshoe Bay, TXBuilt 1967 · S/N 15065327 N4028JWarn James D Jr · Overland Park, KSBuilt 1966 · S/N 15065328 N4034JStange Robert C · Toledo, OHBuilt 1966 · S/N 15065334 N4035JBloomquist Steven R · Granbury, TXS/N 15065335 N4038VStirling Nathan L · Alton, MEBuilt 1975 · S/N 15076682 N4043JDevine Steven A · Roseville, CAS/N 15065343 N4044JLiberty University Inc · Lynchburg, VABuilt 1966 · S/N 15065344

Back to AD 2009-10-09 R2