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.

N7195HGregory Family Farms LLC · Lewes, DES/N 0799N7195PSpitzer Helicopter LLC · Woodland Hills, CABuilt 2001 · S/N 1127N7196HState Of Alaska · Anchorage, AKBuilt 2001 · S/N 0994N7196UThomas Aviation LLC · Orleans, CABuilt 2001 · S/N 1086N7197JBrown Ronnie J · Anahuac, TXBuilt 2001 · S/N 1059N7197VExecutive Helicopters Inc · Myrtle Beach, SCBuilt 1999 · S/N 0692N724RGHeli Guide Leasing Inc · Crystal Beach, FLBuilt 2001 · S/N 1150N725SMS&M Aviation LLC · South Boston, VABuilt 2000 · S/N 0754N727DTClassic Drywall LLC · Richmond, KYBuilt 2017 · S/N 30019N727KPAero Leasing Inc · Brookings, ORBuilt 2004 · S/N 1416N728PGPolar Star Corp · Kalispell, MTBuilt 2001 · S/N 1107N728TSSky King LLC · Baltimore, MDBuilt 2009 · S/N 2025N739ASDel Martin Lp · Spring, TXBuilt 1999 · S/N 0612N740RHUnited Helicopter Leasing LLC · Honolulu, HIBuilt 2018 · S/N 2559N74335Owyhee Rotors Inc · Grand View, IDBuilt 2005 · S/N 1450N743RGRio Grande Helicopters Inc · Laredo, TXBuilt 2018 · S/N 2511N74401Iron Bird Aviation LLC · Wahpeton, NDBuilt 2005 · S/N 1481N74499Dawn Wolf Technologies Inc · Wichita, KSBuilt 2006 · S/N 1598N744AFCm3 LLC · North Las Vegas, NVBuilt 2008 · S/N 1955N744CJJersey Aviation LLC · East Orange, NJBuilt 2009 · S/N 2032N744HSAnthelion Helicopters · Long Beach, CABuilt 2001 · S/N 1004N744RGJohnston Philip · Mountain Home, TXBuilt 2007 · S/N 1753N74508Agricultural Tours LLC · Cheyenne, WYBuilt 2006 · S/N 1600N747WDJohnston Philip M · Mountain Home, TXS/N 0460N74EPCantrell Grady DBA · Los Banos, CABuilt 2013 · S/N 2301N74RGRio Grande Helicopters Inc · Laredo, TXBuilt 2016 · S/N 2453N7507XGhgk LLC · Myrtle Beach, SCBuilt 2002 · S/N 1218N7510TSpitzer Helicopter LLC · Woodland Hills, CABuilt 2006 · S/N 1563N7511WTtwn Media Networks LLC · New York, NYBuilt 2002 · S/N 1198N75175November Alpha LLC · Dover, DEBuilt 2003 · S/N 1331N7519GStearns William W · Talkeetna, AKBuilt 2004 · S/N 1363N7523EFlying J Services LLC · Jourdanton, TXBuilt 2003 · S/N 1321N752ECAll Planes & Helicopters Corp · Pompano, FLNon-citizen corporation, flight hours not reportedS/N 2028N7530CLake Superior Helicopters LLC · Duluth, MNS/N 1398N754BASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2000 · S/N 0943N765CMLaurel Highlands Helicopters Inc · Latrobe, PABuilt 2009 · S/N 2017N76MBHolt Helicopter Inc · Uvalde, TXBuilt 2006 · S/N 1661N7700ATim Whitfield Aviation Inc · Fairfield, NCBuilt 1998 · S/N 0438N777RLLandau Management Services Inc · Toranga, CABuilt 2000 · S/N 0744N7786JHeadings Norman D · Walnut, ILBuilt 1998 · S/N 0521N77DDFenger Thomas A · Palmer, AKBuilt 2005 · S/N 1513N77GDN77gd LLC · Kalispell, MTBuilt 2001 · S/N 1122N77JARegistration Pending · Midlothian, TXRegistration pendingS/N 1208N77MGHelo LLC · Easton, PABuilt 2020 · S/N 2614N792CCGavranovic William J Sr · Wharton, TXBuilt 2016 · S/N 2431N79RHNowling Daryl · Palm City, FLBuilt 2017 · S/N 30011N7QHPfannenschwarz Harry · Odessa, FLS/N 30037N8035Sparta Rotors Inc · Stuyvesant, NYBuilt 2000 · S/N 0825N804NVMoody Bible Institute Of Chicago · Spokane, WABuilt 2001 · S/N 1065N806NVFlight Operations Inc · Lewes, DEBuilt 2008 · S/N 1950
Back to AD 2000-07-03