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.

N6260RNichols Rylan A · Frazer, MTBuilt 1965 · S/N 15061560 N6260SBrowne Clifford B · Southport, MEBuilt 1967 · S/N 15067060 N6261GNagaruk Nathan J · Nome, AKBuilt 1970 · S/N 15071761 N6261SWinnewisser Steve G · Santa Barbara, CABuilt 1967 · S/N 15067061 N6262GStockton Raymond L · Pearl City, HIS/N 15071762 N6262QNess David R · Ocklawaha, FLBuilt 1981 · S/N 15285213 N6262SSamis Kyle C · Emeryville, CABuilt 1967 · S/N 15067062 N6263KMakeever Robert L Trustee · Bucyrus, OHBuilt 1975 · S/N 15077616 N6264GOdush & Sayush Inc · Aurora, ILBuilt 1970 · S/N 15071764 N6264RCencal Flyers LLC · Turlock, CABuilt 1965 · S/N 15061564 N6264SJohnson Eric C · Turtle Lake, NDBuilt 1967 · S/N 15067064 N6265GCastleman Thomas G · League City, TXBuilt 1970 · S/N 15071765 N6265SWilson Daniel · Bandon, ORBuilt 1967 · S/N 15067065 N6266Wheaton Eric J · Gig Harbor, WAS/N 15066879 N6266GArgintar Donald · Fair Lawn, NJBuilt 1970 · S/N 15071766 N6266KAero Maintenance Inc · Vancouver, WABuilt 1975 · S/N 15077617 N6268SHayes Barrett W · Siler City, NCBuilt 1967 · S/N 15067068 N6269GMattingly Andrew R · New Albany, INBuilt 1970 · S/N 15071769 N626PABird Acquisition LLC · Phoenix, AZBuilt 1977 · S/N 15281199 N6270SHudson Kelly G · Monroe, NCBuilt 1967 · S/N 15067070 N6271GSumpter Kenneth W · Enid, OKBuilt 1970 · S/N 15071771 N6271SJay Square Aircraft Inc · Hilton Head Island, SCBuilt 1967 · S/N 15067071 N6272GDunn Michael Thomas · Arlington, VAS/N 15071772 N6274LTitterton Edward G III · Philadelphia, PABuilt 1980 · S/N 15284383 N6276PHoecher Robert T · Anchorage, AKS/N 15284993 N6277SJones Joseph L · Saint David, AZS/N 15067077 N6279MBlanchard Michael J · Cleveland, ARBuilt 1980 · S/N 15284650 N6279PIndiana State University · Terre Haute, INBuilt 1981 · S/N 15284994 N6282KLowder Harold E · Fresno, CAFirst renewal noticeBuilt 1975 · S/N 15077624 N6282MBruce Robert W · Frontenac, MNBuilt 1980 · S/N 15284651 N6282SWorth William D · Huntington Beach, CABuilt 1967 · S/N 15067082 N6283RAkchak Air LLC · Leeds, UTBuilt 1965 · S/N 15061583 N6283SMorris Kristina T · Ventura, CABuilt 1967 · S/N 15067083 N62853Willkomm John C · Kenosha, WIBuilt 1974 · S/N 15075715 N6285SWindsor John R · East New Market, MDBuilt 1967 · S/N 15067085 N6286MHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1980 · S/N 15284654 N6286SCunningham Doris DBA · East Freetown, MABuilt 1967 · S/N 15067086 N6287GPeters Guy P · Roy, UTBuilt 1970 · S/N 15071787 N6287KWilliams Jimmy Z · Sherman, TXBuilt 1975 · S/N 15077625 N6288GFetter Stanley B · Accokeek, MDBuilt 1970 · S/N 15071788 N6288KCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1975 · S/N 15077626 N6289KPitcock Randall · Farwell, TXBuilt 1975 · S/N 15077627 N6289SLink Darryl B · Centennial, COBuilt 1967 · S/N 15067089 N6290SFloyd Brannon A · Athens, GABuilt 1967 · S/N 15067090 N6291GWaddell Lucas A · Fort Worth, TXBuilt 1970 · S/N 15071791 N6292SAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1967 · S/N 15067092 N6293HSpace Coast Aircraft Co · Merritt Island, FLBuilt 1979 · S/N 15284150 N6294GGoodrich Michael O · Cogan Station, PABuilt 1970 · S/N 15071794 N6294MN6294m LLC · Boynton Beach, FLBuilt 1980 · S/N 15284657 N6294SErmel Ryan · Taylor, PABuilt 1967 · S/N 15067094

Back to AD 2009-10-09 R2