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.

N60767Turnier Mikel W · Middletown, NYBuilt 1969 · S/N 15070561 N60769Del Duca Frank J · Bethel, MEBuilt 1969 · S/N 15070563 N6076GColbert Farms Inc · Davenport, WAS/N 15071576 N60773Edwards Air LLC DBA · Raleigh, NCBuilt 1969 · S/N 15070566 N6077KRocha Adrian M · Rosharon, TXBuilt 1975 · S/N 15077513 N60781Two Birds One Bear LLC · Upper Arlington, OHBuilt 1969 · S/N 15070574 N60787Kenses Daniel T · Stuart, FLBuilt 1969 · S/N 15070579 N60790Jenkins Berry E · Bell, FLBuilt 1969 · S/N 15070581 N60793Registered aircraftBuilt 1969 · S/N 15070584 N60796Lemanski Thomas A · Port Townsend, WABuilt 1969 · S/N 15070585 N60797Portland Metro Aviation & Flying Club · Portland, ORBuilt 1969 · S/N 15070586 N60798Hjl Farm Inc · Dagmar, MTS/N 15070587 N6079JSmith Richard D II · Luthersville, GAS/N A1500379 N60800Edens Harald E · Socorro, NMBuilt 1969 · S/N 15070588 N60802Smith Jay · San Andreas, CAS/N 15070590 N60808Foster William L · Waco, TXS/N 15070592 N6080JRidgewood Corp Inc · Orangeville, PAFirst renewal noticeS/N A1500380 N60818Bailey James C · Drummond Island, MIBuilt 1969 · S/N 15070597 N60822Hawkinson Paul M · Grand Rapids, MNS/N 15070600 N60825Namtvedt Erik L · Wasilla, AKBuilt 1969 · S/N 15070603 N6082KCarlton David L · Galesburg, ILBuilt 1975 · S/N 15077516 N60830Ace Aviation Seminars LLC · Armuchee, GABuilt 1969 · S/N 15070606 N60831Itm Aircraft LLC · North Charleston, SCBuilt 1969 · S/N 15070607 N60832Pharmacures Inc · Catasauqua, PABuilt 1969 · S/N 15070608 N60835Jet & Rotor Aviation LLC · Sacramento, CABuilt 1969 · S/N 15070610 N60836Avz Aviation Of Tennessee Inc · Knoxville, TNBuilt 1969 · S/N 15070611 N60837Howard James S · Arlington, TXS/N 15070612 N60846Erickson Daniel W · Tomales, CAS/N 15070615 N6084JHatloy Mark · Drayton, NDBuilt 1973 · S/N A1500384 N6084MGrider Charles H III · Belleville, ILBuilt 1980 · S/N 15284615 N60855Douglas Raymond M · Hamilton, NYBuilt 1969 · S/N 15070622 N6085MWood Mark D Trustee · New Berlin, WIBuilt 1980 · S/N 15284616 N60860Joebravo Aviation LLC · Derby, KSBuilt 1969 · S/N 15070627 N60861Hansen Aviation LLC · Savannah, GAS/N 15070628 N60865Breitberg Benjamin D · Ridgecrest, CABuilt 1969 · S/N 15070631 N60870Stracener Adam K · Pittsburg, TXBuilt 1969 · S/N 15070635 N60875Registration Pending · Soldotna, AKRegistration pendingBuilt 1969 · S/N 15070638 N60878Barnett Shawn N · Hartsfield, GABuilt 1969 · S/N 15070639 N6087JTexas Youth Flight Experience Foundation · Boerne, TXBuilt 1973 · S/N A1500387 N60880Walsh Michael B · Gates, TNBuilt 1969 · S/N 15070641 N60883Dubaj Louis F · Spring Hill, FLBuilt 1969 · S/N 15070644 N60884Norton Keith H · Oro Valley, AZBuilt 1969 · S/N 15070645 N60888Somerville Nicholas · Saint Augustine, FLBuilt 1969 · S/N 15070647 N60889Law Offices Of Shawn A Mcmillan Apc · San Diego, CABuilt 1969 · S/N 15070648 N6088GGreat Lakes Air Ventures LLC · Mason, MIBuilt 1969 · S/N 15071588 N6088HWright Duane · Sanford, FLS/N 15284129 N60892Moyers Steven J · Carrollton, KYBuilt 1969 · S/N 15070650 N60895Donald Williamson · Piedmont, SDBuilt 1969 · S/N 15070652 N60899Flight Services Inc · Headland, ALBuilt 1969 · S/N 15070654 N6089MAirplanes And Helicopters Of Oregon LLC · Sisters, ORBuilt 1980 · S/N 15284617

Back to AD 2009-10-09 R2