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.

N23491Mcintosh Dyllon J · Anchorage, AKBuilt 1968 · S/N 15068987 N23492Roller Michael J · Gassville, ARBuilt 1968 · S/N 15068988 N234RKShelton Raymond O · Jeanerette, LABuilt 1968 · S/N 15068893 N23500Windsense LLC · Charleston, SCS/N 15068992 N23502Thompson Timothy L · St Croix Falls, WIBuilt 1968 · S/N 15068994 N23504N23504 LLC · Fort Pierce, FLBuilt 1968 · S/N 15068996 N23508Aviato Research LLC · Phoenix, AZBuilt 1968 · S/N 15068999 N2396UMurphy Brandon C · Portland, TNBuilt 1966 · S/N 15065077 N23JRHerrera Pedro · Spring Branch, TXBuilt 1970 · S/N A1500259 N2401JOne-Fifty Inc · Myerstown, PAS/N 15065501 N2403JCordell John M · Rochester, WABuilt 1966 · S/N 15065503 N2408JIflycali LLC · Rancho Murieta, CABuilt 1966 · S/N 15065508 N240SUOhio State University · Columbus, OHBuilt 1981 · S/N 15285153 N2410JHeinze Gregory L · Little Rock, ARBuilt 1966 · S/N 15065510 N2411JKenney Jason M · Grand Rapids, MIBuilt 1966 · S/N 15065511 N2419JScheller Dwain A · Grand Rapids, MIBuilt 1966 · S/N 15065519 N241PFForsyth Huston J · New Orleans, LAFirst renewal noticeBuilt 1973 · S/N 15075274 N241RRRoss Riley C · Colorado Springs, COS/N 15073611 N2420JRailsback Craig S · Huntington Beach, CAS/N 15065520 N24214Mckinney Brett A · Hackleburg, ALBuilt 1977 · S/N 15280154 N2423JHarris Patrick S · Chamberlain, SDS/N 15065523 N24242Fly Sky Ads LLC · Manalapan, NJBuilt 1977 · S/N 15280170 N24260Aerial Banners Inc · Pembroke Pines, FLBuilt 1977 · S/N 15280180 N24261Citabria Inc · Auburn, CABuilt 1977 · S/N 15280181 N24264Sunrise Aviation Inc · Ormond Beach, FLBuilt 1977 · S/N 15280183 N24266Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1977 · S/N 15280185 N24269Sioux Air Inc · South Sioux City, NEBuilt 1977 · S/N 15280186 N24296Cc Aviation Inc · Tracy, CABuilt 1977 · S/N 15280201 N242XFour Aces Montana LLC · Missoula, MTBuilt 1965 · S/N 15062062 N24305Woolsey Joseph A · Squaw Valley, CABuilt 1977 · S/N 15280206 N2430JColster John W · Centerview, MOBuilt 1966 · S/N 15065530 N24313Wings Over Texas Holdings LLC · Denton, TXBuilt 1977 · S/N 15280210 N24315Cubicle Concepts Inc · New Holland, PABuilt 1977 · S/N 15280212 N24327Centurion Aviation · Salina, KSFirst renewal noticeBuilt 1977 · S/N 15280218 N24331Registration Pending · Norman, OKRegistration pendingBuilt 1977 · S/N 15280219 N24333Silver Express Co DBA · Miami, FLBuilt 1977 · S/N 15280220 N2434JSkyhawk Aero LLC · Montevideo, MNS/N 15065534 N24351426th Aero Squadron LLC · Cropwell, ALBuilt 1977 · S/N 15280230 N2435JWitherspoon Jason C · Austin, ARBuilt 1966 · S/N 15065535 N24363Sale Reported · Crystal, MNSale reported, canceledBuilt 1977 · S/N 15280235 N24364Monsalve Carlos M · Lewiston, NYBuilt 1977 · S/N 15280236 N24373Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1977 · S/N 15280240 N24385Laurel Highlands Aeronautical Academy · Latrobe, PABuilt 1977 · S/N 15280248 N2438JVayner Anton · Shorewood, WIBuilt 1966 · S/N 15065538 N24399Lcc North LLC · Freehold, NJBuilt 1977 · S/N 15280252 N2439JHenderickson Robert T · Galesburg, ILBuilt 1966 · S/N 15065539 N244004 One Air LLC · Holland, MIBuilt 1977 · S/N 15280253 N24403Somboonsap Patanapong · Oakland Park, FLBuilt 1977 · S/N 15280254 N2440JOliver Tim J · San Luis Obispo, CABuilt 1966 · S/N 15065540 N2442JOlson Lanny R · Huron, SDS/N 15065542

Back to AD 2009-10-09 R2