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.

N42MHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1977 · S/N 31-7852015 N42PBPfister Mark A · Acworth, GABuilt 1960 · S/N 23-1895 N42RCRci Air Inc · Bridgeport, CTBuilt 1980 · S/N 31-8052170 N42TTRhs Consulting Ltd LLC · Reno, NVBuilt 1972 · S/N 31P-60 N42WPAir Arctic Inc · Fairbanks, AKBuilt 1982 · S/N 31-8252038 N42YCApa Aviation LLC · Gainesville, FLS/N 318152042 N42ZCCrest View Aero LLC · Rancho Cordova, CABuilt 1981 · S/N 428001039 N4300PMontcalm-Mcdonald LLC · Mansfield, LAFirst renewal noticeBuilt 1959 · S/N 23-1801 N4301C70 North LLC · Anchorage, AKBuilt 1983 · S/N 31-8353001 N4302YLundstedt Gregory · Duncan, SCBuilt 1961 · S/N 23-2025 N4306YRegistration Pending · Phoenix, AZRegistration pendingBuilt 1961 · S/N 23-2029 N4307PGibson Kim · Ocean Springs, MSBuilt 1959 · S/N 23-1808 N4309PSibille Philippe B · Waller, TXBuilt 1959 · S/N 23-1810 N4310PChimera Air Inc · Maumee, OHBuilt 1959 · S/N 23-1811 N4311PRitchie Glenn R · King George, VAS/N 23-1812 N4312YWhittom Ron W Jr · Wasilla, AKS/N 23-2036 N4321YSchuermann Chris L · Sand Springs, OKBuilt 1965 · S/N 27-607 N4322TKing Kong Broadcasting Inc · Las Vegas, NVBuilt 1964 · S/N 27-2524 N4329YDetert Bradley · Valparaiso, INBuilt 1966 · S/N 27-619 N432CWValiair Lc Trustee · Casper, WYBuilt 1975 · S/N 31-7512012 N4333PTinny Twister Aviation LLC · Fort Myers, FLBuilt 1959 · S/N 23-1834 N4334PWelke Aviation Inc · St James, MIBuilt 1959 · S/N 23-1835 N433DBBarnes Creek Drilling LLC · Columbia, MSBuilt 1974 · S/N 31P-7400228 N4354PApache Twin Rental LLC · Harrisonville, MOBuilt 1960 · S/N 23-1854 N4355PCrew Sourcing Inc · Wilmington, DES/N 23-1855 N4357PWatkins Lowry Jr · Louisville, KYBuilt 1959 · S/N 23-1857 N4358PQualitair LLC Trustee · MichelstadtBuilt 1959 · S/N 23-1858 N4373PMartin Vernon W · Peoria Heights, ILBuilt 1960 · S/N 23-1874 N4374PDodson International Parts Inc · Rantoul, KSBuilt 1960 · S/N 23-1880 N437CBCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1979 · S/N 31-7952225 N4381PChase 13 LLC · Wilmington, DES/N 23-1889 N43838Rodelsperger Robert · Charleston, SCS/N 27-4334 N4383PBeard Michael L · Marble Hill, MOS/N 23-1893 N4387PAurora 17 Holdings LLC · Aurora, ORBuilt 1960 · S/N 23-1898 N4394PJohnson Christopher R · Tulsa, OKBuilt 1960 · S/N 23-1906 N4395PHesse Paul W · Oxford, NCBuilt 1960 · S/N 23-1904 N4399PSchrunk Lloyd E · Canby, MNBuilt 1960 · S/N 23-1911 N43CCWpb Pilot Service LLC · West Palm Beach, FLBuilt 1965 · S/N 27-2820 N43HBConefry Michael A · Belle Chasse, LABuilt 1974 · S/N 27-7405379 N43PTOso Air LLC · Missoula, MTS/N 27-7305217 N43WHLaurel Malibu LLC · Windber, PABuilt 1982 · S/N 31T-8120068 N440APValiair Lc Owner Trustee · Casper, WYS/N 31-7852027 N440CACc Flight Company LLC · Columbia City, INBuilt 1985 · S/N 42-5501027 N4411PJackson James O · Lake Charles, LAS/N 23-1923 N4421PAmendt Joseph J Jr · Watertown, SDBuilt 1960 · S/N 23-1935 N4426YR & S Enterprises · Fort Wayne, INBuilt 1971 · S/N 27-4708 N4429PRegistration Pending · Kenai, AKRegistration pendingBuilt 1960 · S/N 23-1945 N4434DAir Arctic Inc · Fairbanks, AKBuilt 1974 · S/N 31-7552020 N443MCFnnuts LLC · West Hazleton, PAS/N 31-8252061 N4440PApac LLC · Berlin, NJBuilt 1961 · S/N 23-1957

Back to AD 2009-13-06 R1