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.

N6834FLecompte Kevin J · Lancaster, MABuilt 1966 · S/N 15063434 N6834GRoberts Edwin G · Lake Wales, FLBuilt 1970 · S/N 15072334 N68356Don Davis Aviation Inc · Henderson, KYBuilt 1981 · S/N 15285327 N6836FFoley Anthony · Savannah, GABuilt 1966 · S/N 15063436 N6836GRegistration Pending · Highland, UTRegistration pendingBuilt 1970 · S/N 15072336 N6837FSkyberjet LLC · Allen, TXBuilt 1966 · S/N 15063437 N68402Space Coast Aircraft Co · Merritt Island, FLBuilt 1978 · S/N 15282284 N6840FBushre David · Janesville, WIBuilt 1966 · S/N 15063440 N6840GMiller Robert L · Tecumseh, MIBuilt 1970 · S/N 15072340 N68414Wright Duane C · Sanford, FLBuilt 1978 · S/N 15282288 N68418Moore Michael P · Houston, TXBuilt 1978 · S/N 15282289 N68422Kasper Sean · Killeen, TXS/N 15282291 N6842FRodriguez Leyla M · Bellflower, CABuilt 1966 · S/N 15063442 N6843FMoyers John Jason · Midlothian, VAFirst renewal noticeBuilt 1966 · S/N 15063443 N6843GTracey Corp · Midland, VAS/N 15072343 N68459Airplanes And Helicopters Of Oregon LLC · Sisters, ORBuilt 1978 · S/N 15282303 N6845FHoward Donald E II · Ponca City, OKBuilt 1966 · S/N 15063445 N68475California In Nice Inc · San Jose, CABuilt 1978 · S/N 15282311 N68477Freiburger Thomas M · Belvedere, CABuilt 1978 · S/N 15282312 N6847FFranko Gregory · Grindstone, PABuilt 1966 · S/N 15063447 N68485Dkg Cessna LLC · Flagler Beach, FLS/N 15282313 N6848FWhitehead Mathew S · Leesville, LABuilt 1966 · S/N 15063448 N6849FDeangelis Jarrod A · Henderson, NVS/N 15063449 N6850GVoorheis Patrica D · Casa Grande, AZBuilt 1970 · S/N 15072350 N6851FCarr Thomas W · Grand Blanc, MIBuilt 1966 · S/N 15063451 N6854GUniverse LLC · Prospect, KYBuilt 1970 · S/N 15072354 N6857GDuran Alexander · Holbrook, NYBuilt 1970 · S/N 15072357 N685RADenkat Plane Shadow LLC · Buckeye, AZBuilt 1968 · S/N 15068701 N68608Oxford Aircraft Leasing LLC · Oxford, NCBuilt 1978 · S/N 15282317 N6862FGradel Thomas A Jr · Irmo, SCBuilt 1966 · S/N 15063462 N6865FGeissler Robert William Jr · Baltimore, MDBuilt 1966 · S/N 15063465 N6866FLand Ross A · Cedar Rapids, IAS/N 15063466 N68688Registered aircraftS/N 15282322 N6868FVan Bielert Wouter · Haxtun, COS/N 15063468 N68713Hillsboro Aero Academy LLC · Hillsboro, ORS/N 15285331 N68714Registration Pending · Iuka, ILRegistration pendingBuilt 1981 · S/N 15285332 N6872FSkybound Aircraft LLC · Blue Point, NYBuilt 1966 · S/N 15063472 N68735Pittsburgh Institute Of Aeronautics · West Mifflin, PABuilt 1978 · S/N 15282345 N68736Lake Elmo Aero LLC · Lake Elmo, MNS/N 15282346 N68742Byars Cecil E · Tupelo, MSBuilt 1978 · S/N 15282351 N68750Poplar Grove Airmotive Inc · Poplar Grove, ILBuilt 1978 · S/N 15282356 N68754Ace Aircraft Leasing Inc · Nazareth, PABuilt 1978 · S/N 15282358 N6875GStevenson Mark Frank · Anthem, AZBuilt 1970 · S/N 15072375 N68767Snohomish Flying Service Inc · Snohomish, WABuilt 1978 · S/N 15282367 N68768Harris Thomas W · Roseville, MNBuilt 1978 · S/N 15282368 N6876FPalmer Dana G · Gatesville, TXBuilt 1966 · S/N 15063476 N6876GMyers Russell E · Happy Jack, AZBuilt 1970 · S/N 15072376 N68775Gruca Paul G · Riverdale, MIBuilt 1981 · S/N 15285337 N68789Sinden Donald L · Puyallup, WABuilt 1978 · S/N 15282374 N68799Smtm Holdings Inc · Wilmington, DEBuilt 1978 · S/N 15282382

Back to AD 2009-10-09 R2