AD 2000-07-03

Registered aircraft · 557

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

N695SDDerek Dunn LLC · Levelland, TXBuilt 2007 · S/N 1726N69BKShimek Mark · Port Lavaca, TXBuilt 2002 · S/N 1230N69NSAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2012 · S/N 2203N6SGCedar Ridge Aviation LLC · Knox City, TXBuilt 2000 · S/N 0878N6XWLewis Everett D · Comfort, TXFirst renewal noticeBuilt 2005 · S/N 1494N6YSHawk Aircraft Sales & Leasing LLC · Sterling Heights, MIBuilt 2003 · S/N 1348N7008NRobinson Helicopter Company Inc · Torrance, CABuilt 1998 · S/N 0464N7016GRocky Air LLC · Cheyenne, WYBuilt 2016 · S/N 30008N7027UTtwn Media Networks LLC · New York, NYBuilt 1998 · S/N 0514N702CCRpd Enterprises Inc · Nicholson, PABuilt 2002 · S/N 1231N702TFWhitfield Timothy D · Fairfield, NCS/N 1029N7030JTtwn Media Networks LLC · New York, NYBuilt 1999 · S/N 0565N7037CTtwn Media Networks LLC · New York, NYBuilt 1998 · S/N 0469N703JJJ J Helicopters Inc · Torrance, CABuilt 2006 · S/N 1573N7040VSilverhawk Aviation Academy LLC · Caldwell, IDBuilt 2013 · S/N 2342N7046GHelo Operations LLC · Waynesville, MOS/N 0541N7048CMn Helicopters Inc · Minneapolis, MNBuilt 1998 · S/N 0531N7052VOut Front Cc LLC · Kalispell, MTBuilt 2012 · S/N 2243N70583Bult Equipment LLC · Monee, ILBuilt 2002 · S/N 1197N7078YJes Storage Co · Wyoming, ILBuilt 2013 · S/N 2322N7086LN43926 LLC · Dandridge, TNBuilt 1999 · S/N 0575N7089GB-Squared Helicopters LLC · Daphne, ALBuilt 2017 · S/N 2459N7094JTtwn Media Networks LLC · New York, NYBuilt 1999 · S/N 0600N7098NSearcy Moto-Air Inc · Searcy, ARS/N 2409N70KAEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 2001 · S/N 1058N7102ZRegistered aircraftBuilt 2013 · S/N 2309N7114RUniversity Of Alaska Anchorage · Anchorage, AKBuilt 1999 · S/N 0623N7119UTtwn Media Networks LLC · New York, NYBuilt 1999 · S/N 0641N7133EAir Assault Agricultural Aviation LLC · New Castle, VABuilt 1999 · S/N 0573N7138CDe Aviation LLC · South Wayne, WIS/N 0530N715SGSilver Sky Helicopters LLC · Park City, UTBuilt 2002 · S/N 1261N7162RPollux Aviation Ltd · Wasilla, AKBuilt 1999 · S/N 0670N717PZThompson Helicopters LLC · Uvalde, TXBuilt 1998 · S/N 0447N7183CState Of Alaska · Anchorage, AKBuilt 2001 · S/N 0995N7183NTop Gun Precision Ag LLC · Skidmore, TXBuilt 2000 · S/N 0703N7183PKerr Ken · Nome, AKS/N 0535N7183WConrad Charles J · Wasilla, AKBuilt 1999 · S/N 0564N7184GEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 2000 · S/N 0937N7184NBas Part Sales LLC · Greeley, COS/N 0116N7187XSouth Florida Helicopters Inc · Indiantown, FLBuilt 1999 · S/N 0552N71888Anjum Mohammad A · Melrose Park, ILBuilt 1998 · S/N 0507N7188DUS Aviation Training Solutions Inc · Titusville, FLBuilt 2000 · S/N 0782N7189ZSmd Vineyards Inc · Salinas, CAS/N 0876N718EPPeregrine Air LLC · Mount Vernon, WABuilt 2002 · S/N 1177N718SCHelico Rotors Inc · Miami Beach, FLBuilt 2000 · S/N 0853N7192BAstroone LLC · Culpeper, VABuilt 2000 · S/N 0848N7192H7192h LLC · Redwood City, CABuilt 2000 · S/N 0858N7192URed Hawk Aviation LLC · Allegan, MIBuilt 2000 · S/N 0875N7193YExcel Helicopters LLC · Orange Grove, TXBuilt 2001 · S/N 1038N7195DCedar Ridge Aviation LLC · Knox City, TXBuilt 2000 · S/N 0905
Back to AD 2000-07-03