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.

N240RMPollux Aviation Ltd · Wasilla, AKBuilt 2001 · S/N 1090N241MGNewberg Sky Spray LLC · Hector, MNBuilt 2005 · S/N 1483N241VSDjd Aero Corp · Wilmington, DEBuilt 2000 · S/N 0729N244BHHelicopter Holdings LLC · East Falmouth, MABuilt 2016 · S/N 2449N244CCThompson Helicopters LLC · Uvalde, TXS/N 0860N244GHJakes Air Services LLC · Holt, FLS/N 0833N244JBSpier Ronald B · Springfield, OHBuilt 1999 · S/N 0560N244KSSnodgrass Charles Kenneth · Boise, IDBuilt 2022 · S/N 30085N244MKRegistered aircraftBuilt 2001 · S/N 1017N244RHRobinson Helicopter Co · Torrance, CABuilt 2021 · S/N 30080N244RLSouthern Maine Helicopter LLC · Sanford, MEBuilt 2013 · S/N 2333N244WBUpdraft LLC · Fort Wayne, INBuilt 2006 · S/N 1651N246LCTop Gun Precision Ag LLC · Skidmore, TXS/N 2620N248DBAce Helicopters LLC · Colfax, WIBuilt 1996 · S/N 0248N249DLGibsons Gas Inc · Holland, NYS/N 0382N24RTHillsboro Aero Academy LLC · Hillsboro, ORBuilt 2018 · S/N 30044N250THUniversity Of North Dakota · Grand Forks, NDBuilt 2018 · S/N 30038N2522PPfisters Helicopters Inc · Pasco, WABuilt 2014 · S/N 2352N255LCTrayer Jared T · Rollinsford, NHBuilt 2019 · S/N 2587N258DLExtapa LLC · Wilmington, DEBuilt 2012 · S/N 2250N264RHNomad Aircraft Leasing And Sales LLC · Panama City Beach, FLBuilt 2017 · S/N 2479N26EHEvans Robert · Phillips, NEBuilt 2001 · S/N 1128N272MGAircraft Evolution LLC · Miami, FLBuilt 2016 · S/N 2434N275LESky Photoshop LLC · Winter Garden, FLBuilt 2026 · S/N 2858N277KTMaxair Helicopters LLC · Kissimmee, FLS/N 2277N277LCN277lc LLC · Fairbanks, AKBuilt 2021 · S/N 2667N2812DCompass Aviation Inc · Shelby, NCBuilt 2004 · S/N 10397N286LHSolace Aviation LLC · Atglen, PABuilt 2024 · S/N 2786N287LHJft Re Development LLC · Bentonville, ARBuilt 2024 · S/N 2787N288LExecutive Helicopters Inc · Myrtle Beach, SCS/N 0930N28TMSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2004 · S/N 1402N299HEHeli 44 LLC · Freeland, MDBuilt 1999 · S/N 0618N29KYBlack Ops Aviation LLC · Moorhead, IABuilt 2007 · S/N 1778N29VMDragonfly Aviation LLC · Laredo, TXS/N 0368N29WNSpitzer Helicopter LLC · Woodland Hills, CABuilt 2000 · S/N 0934N300MKAgricultural Tours LLC · Kahuku, HIS/N 1151N3014B-Line Air LLC · Malcom, IABuilt 2008 · S/N 1961N3017PDragonfly Aviation LLC · Mirando City, TXBuilt 2007 · S/N 1820N3039FSilverhawk Aviation Academy LLC · Caldwell, IDBuilt 2007 · S/N 1733N3040PCedar Ridge Aviation LLC · Knox City, TXBuilt 2007 · S/N 1802N304HGGeorgia Aviation Authority · Eastman, GABuilt 2013 · S/N 2337N3055SWcm Ventures LLC · Hondo, TXBuilt 2007 · S/N 1745N305JSMiller Kale M · Mountain Home, TXS/N 0763N306MBSpitzer Helicopter LLC · Woodland Hills, CABuilt 2016 · S/N 2439N306VAVeracity Aviation LLC · Seguin, TXBuilt 2025 · S/N 30111N307SHParker Helicopters Inc · Watsonville, CABuilt 2023 · S/N 30097N308EHLos Angeles Helicopters Inc · Los Angeles, CARegistration ineffective or invalidBuilt 2002 · S/N 1153N310PBPuckett Dale · Ararat, VAS/N 0086N31261Lee Stan · Sarasota, FLBuilt 2006 · S/N 1634N3156GBlack Ops Aviation LLC · Moorhead, IABuilt 2006 · S/N 1666
Back to AD 2000-07-03