Skip to content

AD 2009-09-03 R1

Registered aircraft · 333

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-09-03-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-09-03-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-09-03-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-09-03-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-09-03-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-09-03-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.

N101VUAir Methods LLC · Greenwood Village, COBuilt 2003 · S/N 9039 N104LNPathfinder Leasing LLC · Anchorage, AKBuilt 2006 · S/N 4094 N109LNAir Methods LLC · Greenwood Village, COBuilt 2005 · S/N 3995 N118LNAir Methods LLC · Greenwood Village, COBuilt 2007 · S/N 4214 N118MBMountain Air Helicopters Inc · Dover, DEBuilt 2002 · S/N 3535 N11QANevada Helicopter Leasing LLC · Greenwoodvillage, COBuilt 2004 · S/N 3887 N11QCNevada Helicopter Leasing LLC · Greenwood Village, COBuilt 2001 · S/N 3358 N11QENevada Helicopter Leasing LLC · Greenwood Village, COBuilt 2001 · S/N 3381 N11QFNevada Helicopter Leasing LLC · Greenwood Village, COBuilt 2002 · S/N 3482 N11QHNevada Helicopter Leasing LLC · Greenwood Village, COBuilt 2002 · S/N 3561 N11QJNevada Helicopter Leasing LLC · Greenwood Village, COBuilt 2008 · S/N 4528 N11QKNevada Helicopter Leasing LLC · Greenwood Village, COBuilt 2002 · S/N 3639 N11QLNevada Helicopter Leasing LLC · Greenwood Village, COBuilt 2003 · S/N 3738 N11QMNevada Helicopter Leasing LLC · Greenwood Village, COBuilt 2003 · S/N 3751 N11QNNevada Helicopter Leasing LLC · Greenwood Village, COBuilt 2003 · S/N 3758 N11QPNevada Helicopter Leasing LLC · Greenwood Village, COBuilt 2009 · S/N 4715 N11QRNevada Helicopter Leasing LLC · Greenwood Village, COBuilt 2005 · S/N 3992 N11QUNevada Helicopter Leasing LLC · Greenwood Village, COBuilt 2009 · S/N 4758 N11QWNevada Helicopter Leasing LLC · Greenwood Village, COBuilt 2010 · S/N 4929 N11QXNevada Helicopter Leasing LLC · Greenwood Village, COBuilt 2011 · S/N 7198 N11QYNevada Helicopter Leasing LLC · Greenwood Village, COBuilt 2011 · S/N 7229 N11QZNevada Helicopter Leasing LLC · Greenwood Village, COBuilt 2008 · S/N 4663 N126PJHelibro LLC · Red Bluff, CABuilt 2010 · S/N 7039 N127PJHelibro LLC · Red Bluff, CABuilt 2011 · S/N 7180 N130BUOhio Medical Transportation Inc · Columbus, OHBuilt 2011 · S/N 7132 N130CLOhio Medical Transportation Inc · Columbus, OHBuilt 2012 · S/N 7499 N130CRRomana Aircraft Inc · High Point, NCBuilt 2007 · S/N 4271 N130CZOrbic Air LLC · Burbank, CABuilt 2006 · S/N 4060 N130EEBuckeye Leasing LLC · Shreveport, LABuilt 2011 · S/N 7190 N130GCMonarch Enterprises Inc · Kirkland, WABuilt 2002 · S/N 3562 N130GMBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 4837 N130HBOhio Medical Transportation Inc · Columbus, OHBuilt 2011 · S/N 7167 N130JVOhio Medical Transportation Inc · Columbus, OHBuilt 2012 · S/N 7490 N130KHOhio Medical Transportation Inc · Columbus, OHBuilt 2011 · S/N 7142 N130KJJackson Family Wines Inc · Santa Rosa, CABuilt 2004 · S/N 3873 N130KRAir Methods LLC · Greenwood Village, COBuilt 2012 · S/N 7317 N130LHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 4017 N130LLEffort Aviation LLC · Wilmington, DEBuilt 2012 · S/N 7375 N130MDEc 130 II LLC · Sterling, VABuilt 2012 · S/N 7549 N130MUOhio Medical Transportation Inc · Columbus, OHBuilt 2011 · S/N 7103 N130NBBuckeye Leasing LLC · Shreveport, LABuilt 2011 · S/N 7221 N130NWOhio Medical Transportation Inc · Columbus, OHBuilt 2011 · S/N 7182 N130PFOrlando Helicopter Partners LLC · Orlando, FLBuilt 2009 · S/N 4760 N130SMInternational Air Services Inc Trustee · Carson City, NVBuilt 2007 · S/N 4276 N130WSWorld Trade Enterprises LLC · Lucas, TXBuilt 2003 · S/N 3735 N131GCRainier Heli International Inc · Kirkland, WABuilt 2003 · S/N 3691 N132BHBrainerd Helicopters Inc · Leesburg, FLBuilt 2007 · S/N 4374 N132GCAmerican Helicopters LLC · Kirkland, WABuilt 2003 · S/N 3756 N132LNAir Methods LLC · Greenwood Village, COBuilt 2005 · S/N 3970 N132WSSunshine Helicopters Inc · Puunene, HIBuilt 2002 · S/N 3527

Back to AD 2009-09-03 R1