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.

N6933GAltomari Richard · Pittsburgh, PABuilt 1970 · S/N 15072433 N6934SLet There Be Flight LLC · Portage, MIBuilt 1967 · S/N 15067634 N6935FWood Roger E · Waxhaw, NCBuilt 1966 · S/N 15063535 N6937FSale Reported · Rockton, ILSale reportedS/N 15063537 N6937SCaum David A · La Porte, INBuilt 1967 · S/N 15067637 N6938GRf Aviation LLC · Owensboro, KYS/N 15072438 N6939FPayne Billy Jack · Powhatan, VABuilt 1966 · S/N 15063539 N693ARFlexfly LLC · Las Vegas, NVS/N 15282613 N6941FMorgan Stuart G · Spring Valley, CABuilt 1966 · S/N 15063541 N6941SBrowning Stephen D · Bear, DES/N 15067641 N6943GBoydston Tony C · El Paso, TXBuilt 1970 · S/N 15072443 N6943SBoniek Martin J · Nederland, COS/N 15067643 N6944SVfr Aviation LLC · Clayton, NYS/N 15067644 N6946F46fox Aviation LLC · Bedminster, NJBuilt 1966 · S/N 15063546 N6946SImage Aviation Services LLC · Wilmington, DEBuilt 1967 · S/N 15067646 N6947GLin-Aero LLC · Conway, ARBuilt 1970 · S/N 15072447 N6948FLee Ethan · Millsap, TXBuilt 1966 · S/N 15063548 N6948GJbar Ranch LLC · Downey, IDBuilt 1970 · S/N 15072448 N6948SZaremba Michael W · Custer, WIBuilt 1968 · S/N 15067648 N6949FConaway Byron Richard · Savannah, TNS/N 15063549 N6949GTillstrom Gary A · Memphis, TNBuilt 1970 · S/N 15072449 N6950FRgv Flight Academy LLC · Bayview, TXBuilt 1966 · S/N 15063550 N6951GHernandez Alfonso · Garland, TXBuilt 1970 · S/N 15072451 N6952FSkalsky Nathan · Tigard, ORBuilt 1966 · S/N 15063552 N6952SMyers Karen J · Bemidji, MNBuilt 1967 · S/N 15067652 N6953GVidal Miguel · Novi, MIS/N 15072453 N6954FRegistration Pending · Sumner, WARegistration pendingBuilt 1966 · S/N 15063554 N6954SPierson Jared · Coeur D Alene, IDBuilt 1967 · S/N 15067654 N6955GExecutive Aircraft International Inc · Bolivar, TNS/N 15072455 N6955SHhd Aviation LLC · Hamilton, OHBuilt 1967 · S/N 15067655 N6956GR & B Helicopters Inc · Calhoun, GABuilt 1970 · S/N 15072456 N6957FRussell Clyde R Jr DBA · Montrose, ARS/N 15063557 N6958GScoskie Keith E · Van, TXBuilt 1970 · S/N 15072458 N6958SPeterson Leonard J · Cleveland, TNBuilt 1967 · S/N 15067658 N6960FFirst Waypoint LLC · Mckinney, TXS/N 15063560 N6962FSiegrist Gary D · Belvidere, ILS/N 15063562 N6962GGill Robert S · Anchorage, AKBuilt 1970 · S/N 15072462 N6965FJefferies Vincent B · Rock Springs, WYBuilt 1966 · S/N 15063565 N6965SSawyer Donald · Johnson, VTS/N 15067665 N6966GHotsenpiller Larry E · Sedalia, MOBuilt 1970 · S/N 15072466 N6966SStout Larry E · Winamac, INBuilt 1967 · S/N 15067666 N6967GHuddleston Edward I · Oaktown, INS/N 15072467 N6968STrue Robert S · Prosper, TXS/N 15067668 N6969FBrannan William C · Temecula, CAS/N 15063569 N696NSParkhill Clifton A Jr Trustee · Oxnard, CABuilt 1968 · S/N 15068871 N6970GOstrem John C · Stillwater, MNBuilt 1970 · S/N 15072470 N6971FSutton Marshall T · Erick, OKBuilt 1966 · S/N 15063571 N6971GParks Rodney A · Vero Beach, FLBuilt 1970 · S/N 15072471 N6971SHirsch T W III · Farmers Branch, TXS/N 15067671 N6972FHirsch T W III · Farmers Branch, TXBuilt 1966 · S/N 15063572

Back to AD 2009-10-09 R2