Skip to content

AD 2007-19-09 R1

Registered aircraft · 313

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:2007-19-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:2007-19-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:2007-19-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:2007-19-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:2007-19-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:2007-19-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.

N3931ADepartment Of Homeland Security · Washington, DCBuilt 2009 · S/N 4697 N3933ADepartment Of Homeland Security · Washington, DCBuilt 2009 · S/N 4669 N3934ADepartment Of Homeland Security · Washington, DCS/N 4713 N3935ADepartment Of Homeland Security · Washington, DCS/N 4768 N3937ADepartment Of Homeland Security · Washington, DCBuilt 2009 · S/N 4796 N3938ADepartment Of Homeland Security · Washington, DCS/N 4804 N3939ADept Of Homeland Security Customs & Border · Washington, DCBuilt 2009 · S/N 4806 N3940ADepartment Of Homeland Security · Washington, DCBuilt 2009 · S/N 4815 N3944ADepartment Of Homeland Security · Washington, DCBuilt 2009 · S/N 4818 N3946ADepartment Of Homeland Security · Washington, DCBuilt 2009 · S/N 4706 N3947ADepartment Of Homeland Security · Washington, DCBuilt 2010 · S/N 4905 N3949ADepartment Of Homeland Security · Washington, DCBuilt 2010 · S/N 4952 N3951AUS Department Of Homeland Security · Washington, DCBuilt 2010 · S/N 4993 N3953AUS Department Of Homeland Security · Washington, DCBuilt 2010 · S/N 7004 N3972AUS Department Of Homeland Security · Washington, DCBuilt 2010 · S/N 7082 N3983AUS Department Of Homeland Security · Washington, DCBuilt 2011 · S/N 7101 N401MFDare County · Manteo, NCBuilt 2015 · S/N 20024 N401RMRegional Air Medical Services Inc. · Jasper, ALBuilt 2004 · S/N 3837 N402JCJefferson County Sheriffs Office · Birmingham, ALBuilt 2006 · S/N 4184 N411LHApex Aeronautical · San Antonio, TXBuilt 2009 · S/N 4667 N418TYAir Methods LLC · Greenwood Village, COBuilt 2006 · S/N 4180 N4204Air Methods LLC · Greenwood Village, COBuilt 2007 · S/N 4204 N425AMFirst-Citizens Bank & Trust Co · Morristown, NJBuilt 2011 · S/N 7264 N4282Air Methods LLC · Greenwood Village, COBuilt 2007 · S/N 4282 N440RMRegional Air Medical Services Inc · Jasper, ALBuilt 2010 · S/N 7017 N4497YAir Methods LLC · Greenwood Village, COBuilt 2008 · S/N 4497 N44DSDs Air II LLC · Carrollton, VABuilt 2003 · S/N 6615 N455GFAdventaire LLC · Minot, NDBuilt 2010 · S/N 4932 N456AEEurotec Vertical Flight Solutions LLC · Eudora, KSBuilt 2001 · S/N 3492 N464RMRegional Air Medical Services Inc · Jasper, ALBuilt 2005 · S/N 3962 N484FAFreedom Aviation LLC · Helena, MTBuilt 2008 · S/N 4499 N490HAir Methods LLC · Greenwood Village, COBuilt 2008 · S/N 4539 N498AEPhi Health LLC · Tempe, AZBuilt 2003 · S/N 3687 N4PAPylon Aviation Services LLC · Chandler, AZBuilt 2005 · S/N 3920 N500KVPortland General Electric Co · Portland, ORBuilt 2008 · S/N 4638 N506LFAir Methods LLC · Greenwood Village, COBuilt 2010 · S/N 4973 N507AMAir Methods LLC · Greenwood Village, COBuilt 2009 · S/N 4711 N508AMAir Methods LLC · Greenwood Village, COBuilt 2009 · S/N 4682 N530HBas Part Sales LLC · Greeley, COBuilt 2008 · S/N 4553 N533AMAir Methods LLC · Greenwood Village, COBuilt 2008 · S/N 4620 N538FSBayou Skys LLC · Wilmington, DEBuilt 2008 · S/N 4478 N54178Air Methods LLC · Greenwood Village, COBuilt 2006 · S/N 4178 N54315Discovery Helicopters LLC · Las Vegas, NVS/N 4315 N544AMAir Methods LLC · Greenwood Village, COBuilt 2007 · S/N 4206 N544ASApexheli Oregon Inc · Florence, ORBuilt 2001 · S/N 3367 N545HFHaynes Aviation LLC · Wetumpka, ALBuilt 2006 · S/N 4123 N551AMAir Methods LLC · Greenwood Village, COBuilt 2007 · S/N 4311 N555VTArlo Air LLC · Columbus, OHBuilt 2010 · S/N 4988 N556SDHarris County Sheriffs Office · Houston, TXBuilt 2011 · S/N 7086 N55GJCfa Holdings Inc · Knoxville, TNBuilt 2003 · S/N 3745

Back to AD 2007-19-09 R1