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.

N50729Blue Sky 6 LLC · Torrance, CAS/N 15069513 N50732Lil 150 LLC · Sauk Rapids, MNBuilt 1968 · S/N 15069515 N50734Dillman Kurt A · Victor, NYBuilt 1968 · S/N 15069517 N50745Caicedo David · Villa Rica, GABuilt 1968 · S/N 15069524 N50747N50747 LLC · Great Falls, MTBuilt 1968 · S/N 15069526 N50748Freeman Teresa L · Kinston, OHBuilt 1968 · S/N 15069527 N50749Blackwater Aviation LLC · Douglas, GABuilt 1968 · S/N 15069528 N50750Fly Chattanooga LLC · Ooltewah, TNBuilt 1968 · S/N 15069529 N50759Thode Leonard E · Michigan City, INBuilt 1968 · S/N 15069533 N50766Sheets Laura J · Follett, TXBuilt 1968 · S/N 15069539 N50769Miller Justin · Boaz, ALBuilt 1968 · S/N 15069540 N50774White T William · Londonderry, NHBuilt 1968 · S/N 15069543 N50777Morlan Scott A · Indianola, IABuilt 1968 · S/N 15069546 N50781Beard Michael E · Udall, KSBuilt 1968 · S/N 15069549 N50790Taylor Terry D · Orange Park, FLBuilt 1968 · S/N 15069556 N50793Matter In Motion Inc · Fox River Grove, ILBuilt 1968 · S/N 15069558 N50799Jungren Brett F · Elmwood, NEBuilt 1968 · S/N 15069560 N50805Dale Aero LLC · Eloy, AZBuilt 1968 · S/N 15069564 N50813Record John W · Apison, TNS/N 15069568 N50816Dingee Robert G · Clarks Summit, PABuilt 1968 · S/N 15069571 N50818Bradley Hayden Ace · Litchfield Park, AZBuilt 1968 · S/N 15069572 N50819Registered aircraftBuilt 1968 · S/N 15069573 N50832Whalen John F Jr · West Ossipee, NHS/N 15069584 N50835Henson Chad Cox · Galivants Ferry, SCBuilt 1968 · S/N 15069585 N50836Leeper Miles F · Douglass, KSBuilt 1968 · S/N 15069586 N50837N50837 LLC · Kaneohe, HIBuilt 1968 · S/N 15069587 N50840Dahlgren John W · Little Egg Harbor, NJBuilt 1968 · S/N 15069588 N50844Ellenson Conroy N · Browns Valley, CABuilt 1968 · S/N 15069590 N50846Jackson Bob · Bay City, TXS/N 15069592 N50850Knutson Wayne R · Tioga, NDBuilt 1968 · S/N 15069596 N50854Fulton Lanny G · Spartanburg, SCBuilt 1968 · S/N 15069600 N5085BAccelerated Aviation Instruction LLC · Owatonna, MNBuilt 1979 · S/N 15283739 N50865Smith Leslie A · Waresboro, GAFirst renewal noticeBuilt 1968 · S/N 15069606 N50868Krekacs Gabor · La Crescenta, CABuilt 1968 · S/N 15069608 N50871Saint Joseph Of Cupertino Shenandoah Flying Assoc · Winchester, VABuilt 1968 · S/N 15069610 N50874Priddle Linda Ann · Carlsborg, WABuilt 1968 · S/N 15069613 N50875Krs Aerial Inc · Plain City, OHS/N 15069614 N50876Parker David A · Sacramento, CAS/N 15069615 N5087LGreen Airport Development Corp · Kemah, TXBuilt 1980 · S/N 15284253 N50887Stanton Sport Aviation Inc · Stanton, MNBuilt 1968 · S/N 15069620 N5088LRichmor Aviation Inc · Hudson, NYBuilt 1980 · S/N 15284254 N50891Peterson Andrew B · Louisville, KYBuilt 1968 · S/N 15069623 N50896Bankhead David B · Montrose, WVBuilt 1968 · S/N 15069625 N50898Costa Air Service LLC · Painted Post, NYS/N 15069626 N5089PBroburg Gregory William · Minneapolis, MNBuilt 1981 · S/N 15284873 N50904Karges Kip · Tuscola, TXBuilt 1968 · S/N 15069631 N50909Keystone Aviation Group LLC · Paxinos, PABuilt 1968 · S/N 15069634 N5090QTakai Hiroyasu · San Jose, CABuilt 1981 · S/N 15285071 N50911Graves Robert E · Danville, INBuilt 1968 · S/N 15069636 N50914Calhoun John R · Baton Rouge, LABuilt 1968 · S/N 15069638

Back to AD 2009-10-09 R2