Skip to content

AD 2009-13-06 R1

Registered aircraft · 2,130

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-13-06-R1') 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-13-06-R1') 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-13-06-R1')
    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-13-06-R1')
  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-13-06-R1')
  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-13-06-R1')
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.

N59826Air Arctic Inc · Fairbanks, AKBuilt 1976 · S/N 31-7652077 N59829Warbelows Air Ventures Inc · Fairbanks, AKBuilt 1976 · S/N 31-7652081 N5982YDawkins Karlene A · Coral Springs, FLBuilt 1966 · S/N 27-3155 N59848Sanborn Map Co Inc · Colorado Springs, COBuilt 1976 · S/N 31-7612052 N59865Mccorkle Joseph P II · Tyronza, ARBuilt 1976 · S/N 31-7612065 N59867Cooper Keith L · Tabernash, COBuilt 1976 · S/N 31-7612068 N5986YBlackhawk Holding Corp · Wilmington, DEBuilt 1966 · S/N 27-3159 N59906Alpha Whiskey 2 LLC · Brandon, MSBuilt 1974 · S/N 31-7552027 N59936Kelly Kent R · Montgomery, ALBuilt 1975 · S/N 31-7512019 N59982Duck L'Ranch LLC DBA · Fort Lauderdale, FLBuilt 1975 · S/N 31-7552071 N59987Wings As Eagles Mission Air Serv Inc · Oshkosh, WIBuilt 1975 · S/N 31-7552081 N599AHAvtran LLC · Clayton, MOBuilt 1984 · S/N 31-8452019 N59EEKern Raymond L · Bedford, INS/N 27-3390 N59EHSale Reported · Dawsonville, GASale reported, pending cancellationBuilt 1978 · S/N 31T7820014 N59FCLamb Farms Inc · Oakfield, NYBuilt 1979 · S/N 31-7952117 N59GYChieftain N59gy LLC · Saint Augustine, FLBuilt 1977 · S/N 31-7852017 N59JCPegasus Air Charter LLC · Hartford, CTBuilt 1979 · S/N 31-7952181 N5DValiair Ltd Co Trustee · Casper, WYBuilt 1978 · S/N 31T-7820080 N5HMEvans Hayward D · Saint Augustine, FLBuilt 1973 · S/N 27-7305041 N5SYDialysis Clinic Inc · Nashville, TNBuilt 1981 · S/N 42-8001069 N6000PMoseley Timothy D · Calhoun, KYBuilt 1957 · S/N 23-1236 N600RJRankin Richard · Germantown, TNBuilt 1979 · S/N 27-7954114 N6011YTab Associates Inc DBA · Port Saint Lucie, FLBuilt 1966 · S/N 27-3193 N6017YTulsa Technology Center School District No 18 · Tulsa, OKS/N 27-3200 N601AJShamrock Aviation LLC · Madison, MSBuilt 1984 · S/N 31T-1104013 N6030YReddick Brent · Paragould, ARBuilt 1969 · S/N 27-4370 N6034YTan American Corporation · New York, NYRegistration revokedBuilt 1966 · S/N 27-3219 N6039YAllen Aviation Inc · Aynor, SCBuilt 1966 · S/N 27-3224 N6044YPinnock Charles W · Port St Lucie, FLBuilt 1966 · S/N 27-3230 N6046YWells Douglas A · Chino, CAS/N 27-3233 N6052YCentral Kentucky Aviation Inc · Bardstown, KYBuilt 1966 · S/N 27-3243 N6058YEltgroth Peter G · Livermore, CABuilt 1966 · S/N 27-3251 N6062YJahba LLC · Coral Springs, FLBuilt 1966 · S/N 27-3257 N6069YAngelman Aviation LLC · Prosper, TXBuilt 1966 · S/N 27-3267 N606CACv Wings LLC · Canby, MNBuilt 1972 · S/N 27-4853 N606DWElkhorn Valley Trucks II LLC · Fremont, NEBuilt 1981 · S/N 31T-8120038 N606JSStar Marianas Aviation School Inc · Tinian, MPS/N 31-7952145 N6085YPharmair LLC · Jackson, MSBuilt 1966 · S/N 27-3287 N6089YAerosavant LLC · Towanda, PABuilt 1966 · S/N 27-3295 N6092YClean Waste Solutions LLC · Indianapolis, INBuilt 1966 · S/N 27-3298 N60AY2701 Ne 27 Court LLC · Hollywood, FLBuilt 1981 · S/N 31-8152051 N60CGSaj Aviation LLC · Reading, PABuilt 1980 · S/N 318052206 N60JWTumbleweed Leasing LLC · Tacoma, WABuilt 1980 · S/N 31T-8004031 N60LFNorthwoods Air LLC · Orono, MEBuilt 1978 · S/N 27-7854111 N60MBCurry Arnold J · Houston, TXBuilt 1966 · S/N 27-3544 N60TAAero Elite LLC · Springfield, MOS/N 31-7552094 N6107AR & R Aviation Support LLC · Atlanta, GABuilt 1978 · S/N 31T-7820087 N611BT-2 Enterprises LLC · Walla Walla, WABuilt 1981 · S/N 31T-8166015 N611DPInversiones Flg Inc · Dorado, PRBuilt 1977 · S/N 31-7812040 N611SGRph Engineering LLC · Lehi, UTBuilt 1979 · S/N 27-8054020

Back to AD 2009-13-06 R1