OpenAirDocs.org
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.

N1019VQualitair LLC Trustee · MichelstadtS/N 1353N101TVSky Helicopters Inc · Garland, TXBuilt 1998 · S/N 0475N102AFMjm Enterprises LLC · Wilmington, DEBuilt 2007 · S/N 1779N102CVPilot In Command LLC · Parker, COBuilt 1999 · S/N 0570N104EGSpitzer Helicopter LLC · Wilmington, DEBuilt 2013 · S/N 2266N108DJAgri-Air LLC · Harrodsburg, KYBuilt 2001 · S/N 1060N109BRotorwing LLC · Walnut, ILBuilt 2007 · S/N 1743N111LESky Photoshop LLC · Winter Garden, FLBuilt 2025 · S/N 2817N111VGN111vg LLC · Princeton, NJBuilt 2001 · S/N 1053N112GJSpagnoletti Anthony · Spring, TXBuilt 1998 · S/N 0455N114ERIhle Edward A · Elmendorf, TXS/N 0879N115VCPoulikakos Aspasia D · Kifissia AthensNon-citizen corporation, flight hours not reportedBuilt 2000 · S/N 0917N116VKAirborne LLC · Wilmington, DEBuilt 2018 · S/N 2547N117BAChopper Ag Services LLC · Samson, ALBuilt 2017 · S/N 2512N119SMPrestige Worldwide Helicopters LLC · Waukesha, WIBuilt 2000 · S/N 0918N11RAMonkey Biziness LLC · Cherryville, NCS/N 1951N120AFAir First LLC · Kalispell, MTBuilt 1994 · S/N 2055N122JGRepublic Construction Industries LLC · Englewood, OHS/N 0845N127DMAircraft Leasing LLC · Peoria, ILBuilt 2017 · S/N 30023N128EHJen Air LLC · Greenwood, MSBuilt 2003 · S/N 1305N128KRRogue Texan Outfitters LLC · Skidmore, TXBuilt 1994 · S/N 0047N129AFNelson Flyers Inc · Louise, TXS/N 0946N132TCWorthington Loren Daniel · Caldwell, IDBuilt 2002 · S/N 1259N135WBTim Butterfield Drilling Inc · Somerset, WIBuilt 2001 · S/N 1093N137MTT&Tb Investments LLC · Horseshoe Bay, TXBuilt 2001 · S/N 1134N137TDWw Flying Services LLC · Waller, TXBuilt 2013 · S/N 2300N141CDSky Helicopters Inc · Desoto, TXBuilt 2023 · S/N 30091N141DCMagnum Leasing LLC · Waterford, MIBuilt 2005 · S/N 1495N144AFHelius Aircraft 144af LLC · Conroe, TXBuilt 2007 · S/N 1787N144AHAtomic Helicopters LLC · Seattle, WABuilt 2001 · S/N 0865N144CDLittle Gator Aviation Inc · Fairfield, NCBuilt 1999 · S/N 0602N144DJSaybrook Offshore LLC · Guilford, CTBuilt 2017 · S/N 2467N144DSStevenson William E · Sutton, AKBuilt 2000 · S/N 0715N144FLSouth Florida Helicopters Inc · Indiantown, FLS/N 0654N144JDDeviation LLC · Raleigh, NCBuilt 2000 · S/N 0938N144JGMontana Aircraft Trust Inc Trustee · Bozeman, MTBuilt 2000 · S/N 0859N144JJQcp Group LLC · Lafayette, LABuilt 1999 · S/N 0689N144KWAloha Helicopter Tours LLC · Lihue, HIBuilt 2009 · S/N 12805N144MNHaynes Michael W · Odessa, TXBuilt 2006 · S/N 1555N144RFRio Farms LLC · King City, CABuilt 2002 · S/N 1223N144RPBenrud Aviation LLC · Rice, MNS/N 0766N144VGVista Grande Helicopters Inc · Merritt Island, FLS/N 1101N144WBUniversal Aviators Academy Inc · El Monte, CABuilt 1998 · S/N 0545N144WTPerformancez LLC · Nederland, TXS/N 0601N146SGVertical Flight LLC · Safety Harbor, FLBuilt 2005 · S/N 1496N148RHPlum Aggregate LLC · Porter, TXBuilt 2017 · S/N 14048N14MYSouth Florida Helicopters Inc · Indiantown, FLS/N 1149N150BRegistered aircraftRegistration pendingBuilt 2002 · S/N 1199N150XTRice John D · Maddock, NDBuilt 2007 · S/N 1746N151CDAloha Helicopter Tours LLC · Lihue, HIBuilt 2007 · S/N 1705
Back to AD 2000-07-03