OpenAirDocs.org
AD 2003-19-06

Registered aircraft · 34

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
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-19-06')
    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-19-06')
  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.

N109BCBroward County Sheriffs Office · Fort Lauderdale, FLBuilt 1999 · S/N 0139N120CRRomana Aircraft Inc · High Point, NCBuilt 2000 · S/N 1128N122THMwn Holdings LLC · Saint Louis, MOBuilt 1998 · S/N 1017N123RTMather Air LLC · Paris, KYBuilt 2004 · S/N 3841N127ABApexheli Oregon Inc · Florence, ORBuilt 2000 · S/N 3331N135MHBay Life Services Corp · Columbia, MDBuilt 2000 · S/N 0131N136MFAir Methods LLC · Greenwood Village, COBuilt 2005 · S/N 0384N136VAAir Methods LLC · Greenwood Village, COBuilt 2003 · S/N 0281N139MHMetro Aviation Inc · Shreveport, LABuilt 2004 · S/N 0330N200UPKmv Leasing LLC · Shreveport, LABuilt 1999 · S/N 0089N2171CNs Air Leasing LLC · Wilmington, DEBuilt 2001 · S/N 3427N334HFHaynes Aviation LLC · Wetumpka, ALS/N 3676N354PAPathfinder Leasing LLC · Anchorage, AKBuilt 2000 · S/N 3330N356MPAltair Helicopter Service LLC · Marshfield, MABuilt 2000 · S/N 0163N403AETemsco Helicopters Inc · Ketchikan, AKBuilt 2000 · S/N 3281N418MDMountain Air Helicopters Inc · Dover, DEBuilt 2004 · S/N 3848N504LHAir Methods LLC · Greenwood Village, COBuilt 2005 · S/N 0382N60ZXTonik Air LLC · Las Vegas, NVBuilt 1998 · S/N 0039N775TCUS Department Of Homeland Security · Washington, DCBuilt 2002 · S/N 3622N802MHWorld Trade Enterprises LLC · Lucas, TXBuilt 2003 · S/N 3707N845BPUS Department Of Homeland Security · Washington, DCBuilt 2001 · S/N 3464N846BPUS Department Of Homeland Security · Washington, DCBuilt 2002 · S/N 3542N856BPUS Department Of Homeland Security · Washington, DCBuilt 2002 · S/N 3617N877CRAir Methods LLC · Greenwood Village, COBuilt 2007 · S/N 0625N891TTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1998 · S/N 0051N892TTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1998 · S/N 0052N89EMIntegra Aviation LLC · Amarillo, TXBuilt 1998 · S/N 0049N911AXGuardian Flight Holdings Inc · Fairbanks, AKBuilt 1997 · S/N 0021N911XAAir Med Services LLC · Lafayette, LABuilt 2000 · S/N 0132N911XBAir Med Services LLC · Lafayette, LABuilt 2000 · S/N 0154N911XGAir Med Services LLC · Lafayette, LABuilt 2000 · S/N 0157N911XHAir Med Services LLC · Lafayette, LABuilt 2000 · S/N 0161N911ZGGuardian Flight Holdings Inc · Fairbanks, AKBuilt 2001 · S/N 0164N91LFInternational Defense & Aerospace Group LLC · Glen Mills, PABuilt 2002 · S/N 11509
Back to AD 2003-19-06