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.

N794AMUS Department Of Homeland Security · Washington, DCBuilt 2008 · S/N 4440 N796AMUS Department Of Homeland Security · Washington, DCBuilt 2008 · S/N 4550 N7ZSRogue Mountain LLC · Whitefish, MTBuilt 2007 · S/N 4361 N801MHSunshine Helicopters Inc · Puunene, HIBuilt 2002 · S/N 3654 N804CPBaltimore County Government · Baltimore, MDBuilt 2006 · S/N 4133 N804PAPathfinder Leasing LLC · Anchorage, AKBuilt 2004 · S/N 3782 N805BTBeta Fleet LLC · South Burlington, VTBuilt 2002 · S/N 3563 N805LFAir Methods LLC · Greenwood Village, COBuilt 2009 · S/N 4559 N805MHAirstar Leasing LLC · Henderson, NVBuilt 2004 · S/N 3799 N806MHAirstar Leasing LLC · Henderson, NVBuilt 2004 · S/N 3833 N806MPNs Air Leasing LLC · Wilmington, DEBuilt 2008 · S/N 4504 N806PAPathfinder Leasing LLC · Anchorage, AKBuilt 2002 · S/N 3635 N807AMUS Department Of Homeland Security · Washington, DCBuilt 2008 · S/N 4592 N807LFAir Methods LLC · Greenwood Village, COBuilt 2010 · S/N 4928 N807MHAirstar Leasing LLC · Henderson, NVBuilt 2005 · S/N 3912 N807MLRio Bravo Helicopters Inc · Dover, DEBuilt 2008 · S/N 4411 N808CPBaltimore County Government · Baltimore, MDBuilt 2006 · S/N 4151 N808LFAir Methods LLC · Greenwood Village, COBuilt 2010 · S/N 4983 N808MHAirstar Leasing LLC · Henderson, NVBuilt 2005 · S/N 3914 N810CESouthern California Edison · Chino, CABuilt 2006 · S/N 4112 N810LFAir Methods LLC · Greenwood Village, COBuilt 2010 · S/N 7015 N811HWMed-Trans Corp · Denton, TXBuilt 2012 · S/N 7425 N814SMAir Methods LLC · Greenwood Village, COBuilt 2010 · S/N 7012 N816CESouthern California Edison Co · Chino, CABuilt 2009 · S/N 4724 N817CESouthern California Edison Co · Chino, CABuilt 2007 · S/N 4209 N818HAHelinet Aviation Services LLC · Van Nuys, CABuilt 2005 · S/N 3901 N821MHMustang Leasing LLC · Henderson, NVBuilt 2006 · S/N 4134 N822MHMustang Leasing LLC · Henderson, NVBuilt 2006 · S/N 4142 N823MHMustang Leasing LLC · Henderson, NVBuilt 2006 · S/N 4158 N837GCMonarch Enterprises Inc · Kirkland, WABuilt 2008 · S/N 4637 N844BPUS Department Of Homeland Security · Washington, DCBuilt 2001 · S/N 3405 N846MHMustang Leasing LLC · Henderson, NVBuilt 2007 · S/N 4248 N847BPUS Department Of Homeland Security · Washington, DCBuilt 2002 · S/N 3545 N847MHMustang Leasing LLC · Henderson, NVBuilt 2007 · S/N 4266 N848MHMustang Leasing LLC · Henderson, NVBuilt 2007 · S/N 4290 N849BPUS Department Of Homeland Security · Washington, DCBuilt 2002 · S/N 3554 N849MHMustang Leasing LLC · Henderson, NVBuilt 2007 · S/N 4313 N850BPUS Department Of Homeland Security · Washington, DCBuilt 2002 · S/N 3584 N850MHMustang Leasing LLC · Henderson, NVBuilt 2007 · S/N 4327 N851MHMustang Leasing LLC · Henderson, NVBuilt 2007 · S/N 4340 N852MHMustang Leasing LLC · Henderson, NVBuilt 2007 · S/N 4356 N853BPUS Department Of Homeland Security · Washington, DCBuilt 2002 · S/N 3595 N853MHMustang Leasing LLC · Henderson, NVBuilt 2008 · S/N 4417 N854BPUS Department Of Homeland Security · Washington, DCBuilt 2002 · S/N 3598 N854MHMustang Leasing LLC · Henderson, NVBuilt 2008 · S/N 4433 N855PANs Air Leasing LLC · Wilmington, DEBuilt 2000 · S/N 3304 N856HWHaynes Aviation LLC · Wetumpka, ALBuilt 2010 · S/N 4908 N856MHMustang Leasing LLC · Henderson, NVBuilt 2008 · S/N 4437 N857MHMustang Leasing LLC · Henderson, NVBuilt 2008 · S/N 4457 N858HWMed-Trans Corp · Denton, TXBuilt 2012 · S/N 7404

Back to AD 2009-09-03 R1