OpenAirDocs.org
AD 2000-23-52

Registered aircraft · 134

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-23-52')
    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-23-52')
  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.

N576DTArea 109 LLC · Brooklyn, NYBuilt 2001 · S/N 760514N614JCKnight Helo LLC · Wilmington, DES/N 760694N61DJBlack Badge Aviation LLC · Carson City, NVBuilt 1991 · S/N 760380N653LHBank Of Utah Trustee · Salt Lake City, UTBuilt 1995 · S/N 760420N664BCFlow Line Transportation LLC · Dallas, TXBuilt 1998 · S/N 760492N67MECas LLC · Longboat Key, FLBuilt 1997 · S/N 760469N707DSCas LLC · Longboat Key, FLBuilt 1997 · S/N 760471N709PPhi Health LLC · Tempe, AZBuilt 2008 · S/N 760716N709UCArrow Aviation Co LLC · Broussard, LAS/N 760631N711DSPentair LLC · Palmetto, FLBuilt 1997 · S/N 760473N718PPhi Aviation LLC · Lafayette, LABuilt 2007 · S/N 760686N725MFArrow Aviation Company LLC · Broussard, LABuilt 2002 · S/N 760532N725PPhi Aviation LLC · Lafayette, LABuilt 2007 · S/N 760692N72EHHelinet Aviation Services LLC · Van Nuys, CABuilt 2008 · S/N 760712N745PPhi Aviation LLC · Lafayette, LABuilt 2006 · S/N 760619N751LLState Of Illinois · Springfield, ILS/N 760318N753PPhi Health LLC · Tempe, AZBuilt 2008 · S/N 760726N754LArrow Aviation Co LLC · Broussard, LAS/N 760754N759PPhi Health LLC · Tempe, AZBuilt 2007 · S/N 760690N760BGBristow U S LLC · New Iberia, LAS/N 760733N760GPIndustrial Integrity Solutions LLC · Ontario, CABuilt 1996 · S/N 760448N760JEIslander Holdings Ltd · Fort Lauderdale, FLBuilt 1997 · S/N 760462N760PVSikorsky Aircraft Corp · Stratford, CTBuilt 1994 · S/N 760425N761CGCoulson Aviation (USA) Inc · Portland, ORBuilt 1994 · S/N 760410N7644SIslander Holdings Ltd · Ft Lauderdale, FLS/N 760314N764AMNorth Flight Aero Med · Grand Rapids, MIBuilt 2009 · S/N 760764N768AMSpectrum Health Hospitals · Grand Rapids, MIBuilt 2009 · S/N 760710N768SXRentco LLC · Deer Park, TXFirst renewal noticeBuilt 1991 · S/N 760372N769PPhi Aviation LLC · Lafayette, LABuilt 2007 · S/N 760671N76CGCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1989 · S/N 760355N76DNFastboy Equipment LLC · Beasley, TXS/N 760351N76EXIsland Express Helicopters Inc · Henderson, NVBuilt 1988 · S/N 760342N76FLHelinet Aviation Services LLC · Van Nuys, CABuilt 1988 · S/N 760347N76FXFlexjet Vertical Lift LLC · Stratford, CTBuilt 2005 · S/N 760585N76GATurbine Holdings II LLC · New York, NYBuilt 1999 · S/N 760498N76HHHallecopter LLC · Wilmington, DEBuilt 2010 · S/N 760807N76PCSo Much For Subtlety LLC · Dover, DEBuilt 2005 · S/N 760597N76VRArrow Aviation Co LLC · Broussard, LABuilt 1989 · S/N 760360N76ZAN76za LLC · New York, NYBuilt 2007 · S/N 760653N772PPhi Aviation LLC · Lafayette, LABuilt 2008 · S/N 760730N773BGBristow LLC · Lake Charles, LABuilt 2009 · S/N 760773N776DPDelaware Park LLC · Wilmington, DEBuilt 1991 · S/N 760367N780JCoulson Aviation (USA) Inc · Portland, ORS/N 760352N781PPhi Health LLC · Tempe, AZFirst renewal noticeBuilt 2006 · S/N 760630N781RLGm Leasing Company LLC · Broussard, LABuilt 2007 · S/N 760673N782RLGm Leasing Company LLC · Broussard, LABuilt 2007 · S/N 760666N783RLGm Leasing Company LLC · Broussard, LABuilt 2008 · S/N 760735N784RLGm Leasing Company LLC · Broussard, LABuilt 2008 · S/N 760721N785PSale Reported · Robert, LASale reported, canceledBuilt 2006 · S/N 760635N785RLGm Leasing Company LLC · Broussard, LABuilt 2006 · S/N 760639
Back to AD 2000-23-52