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.

N32RWSkylens LLC · Hammond, LABuilt 1971 · S/N 27-4667 N32SBCook Robert W · Belair, MDBuilt 1976 · S/N 31-7612098 N3301PDramstad Flying Service LLC · Helena, MTBuilt 1958 · S/N 23-1251 N3304PBucket List Aviation LLC · San Jose, CABuilt 1958 · S/N 23-1254 N3305PAir Royal · Middletown, DEBuilt 1958 · S/N 23-1255 N3307PAlbano James R · Oakham, MAFirst renewal noticeBuilt 1958 · S/N 23-1257 N3316PCrew Sourcing Inc · Wilmington, DEBuilt 1958 · S/N 23-1267 N331NCRise Aircraft 1 LLC · Tomball, TXBuilt 1984 · S/N 31P8414046 N3326PDean Marshall H · El Paso, TXBuilt 1958 · S/N 23-1277 N3329PStradley Anna M Trustee · Bozeman, MTBuilt 1958 · S/N 23-1280 N332SAPharmair LLC · Jackson, MSBuilt 1985 · S/N 42-5527025 N3339PGeorge James Cooper · Lenoir, NCBuilt 1958 · S/N 23-1291 N333EJCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1975 · S/N 31-7652055 N333FSAerodrome LLC · Louisville, KYBuilt 1969 · S/N 27-4456 N333HFValiair Lc Trustee · Casper, WYS/N 31-8152097 N333JDDouglas Aero Inc · Fort Lauderdale, FLBuilt 1980 · S/N 27-8054016 N333PBBourne Hoppe & Associates LLC · Midland, MIBuilt 1975 · S/N 27-7654013 N333PRGriffin Wings LLC · Lithia, FLBuilt 1973 · S/N 31-7305112 N333VAXrrx Inc · Wilmington, DEBuilt 1978 · S/N 27-7854099 N333XXArnot Robert · Stowe, VTS/N 31T-7920038 N3341PDahl Troy M · Cedar Rapids, IABuilt 1958 · S/N 23-1294 N3346PDramstad Flying Service LLC · Helena, MTS/N 23-1299 N334RPRegistration Pending · Seneca, SCRegistration pendingBuilt 1980 · S/N 31-8052071 N3353PHeffron Jacob L · Little Falls, MNBuilt 1958 · S/N 23-1308 N3363PDubois Aviation Inc · Chino, CABuilt 1958 · S/N 23-1320 N3366Sutton Aircraft Salvage LLC · Palmer, AKS/N 23-1919 N3367PJackson Lee Roy Jr · Needville, TXBuilt 1958 · S/N 23-1324 N336PN336p LLC · Williamstown, NJBuilt 1974 · S/N 31T-7400003 N3377PFlying High LLC · Gore, VABuilt 1958 · S/N 23-1337 N3388PMorrison Maria · Port Townsend, WABuilt 1958 · S/N 23-1351 N3389PLapeyrouse Charles L · Raceland, LABuilt 1958 · S/N 23-1352 N338SSSieli Paul III · Griffin, GAS/N 27-224 N339CTPatel Niral G · Atlanta, GABuilt 1974 · S/N 27-7405350 N33RWSpencer Joseph C · Asheboro, NCBuilt 1960 · S/N 23-1948 N33SAMcwherter Holdings Inc · Asheboro, NCS/N 27-3370 N33TLPaloma Uno LLC · Stuart, FLBuilt 1975 · S/N 31-7512043 N33URAthena Aviation LLC · Golden, MSBuilt 1980 · S/N 318052097 N3403PCarper Ryan W · Marietta, OHBuilt 1958 · S/N 23-1367 N341CACovenant Air LLC · Wilmington, DEBuilt 1979 · S/N 31-7952243 N341CHAce Flight Center Inc · St Thomas, VIBuilt 1980 · S/N 27-8154006 N3420PKeyuravong Pisonth · Anchorage, AKBuilt 1958 · S/N 23-1384 N3430PChamberlain Paul E · Troup, TXBuilt 1958 · S/N 23-1396 N3434PNasair LLC · Flower Mound, TXBuilt 1958 · S/N 23-1401 N3442POttmann Robert · Indialantic, FLBuilt 1958 · S/N 23-1410 N3447PSimonovich Sheldon K · Fredericksburg, VABuilt 1958 · S/N 23-1418 N3448PDabney Richard W · Tanner, ALBuilt 1958 · S/N 23-1419 N3456PBels Holdings LLC · Albert Lea, MNBuilt 1958 · S/N 23-1428 N3457PSewade Dawn M · New River, AZBuilt 1958 · S/N 23-1429 N345JGGo Fly Inc · Spring Hill, FLBuilt 1959 · S/N 23-1825 N3468PHilligoss Forrest R · Brownsburg, INBuilt 1958 · S/N 23-1442

Back to AD 2009-13-06 R1