Skip to content

AD 2003-09-09 R1

Registered aircraft · 176

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:2003-09-09-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:2003-09-09-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:2003-09-09-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:2003-09-09-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:2003-09-09-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:2003-09-09-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.

N102ADEpic Crew LLC · Fort Worth, TXBuilt 1983 · S/N 4410311 N112CZDelta Delta Papa LLC · Fort Lauderdale, FLBuilt 1981 · S/N 441-0233 N11MMN11mm LLC · Anchorage, AKBuilt 1979 · S/N 441-0105 N1212CDodson International Parts Inc · Rantoul, KSBuilt 1985 · S/N 441-0346 N123HLEfinance LLC · Wichita, KSS/N 441-0010 N128EZN128ez LLC · Anchorage, AKBuilt 1979 · S/N 441-0128 N13NWCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1979 · S/N 441-0090 N14FJLand Safely LLC · Tinton Falls, NJBuilt 1980 · S/N 441-0118 N14NWCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1980 · S/N 4410171 N14TA35th Terrace LLC · Wellington, FLBuilt 1980 · S/N 441-0168 N15DBN15db LLC · Bend, ORBuilt 1981 · S/N 441-0278 N169MFCommodore Aviation LLC · Palm Beach, FLBuilt 1981 · S/N 441-0221 N16FJRaven Air LLC · Hotchkiss, COBuilt 1978 · S/N 441-0067 N16NWCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1978 · S/N 441-0045 N17CKAgape Flights Inc · Venice, FLBuilt 1985 · S/N F4060001 N17TJSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1980 · S/N 441-0165 N1880APlaneco LLC · Lincoln, NEBuilt 1978 · S/N 441-0080 N191MGN191mg LLC · New Bedford, MAS/N 4410315 N207SSTm Aero LLC · Riverview, FLBuilt 1980 · S/N 441-0136 N20WEEvans Phyllis H Trustee · Riverside, CABuilt 1980 · S/N 441-0160 N226MKN226mk Corp Trustee · Wilmington, DEBuilt 2018 · S/N 441-0209 N22CG316 Extreme LLC · Basalt, COBuilt 1979 · S/N 441-0119 N233PJLwkimber Interests Management LLC · Houston, TXBuilt 1986 · S/N 441-0362 N233RCRico Marketing Corporation · Flint, MIBuilt 1982 · S/N 441-0263 N23NWCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1978 · S/N 441-0066 N2441KCarpe Caelum LLC · Joplin, MOBuilt 1978 · S/N 441-0053 N24PTN24pt LLC · Winter Park, FLBuilt 1977 · S/N 4410015 N253SBN253sb Shares LLC · Liberal, KSS/N 4410258 N2725NWisconsin Aviation Four Lakes Inc · Madison, WIBuilt 1980 · S/N 441-0190 N274GCPro Aviation II LLC · Ogden, UTBuilt 1985 · S/N 441-0349 N27NWCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1987 · S/N 008 N295CEConquest 295 LLC · Indianapolis, INS/N 441-0205 N2NQSurdex Corp · Chesterfield, MOBuilt 1982 · S/N 441-0307 N313JMFlatiron Air LLC · Hotchkiss, COBuilt 1983 · S/N 441-0312 N316TTThompson Aviation LLC · Dennis, TXBuilt 1986 · S/N 441-0360 N317BCAsc Aviation LLC · Kalispell, MTBuilt 1983 · S/N 441-0317 N318AKN318ak LLC · Anchorage, AKBuilt 1978 · S/N 441-0070 N322PBellagray LLC · Helotes, TXBuilt 1981 · S/N 441-0274 N326RSSchlabach Herman · Belton, TXBuilt 1983 · S/N 441-0326 N331TSAircraft Propulsion Leasing LLC · Holland, OHS/N 441-0264 N332DMKm Aviation LLC · Overland Park, KSBuilt 1980 · S/N 441-0167 N337KCN337kc LLC · Wichita, KSBuilt 1985 · S/N 441-0337 N381SBLac Aero LLC · Liberal, KSBuilt 1983 · S/N 441-0323 N383SSJoseph Skilken & Co Inc · Columbus, OHBuilt 1980 · S/N 441-0161 N389SBN389sb LLC · Liberal, KSBuilt 1977 · S/N 441-0011 N406SDTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1991 · S/N 0063 N406WTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N F4060043 N410MFCcii Mt Lc · Darby, MTBuilt 1979 · S/N 441-0093 N419SCZeplane LLC · Miami, FLBuilt 1980 · S/N 441-0149 N41NVNorth Valley Air Ltd · St Thomas, VIBuilt 1982 · S/N 4410268

Back to AD 2003-09-09 R1