AD 2000-08-12

Registered aircraft · 273

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:2000-08-12')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-08-12')
  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.

N613FEFederal Express Corp · Memphis, TNBuilt 1996 · S/N 48749N614FEFederal Express Corp · Memphis, TNBuilt 1992 · S/N 48528N615FEFederal Express Corp · Memphis, TNBuilt 1996 · S/N 48767N616FEFederal Express Corp · Memphis, TNBuilt 1995 · S/N 48747N617AZAmazon.Com Services LLC · Seattle, WABuilt 2001 · S/N 30575N617FEFederal Express Corp · Memphis, TNBuilt 1995 · S/N 48748N618FEFederal Express Corp · Memphis, TNBuilt 1996 · S/N 48754N619AZAmazon.Com Services LLC · Seattle, WABuilt 2000 · S/N 30594N619FEFederal Express Corp · Memphis, TNBuilt 1996 · S/N 48770N641AZAmazon.Com Services LLC · Seattle, WABuilt 2000 · S/N 30595N643AZAmazon.Com Services LLC · Seattle, WABuilt 2001 · S/N 32776N649GTAtlas Air Inc · Purchase, NYBuilt 1992 · S/N 25864N650FEFederal Express Corp · Memphis, TNBuilt 1993 · S/N 726N651FEFederal Express Corporation · Memphis, TNBuilt 1994 · S/N 728N652FEFederal Express Corp · Memphis, TNBuilt 1994 · S/N 735N653FEFederal Express Corp · Memphis, TNBuilt 1994 · S/N 736N654FEFederal Express Corp · Memphis, TNBuilt 1994 · S/N 738N655FEFederal Express Corp · Memphis, TNBuilt 1994 · S/N 742N656GTJetran LLC · Horseshoe Bay, TXBuilt 1984 · S/N 23017N657GTJetran LLC · Horseshoe Bay, TXBuilt 1984 · S/N 23018N658FEFederal Express Corp · Memphis, TNBuilt 1995 · S/N 752N659FEFederal Express Corp · Memphis, TNBuilt 1995 · S/N 757N659GTJetran LLC · Horseshoe Bay, TXBuilt 1984 · S/N 23140N66051United Airlines Inc · Chicago, ILBuilt 2000 · S/N 29446N66056United Airlines Inc · Chicago, ILBuilt 2001 · S/N 29451N66057United Airlines Inc · Chicago, ILBuilt 2002 · S/N 29452N660FEFederal Express Corp · Memphis, TNBuilt 1995 · S/N 759N661FEFederal Express Corp · Memphis, TNBuilt 1995 · S/N 760N662FEFederal Express Corp · Memphis, TNBuilt 1996 · S/N 761N663FEFederal Express Corporation · Memphis, TNBuilt 1995 · S/N 766N664FEFederal Express Corp · Memphis, TNBuilt 1995 · S/N 768N664GTTitan Aviation Leasing Ltd Americas Inc · Purchase, NYBuilt 1994 · S/N 26259N665FEFederal Express Corp · Memphis, TNBuilt 1996 · S/N 769N667FEFederal Express Corporation · Memphis, TNBuilt 1996 · S/N 771N668FEFederal Express Corp · Memphis, TNBuilt 1996 · S/N 772N669FEFederal Express Corp · Memphis, TNBuilt 1996 · S/N 774N67052United Airlines Inc · Chicago, ILBuilt 2000 · S/N 29447N67058United Airlines Inc · Chicago, ILBuilt 2002 · S/N 29453N671FEFederal Express Corp · Memphis, TNBuilt 1997 · S/N 778N672FEFederal Express Corp · Memphis, TNBuilt 1997 · S/N 779N673FEFederal Express Corp · Memphis, TNBuilt 1997 · S/N 780N674FEFederal Express Corp · Memphis, TNBuilt 1997 · S/N 781N675FEFederal Express Corporation · Memphis, TNBuilt 1998 · S/N 789N676FEFederal Express Corp · Memphis, TNBuilt 1998 · S/N 790N677FEFederal Express Corp · Memphis, TNBuilt 1998 · S/N 791N678FEFederal Express Corp · Memphis, TNBuilt 1998 · S/N 792N679FEFederal Express Corp · Memphis, TNBuilt 1998 · S/N 793N68061United Airlines Inc · Chicago, ILBuilt 2002 · S/N 29456N680FEFederal Express Corp · Memphis, TNBuilt 1998 · S/N 794N681FEFederal Express Corporation · Memphis, TNBuilt 1999 · S/N 0799
Back to AD 2000-08-12