OpenAirDocs.org
AD 2000-10-07

Registered aircraft · 28

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-10-07')
    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-10-07')
  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.

N102HNAir Methods LLC · Greenwood Village, COBuilt 2000 · S/N 0159N109BCBroward County Sheriffs Office · Fort Lauderdale, FLBuilt 1999 · S/N 0139N135BUMetro Aviation Inc · Shreveport, LABuilt 1997 · S/N 0015N135DHMetro Aviation Inc · Shreveport, LABuilt 1999 · S/N 0133N135MHBay Life Services Corp · Columbia, MDBuilt 2000 · S/N 0131N135NMh Hospital Manager LLC · Asheville, NCBuilt 1998 · S/N 0086N137MHMetro Aviation Inc · Shreveport, LABuilt 2002 · S/N 0179N158BCMetro Aviation Inc · Shreveport, LABuilt 1999 · S/N 0134N162MWBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 0162N200UPKmv Leasing LLC · Shreveport, LABuilt 1999 · S/N 0089N235AMAir Methods LLC · Greenwood Village, COS/N 0140N235DHMetro Aviation Inc · Shreveport, LABuilt 1999 · S/N 0058N356MPAltair Helicopter Service LLC · Marshfield, MABuilt 2000 · S/N 0163N640ECMetro Aviation Inc · Shreveport, LABuilt 1998 · S/N 0064N831LFInhs Leasing Co LLC · Aurora, ORBuilt 1998 · S/N 0073N891TTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1998 · S/N 0051N892TTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1998 · S/N 0052N911AXGuardian Flight Holdings Inc · Fairbanks, AKBuilt 1997 · S/N 0021N911CKEurotec Vertical Flight Solutions LLC · Eudora, KSBuilt 2000 · S/N 0138N911KBMetro Aviation Inc · Shreveport, LABuilt 1999 · S/N 0095N911XAAir Med Services LLC · Lafayette, LABuilt 2000 · S/N 0132N911XBAir Med Services LLC · Lafayette, LABuilt 2000 · S/N 0154N911XCMetro Aviation Inc · Shreveport, LABuilt 2000 · S/N 0143N911XFAir Med Services LLC · Lafayette, LABuilt 2000 · S/N 0167N911XGAir 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 0164N914ETEast Texas Air One LLC · Nashville, TNBuilt 1997 · S/N 0018
Back to AD 2000-10-07