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.

N200DFLijack World Enterprises LLC · Winter Haven, FLS/N 27-4080 N200P10x Aviation Partners LLC · Stuart, FLBuilt 1980 · S/N 31-8052124 N200PGPanther Enterprises LLC · Fort Myers, FLBuilt 1979 · S/N 31T-7920015 N200PVPrestwick Chase Inc · Saratoga Springs, NYBuilt 1971 · S/N 31P-64 N200RARagan William W · North Kansas City, MOBuilt 1974 · S/N 31P7400198 N200SJChanney Aviation Group LLC · Las Vegas, NVBuilt 1981 · S/N 318152054 N200TSSmith Ironworks Of Alabama LLC · Fort Payne, ALBuilt 1978 · S/N 31T-7804002 N200XLCondor Aviation LLC · Bethlehem, PABuilt 1981 · S/N 31T-8166010 N2018PHauer Clifford Joseph Jr · Woodstock, GABuilt 1956 · S/N 23-590 N201NKHelms John Broward II · Bartow, FLBuilt 1972 · S/N 27-4816 N202DSValiair Lc Trustee · Casper, WYBuilt 1978 · S/N 31-7912025 N2033PAircraft Guaranty Corp Trustee · Oklahoma City, OKS/N 23-608 N2037PKuklo Robert M · Livermore, CABuilt 1956 · S/N 23-614 N203DMCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1966 · S/N 27-3461 N204SCGyure Ronald J · Fort Worth, TXBuilt 1965 · S/N 27-2796 N2050PDzvonik Eugen · Murray, UTBuilt 1956 · S/N 23-634 N20540Baum Martin L · Bullard, TXS/N 27-4193 N2071PAviation Business Corp · Saint Louis, MOBuilt 1956 · S/N 23-658 N207MDGv Air Inc · Medford, ORBuilt 1976 · S/N 31-7612092 N2084PSchalk Bretta J · Fountain Run, KYBuilt 1956 · S/N 23-672 N208SEJohn Stuart LLC · Miramar, FLS/N 27-4542 N2090American Valet Air Inc · Wilmington, DEBuilt 1981 · S/N 27-8154010 N2095PForbes Richard L · Plano, TXBuilt 1956 · S/N 23-683 N2098PRegistration Pending · Granger, IARegistration pendingS/N 23-686 N20ALilbit Industries LLC · Oklahoma City, OKBuilt 1955 · S/N 23-396 N20BBSteller Air Charter LLC · Jacksonville, FLBuilt 1983 · S/N 31P-8414005 N20BUN20bu LLC · Champaign, ILBuilt 1977 · S/N 27-7754063 N20DMLowe Aviation Co · Macon, GABuilt 1973 · S/N 27-7305066 N20LXLockheed Martin Corporation · Palmdale, CABuilt 1975 · S/N 31-7552121 N20WLSch Aviation Inc Trustee · Sporle Kings LynnBuilt 1976 · S/N 31T-7720011 N2108PGlover William S · Mount Pleasant, TXBuilt 1956 · S/N 23-698 N2112HAir V Inc Trustee · Wilmington, DEBuilt 1977 · S/N 27-7754121 N2112PHardin John M · Terrell, TXBuilt 1956 · S/N 23-703 N211TNScruggs Ken · Galloway, OHBuilt 1975 · S/N 27-7554037 N212KSKilo Sierra LLC · Dodge City, KSBuilt 1979 · S/N 31T-7904010 N212RAAbin Ricardo · Miami Lakes, FLBuilt 1977 · S/N 317712057 N213ACRtb Transport LLC · Evans, GABuilt 1984 · S/N 31-8452011 N21406Makushin Logistics LLC · Fairbanks, AKS/N 31-7752117 N2141PElliott David E · Peyton, COBuilt 1956 · S/N 23-734 N214HSDelaware Aircraft Trust LLC Trustee · New Castle, DEBuilt 1975 · S/N 27-7654014 N2150PWoodard Mark A · Hookstown, PABuilt 1956 · S/N 23-752 N2162PLark Aircraft Leasing · Port Townsend, WABuilt 1956 · S/N 23-764 N2163PCarroll Bodo W · Franklin, OHBuilt 1956 · S/N 23-765 N2168PSmith Kevin L · Peachtree City, GAS/N 23-773 N2172PRiggin Flight Service Inc · Madison, SDBuilt 1956 · S/N 23-778 N2177PMidwest Environmental Products Inc · Wichita, KSBuilt 1956 · S/N 23-783 N2190PN2190p LLC · Titusville, FLS/N 23-799 N2195PZahlmann Daniel R · Queen Creek, AZS/N 23-803 N2198PAerotrack Inc · Hemet, CABuilt 1956 · S/N 23-808 N2199PPowers Edward · Stormville, NYS/N 23-809

Back to AD 2009-13-06 R1