OpenAirDocs.org
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
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.

N858MHMustang Leasing LLC · Henderson, NVBuilt 2008 · S/N 4503N859HWMed-Trans Corp · Denton, TXBuilt 2012 · S/N 7419N85SKEc 130 LLC · Sterling, VABuilt 2012 · S/N 7388N862MHMustang Leasing LLC · Henderson, NVBuilt 2008 · S/N 4545N863MHMustang Leasing LLC · Henderson, NVBuilt 2008 · S/N 4570N864MHMustang Leasing LLC · Henderson, NVBuilt 2008 · S/N 4616N867MHMustang Leasing LLC · Henderson, NVBuilt 2009 · S/N 4770N868MHMustang Leasing LLC · Henderson, NVBuilt 2009 · S/N 4797N889AETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2010 · S/N 4959N893PARainier Heli International Inc · Kirkland, WABuilt 2009 · S/N 4679N894PAJuliet Inc · Kirkland, WABuilt 2009 · S/N 4687N8959SJuliet Inc · Kirkland, WABuilt 2007 · S/N 4232N898JFState Of Montana · Helena, MTBuilt 2007 · S/N 4120N901CFRegional Emergency Medical Services Authority · Reno, NVBuilt 2006 · S/N 4160N908PSTrevor Corp DBA · Grayslake, ILBuilt 2006 · S/N 4177N90DKDekalb County Police · Tucker, GABuilt 2004 · S/N 3807N910UAir Methods LLC · Greenwood Village, COBuilt 2001 · S/N 3470N911WLPlacer County Public Financing Authority · Auburn, CABuilt 2008 · S/N 4587N911XCMetro Aviation Inc · Shreveport, LABuilt 2000 · S/N 0143N913SMSisters Of Charity Of Leavenworth Health Systems · Grand Junction, COBuilt 2008 · S/N 4600N917ZBighorn Holdings LLC · Mccall, IDBuilt 2005 · S/N 4042N919SFAir Er LLC · Corinth, TXBuilt 1991 · S/N 760370N91NSNs Air Leasing LLC · Wilmington, DEBuilt 2010 · S/N 7035N920UAir Methods LLC · Greenwood Village, COBuilt 2001 · S/N 3453N922BFRiverbend Enterprises Inc · Idaho Falls, IDBuilt 2006 · S/N 4084N945DCJs Leasing LLC · Frisco, TXBuilt 2015 · S/N 20059N970AEPhi Health LLC · Tempe, AZBuilt 1999 · S/N 3235N970WEWest Elk Air LLC · Gunnison, COBuilt 2005 · S/N 4037N973AEPhi Health LLC · Tempe, AZBuilt 1999 · S/N 3229N979AMAir Methods LLC · Greenwood Village, COBuilt 2012 · S/N 7481N979CCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2017 · S/N 20161N994SDCounty Of Riverside California · Hemet, CABuilt 2007 · S/N 4240N99523Ns Air Leasing LLC · Wilmington, DEBuilt 2001 · S/N 3461
Back to AD 2009-09-03 R1