Skip to content

AD 2009-13-06 R1

Registered aircraft · 2,131

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.

N3475PEdixon James Richard II · Cameron Park, CABuilt 1958 · S/N 23-1449 N348GGFlplanes 21 Of Miami LLC · Miami, FLBuilt 1980 · S/N 31-8052054 N3494AWheeler Michael R · Peculiar, MOBuilt 1962 · S/N 27-2197 N3494BLiguori Fred C · Granby, CTBuilt 1955 · S/N 23-282 N3497PKitchens Craig N · Salt Lake City, UTBuilt 1958 · S/N 23-1473 N3499PTinny Twister Aviation LLC · Fort Myers, FLBuilt 1958 · S/N 23-1475 N349CHAce Flight Center Inc · St Thomas, VIBuilt 1968 · S/N 27-3949 N34DAGlover William S · Mount Pleasant, TXBuilt 1958 · S/N 231469 N34HM71wg LLC · Tulsa, OKBuilt 1980 · S/N 31T-8004057 N34KKLe Ferrand Colette · Kalispell, MTBuilt 1972 · S/N 27-7304946 N34MIII Enterprises LLC · Britton, SDBuilt 1975 · S/N 31P-7630007 N34WM70 North LLC · Anchorage, AKBuilt 1973 · S/N 31-7305125 N350CYMowotech Inc · Boca Raton, FLBuilt 1978 · S/N 31-7852010 N350DTDestination Alaska Air Service LLC · Homer, AKBuilt 1984 · S/N 31-8452010 N350FMF M Aero Inc · Calhoun, GAS/N 31-8152043 N350GBCarto-Flight · Willoughby, OHBuilt 1980 · S/N 31-8052136 N350KCLegare Aviation LLC · Murrells Inlet, SCBuilt 1979 · S/N 317952104 N350LUValiair Limited Co Trustee · Casper, WYS/N 31-8352032 N3516AAirplane 2 LLC · Sedona, AZBuilt 1979 · S/N 31-7952106 N35187Collins Daniel W Jr · Alvarado, TXS/N 31-7912056 N3520XGv Air Inc · Medford, ORBuilt 1979 · S/N 31-7912067 N3523DQuick Gas Aviation LLC · Thomasville, GABuilt 1979 · S/N 31-7952112 N3523YL A B Flying Service Inc · Renton, WAS/N 31-7952115 N35269Marlin Aviation Inc · West Palm Beach, FLBuilt 1979 · S/N 31-7952136 N3527DKlockenga Matthew · Crystal Lake, ILS/N 31-7952137 N3527UWarbelows Air Ventures Inc · Fairbanks, AKBuilt 1979 · S/N 31-7952141 N3529AMajestic Enterprises Ltd · Wilmington, DEBuilt 1979 · S/N 31-7952152 N3529WMission Flight · El Monte, CABuilt 1979 · S/N 31-7952159 N3535SEj Hodgson Aviation Inc · Beaver Island, MIS/N 31-7952203 N3536BBering Capital LLC · Anchorage, AKBuilt 1979 · S/N 31-7952205 N353SLSneaker Air Inc · Miami, FLBuilt 1979 · S/N 31-7952188 N3544MValiair Lc Trustee · Casper, WYBuilt 1979 · S/N 31-8012005 N35475Abd Corporation Inc · Tinian, MPBuilt 1979 · S/N 31-8052023 N3547BMlmce Company Inc · Winchester, VABuilt 1979 · S/N 31-8052017 N3547GCarto Flight Inc · Willoughby, OHBuilt 1979 · S/N 31-8052021 N3548BJaa Holdings LLC · Springfield, ILBuilt 1979 · S/N 31-8052025 N3548JCarden Kevin · Hoover, ALBuilt 1979 · S/N 31-8052027 N35497Fox Aircraft LLC · Bethel, AKBuilt 1979 · S/N 31-8052039 N3549XAirplane Four LLC · Miami, FLFirst renewal noticeBuilt 1980 · S/N 31-8052034 N3555BMtwc LLC · Ithaca, NES/N 31-8052056 N3555DDove Enterprises LLC · Wilmington, DES/N 31-8052059 N35580Aero Charter New England Inc · Mansfield, MABuilt 1980 · S/N 31-8052075 N35584Aztec Worldwide Airlines Inc · Wilmington, DEBuilt 1980 · S/N 31-8052076 N3558XAwmr LLC · Conroe, TXBuilt 1980 · S/N 31-8052073 N355FRD Hadjidemetriou Aviation Services Corp · Wilmington, DEBuilt 1975 · S/N 31P7530002 N355MDelaware Trust Company Owner Trustee · Wilmington, DES/N 273972 N356DBCaldwell Island LLC · Sherborn, MABuilt 1978 · S/N 31-7852056 N357SAFox Aircraft LLC · Wasilla, AKBuilt 1980 · S/N 31-8052162 N3582PAir Arctic Inc · Fairbanks, AKS/N 31-8052103 N35834Carto-Flight · Willoughby, OHBuilt 1980 · S/N 31-8052115

Back to AD 2009-13-06 R1