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.

N519MRSkyway I LLC · Naples, FLBuilt 2002 · S/N 1267N531BPCedar Ridge Aviation LLC · Knox City, TXBuilt 2004 · S/N 1379N533MAMercury Aviation Inc · Flowood, MSFirst renewal noticeBuilt 1998 · S/N 0402N535LEAirman Helicopter Inc · Fort Lauderdale, FLBuilt 2026 · S/N 2857N535LMMillcopter LLC · Wahpeton, NDBuilt 2007 · S/N 1790N541PRSale Reported · Port Orchard, WASale reported, pending cancellationBuilt 2002 · S/N 1181N544MBSky West Aviation Inc Trustee · Albuquerque, NMS/N 1378N544MHHood Helicopters LLC · Longwood, FLBuilt 2000 · S/N 0739N544RLPlane Leasing LLC · Wilmington, DEBuilt 2004 · S/N 1384N544SBHd Aviation Services LLC · Pembroke Pines, FLBuilt 2007 · S/N 1759N54AGLmv LLC · Kennebec, SDBuilt 2022 · S/N 14590N555BNEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 2001 · S/N 1079N555FPRotorpro LLC · Sevierville, TNBuilt 2001 · S/N 1012N559BDBiggs Aviation LLC · Decatur, INBuilt 2004 · S/N 1470N559RKRegistration Pending · Sheridan, WYRegistration pendingBuilt 1999 · S/N 0559N562TSumner Properties LLC · Somersworth, NHBuilt 2011 · S/N 2121N567SHSpitzer Helicopter LLC · Wilmington, DEBuilt 2008 · S/N 1859N56BEBirds Eye View Inc · Middletown, RIBuilt 2017 · S/N 2476N570HRegistered aircraftS/N 2016N570WHMf Helicopters LLC · East Troy, WIBuilt 1998 · S/N 0538N577BASpitzer Helicopter LLC · Woodland Hills, CABuilt 2002 · S/N 1163N57BAHelicrop LLC · Menlo, IABuilt 2022 · S/N 2688N586TSUniversity Of North Dakota · Grand Forks, NDBuilt 2021 · S/N 30076N59KCSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2009 · S/N 2018N5FQBlue River Heli LLC · Anchorage, AKBuilt 2009 · S/N 12821N600SRCsd Enterprises Inc · Wilmington, DEBuilt 2000 · S/N 0751N601TVOrlando Aircraft Sales LLC · Orlando, FLBuilt 2000 · S/N 0836N60HCKing Winn K · Gladewater, TXBuilt 1996 · S/N 0287N611XBravo One LLC · Saint Louis, MOBuilt 2000 · S/N 0721N61KG2 G Group LLC · Honolulu, HIBuilt 1997 · S/N 0385N61TMElliott Randy K · Wasilla, AKS/N 0610N625HTHi Tech Helicopters · Tobyhanna, PABuilt 2023 · S/N 2735N629RWDrew Helicopters LLC · Annona, TXBuilt 1998 · S/N 0520N62GFAirman Helicopter Inc · Fort Lauderdale, FLBuilt 2023 · S/N 2726N630MSHelicrop LLC · Menlo, IAS/N 0885N636DDAlba Aviation Services Inc · Scottsdale, AZBuilt 2001 · S/N 0974N63ATRhynard Justin · Cedar Park, TXBuilt 2001 · S/N 1049N642RHValiair Lc Trustee · Casper, WYBuilt 2013 · S/N 2292N644RABoston Helicopters · North Andover, MABuilt 2012 · S/N 2205N646MSEagle Soar LLC · Fort Worth, TXBuilt 2001 · S/N 1047N661RRHelicopter Of Columbia LLC · Columbia, SCBuilt 1999 · S/N 0661N666NYFerrante Aviation Inc · Vandergrift, PABuilt 2007 · S/N 1679N667SAHelicopter N667sa LLC · Lisbon, NDBuilt 2000 · S/N 0726N668TMAlpha Helicopters LLC · Lewes, DEBuilt 2000 · S/N 1032N669TMDirty Bird Helicopters LLC · Boerne, TXBuilt 2002 · S/N 1233N66UWCm3 LLC · North Las Vegas, NVBuilt 2000 · S/N 0802N678KBSeaton Flying Services · Killeen, TXBuilt 2008 · S/N 1982N680PMN680pm LLC · Knoxville, IABuilt 1999 · S/N 0680N683RUniversity Of North Dakota · Grand Forks, NDBuilt 2019 · S/N 30057N68BEAir Pro Aviation LLC · Cross Lake Twp, MEBuilt 2013 · S/N 2339
Back to AD 2000-07-03