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.

N315SGBuell Travis W · Harper, TXFirst renewal noticeBuilt 2003 · S/N 1315N31792Airscape Photo LLC · Issaquah, WABuilt 2006 · S/N 1668N318MFBusy Bee Helicopters LLC · Lone Jack, MOS/N 0073N31GMJewell Scott M · Willow, AKS/N 1117N31UPGuardian Aero LLC · Flora, ILBuilt 2013 · S/N 2294N321SKSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2019 · S/N 30050N324CSBrush Country Helicopters LLC · Laredo, TXBuilt 2013 · S/N 2321N3264UTri-B Air LLC · Plano, ILFirst renewal noticeS/N 1715N328SSUnited Helicopter Leasing LLC · Honolulu, HIBuilt 2002 · S/N 1214N32GSZeigler Corey M · Harrisville, NYBuilt 1993 · S/N 0016N331ESJackson Paul D · Chesapeake, VAFirst renewal noticeBuilt 2001 · S/N 1067N333LESky Photoshop LLC · Winter Garden, FLBuilt 2021 · S/N 2666N334WCFarmland Developers LLC · Jonesboro, ARBuilt 2016 · S/N 30009N335TBpu Enterprises LLC · Schuylkill Haven, PABuilt 2016 · S/N 2452N336SGAndrade South Florida Services Inc · Plantation, FLS/N 1336N337MGTew-Mac LLC · Tewksbury, MABuilt 2025 · S/N 2810N338SGMaine Rock And Recycling LLC · Rollinsford, NHS/N 1338N344BBMansfield Heliflight · Milton, VTBuilt 2001 · S/N 1159N344ESLake Superior Helicopters LLC · Duluth, MNBuilt 2015 · S/N 2402N344LCDuyk Charles W · Saint Petersburg, FLBuilt 2018 · S/N 2564N344RLRed R44 LLC · Wilmington, DEBuilt 2019 · S/N 2598N344SAShier Aviation DBA · San Diego, CABuilt 2017 · S/N 30012N344YUniversity Of North Dakota · Grand Forks, NDBuilt 2019 · S/N 30056N34TBAmerican Helicopter Co LLC · Maiden, NCBuilt 2000 · S/N 0798N350DMR&J Helicopters LLC · Port Byron, ILBuilt 1997 · S/N 0366N363SKKamasano LLC · Highland, CABuilt 2011 · S/N 2164N368TMStriker LLC · Lewes, DEBuilt 2026 · S/N 14989N369ELErickson Logging Inc · Gig Harbor, WAFirst renewal noticeS/N 1590N379CCSmith Jason · Calliham, TXBuilt 2006 · S/N 1596N391LVSmart James T · Spurger, TXS/N 0555N393NMAce High Helos LLC · El Campo, TXBuilt 1999 · S/N 0706N40014Ar Racing Inc · Catawba, NCBuilt 2025 · S/N 2825N4004MAirman Helicopter Inc · Fort Lauderdale, FLBuilt 2026 · S/N 2854N4010YRegistered aircraftBuilt 2025 · S/N 30103N4011ASky Helicopters Inc · Desoto, TXBuilt 2025 · S/N 30107N4015GRobinson Helicopter Co · Torrance, CAS/N 2872N40363Raider LLC · Joplin, MOBuilt 2011 · S/N 2108N403WAAviatech Inc · Tamarac, FLBuilt 2014 · S/N 13767N4040Parker Helicopter LLC · Watsonville, CABuilt 2019 · S/N 30048N4042QCharter Air Transportation LLC · Wayne, PABuilt 2021 · S/N 2658N40489Classic Drywall LLC · Richmond, KYBuilt 2026 · S/N 30113N4053TSky High Helicopters LLC · Camarillo, CABuilt 2018 · S/N 30045N4054GWorks Mark S · Cincinnati, OHBuilt 2023 · S/N 30095N4055KHarris William R Jr · Salisbury, CTBuilt 2020 · S/N 2611N4055NKansara Sanjay · Coopersburg, PABuilt 2020 · S/N 2619N4055QAeroglyphs Raven One LLC · Portland, ORS/N 2621N4056VHillsboro Aero Academy LLC · Hillsboro, ORBuilt 2023 · S/N 30093N406HLHelicopter Logging LLC · Lagrange, OHBuilt 2012 · S/N 2197N411TCBusy Bee Helicopter LLC · Paulding, OHBuilt 1994 · S/N 0034N411VFMay Ricky · Salem, VABuilt 2003 · S/N 1307
Back to AD 2000-07-03