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.

N4628XWilson Daniel T · Bandon, ORBuilt 1967 · S/N 15064678 N462QHaines John P · Newcomerstown, OHBuilt 1975 · S/N 15076940 N462TATomlinson Aviation Inc · Ormond Beach, FLBuilt 1979 · S/N 15283554 N46308St Cloud State Univ Aero Club Inc · St Cloud, MNBuilt 1978 · S/N 15283029 N4631BAces High Aviation LLC · Long Beach, CABuilt 1979 · S/N 15283558 N4632XGerstemeier Bernard A · Advance, NCBuilt 1966 · S/N 15064682 N4634XSorg Daniel T · Columbus, INS/N 15064684 N4635LIndiana State University · Terre Haute, INBuilt 1980 · S/N 15284201 N46366Stockton Raymond L · Pearl City, HIBuilt 1978 · S/N 15283039 N4638XHoward David R · Oconomowoc, WIBuilt 1966 · S/N 15064688 N46393Sam Aviation LLC · Long Beach, CAS/N 15283042 N4639XCjs Aviation Consulting LLC · Phoenix, AZS/N 15064689 N4640BChapel Hill Flying Club DBA · Sanford, NCBuilt 1979 · S/N 15283560 N4640XStern Roger A · Kearny, AZBuilt 1966 · S/N 15064690 N46413Wings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 15283045 N4641PRiverside Flight Center Inc · Tulsa, OKBuilt 1980 · S/N 15284790 N4643XTaylor Aaron B · Leander, KYBuilt 1966 · S/N 15064693 N46473Aviation Capital Management LLC · San Jose, CABuilt 1978 · S/N 15283056 N46487Silver Express Co · Miami, FLBuilt 1978 · S/N 15283061 N4648XRipp Patrick L · Mineral Point, WIBuilt 1966 · S/N 15064698 N4649MDaviation Inc · Willoughby, OHBuilt 1980 · S/N 15284474 N46500Montgomery Stephen C · Charlotte, NCS/N 15283063 N4650XBurt Compton Enterprises Inc · Marfa, TXBuilt 1966 · S/N 15064700 N4653LTfa Aircraft Holding Corp · Daytona Beach, FLBuilt 1980 · S/N 15284208 N4653XRankin Kevin · Maryville, MOBuilt 1966 · S/N 15064703 N46541Jodkin Jason · Confluence, PAS/N 15283068 N4654BXin Han Aviation LLC · Atwater, CABuilt 1979 · S/N 15283564 N4654XMurray Dale W · East Wenatchee, WABuilt 1966 · S/N 15064704 N46553Colonial Air Inc · New Bedford, MABuilt 1978 · S/N 15283072 N4655HWest Bend Air Inc · West Bend, WIBuilt 1979 · S/N 15283963 N4655POklahoma State University · Stillwater, OKS/N 15284794 N4655XJp Aero Holdings Inc · Carson City, NVS/N 15064705 N46574Martz G Rodney · Frederick, MDBuilt 1978 · S/N 15283076 N4657XVan Buskirk Samuel Victor · Valdez, AKFirst renewal noticeBuilt 1966 · S/N 15064707 N4658BOwens Flight Training LLC · Lafayette, LABuilt 1979 · S/N 15283567 N4660XRegistered aircraftS/N 15064710 N4661BGalovich David J · Roselle, ILBuilt 1979 · S/N 15283569 N4661QLaguna Verde Leasing Inc · Wilmington, DEBuilt 1981 · S/N 15285047 N4661XDresden Leasing LLC · Sheridan, WYS/N 15064711 N46644Chubb Michael R · Estell Manor, NJBuilt 1978 · S/N 15283083 N46648Signs William E · Addison, TXBuilt 1978 · S/N 15283084 N46649Wings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 15283085 N46657Ormond Aircraft Leasing & Management Inc · Ormond Beach, FLBuilt 1978 · S/N 15283087 N46660Knutson Wayne R · Thompson, NDFirst renewal noticeS/N 15066075 N4666XHolmes Joseph E · Cherry Valley, CABuilt 1966 · S/N 15064716 N4669AWolstenholme Ralph E · Westfield, PABuilt 1979 · S/N A1520860 N4669XLwl Aero LLC · Saint George, UTBuilt 1966 · S/N 15064719 N46725Cloud Dancer Aviation Inc · Deland, FLS/N 15283095 N4672XAmerican Piston Domestic LLC · Lonsdale, MNBuilt 1966 · S/N 15064722 N4673XRegistration Pending · Bloomingdale, OHRegistration pendingBuilt 1966 · S/N 15064723

Back to AD 2009-10-09 R2