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.

N608EAKingsky Flight Academy LLC · Lakeland, FLBuilt 1978 · S/N 15282193 N608FMSouth Bay International Flight Association Inc · Torrance, CABuilt 1978 · S/N 15282795 N609033bs Land Development LLC · Seattle, WABuilt 1969 · S/N 15070657 N60912Krogh Zachary H · Mc Laughlin, SDBuilt 1969 · S/N 15070663 N60916Webb Hunter · Altamont, UTBuilt 1969 · S/N 15070666 N60919Lassie Lite LLC · Rhinebeck, NYBuilt 1969 · S/N 15070669 N6091GAkin Evrin · Newport Beach, CABuilt 1969 · S/N 15071591 N60926Watson Stephen A · Scottsdale, AZBuilt 1969 · S/N 15070673 N6092GComeau Charles · Brimfield, MABuilt 1969 · S/N 15071592 N6092MSchmucker Daniel · Bryn Athyn, PAS/N 15284619 N60930Time Machine LLC · Kailua Kona, HIBuilt 1969 · S/N 15070674 N60938Thomas Michael F · Glennallen, AKS/N 15070679 N6093GCaylin LLC · Wilmington, DEBuilt 1969 · S/N 15071593 N60940O Lazy L Ranch & Farm · Satanta, KSBuilt 1969 · S/N 15070681 N60941Mayo Wilburt E Jr · Landers, CABuilt 1969 · S/N 15070682 N60943Walters William L · Boise, IDBuilt 1969 · S/N 15070684 N60944Brecht Deen R · Golden Valley, NDBuilt 1969 · S/N 15070685 N6094JHyten Mark B · Zionsville, INBuilt 1973 · S/N A1500394 N6094KPcs Aviation LLC · Louisa, VAFirst renewal noticeBuilt 1975 · S/N 15077522 N60950Sattizahn William M · Fredericksburg, PABuilt 1969 · S/N 15070690 N60959Cruz Abdiel Ayala · Ocala, FLBuilt 1969 · S/N 15070697 N6095JWaterman David K · Temple City, CABuilt 1973 · S/N A1500395 N60962Barnstormers Inc · Bemidji, MNBuilt 1969 · S/N 15070699 N60967Salyer Robert D · Nashville, TNS/N 15070701 N60968Nelson Gary A · Grand Marais, MNBuilt 1969 · S/N 15070702 N6096GPilot Pros Inc · Miami, FLBuilt 1969 · S/N 15071596 N6096JCurrivan Robert B · Fort Mohave, AZS/N A1500396 N60970Airfrank Inc · Hackensack, NJBuilt 1969 · S/N 15070704 N60976Fly Low Aviation LLC · Smithville, MSS/N 15070709 N6097MPea-Wayman Flight LLC · Daytona Beach, FLBuilt 1980 · S/N 15284621 N60982Taylor Gregory William II · Angels Camp, CABuilt 1969 · S/N 15070714 N60983Jpm Aircraft Leasing LLC · Wilmington, DES/N 15070715 N60988Cluck Charles W · Spring, TXBuilt 1969 · S/N 15070718 N6098JHall David K · State College, PABuilt 1973 · S/N A150-0397 N60995Replogle Thomas J · Redondo Beach, CAFirst renewal noticeBuilt 1969 · S/N 15070721 N6099JVincent David R · Hartley, TXBuilt 1973 · S/N A1500399 N60SXDitzler Enterprises Inc · Grinnell, IAS/N 15285148 N61001Monroe Perry M · Woodinville, WABuilt 1969 · S/N 15070724 N61009Jansky Michael J · Hallettsville, TXBuilt 1969 · S/N 15070730 N6100GEvent Tech Services LLC · Quarryville, PABuilt 1969 · S/N 15071600 N61010Hall Scotty · Cheraw, SCBuilt 1969 · S/N 15070731 N61019Goodwin William J · Charlotte C H, VAS/N 15070738 N61020Houk Sean R · Lyons, OHBuilt 1969 · S/N 15070739 N61026Johnson David A · Dover, OHBuilt 1969 · S/N 15070744 N61028Berendes Jay R · Shullsburg, WIBuilt 1969 · S/N 15070746 N6102HSunrise Aviation Inc · Ormond Beach, FLBuilt 1979 · S/N 15284131 N61030Balderrama Arturo · Mcminnville, ORBuilt 1969 · S/N 15070748 N61031Pacific Aircraft Services · Aurora, ORBuilt 1969 · S/N 15070749 N61033Dame John D · Omaha, NEBuilt 1969 · S/N 15070751 N61038Bartholomew Howard R Jr · Mechanicsburg, PABuilt 1969 · S/N 15070755

Back to AD 2009-10-09 R2