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.

N41279Paratus Air DBA · Auburn, INBuilt 2008 · S/N 1909N413DBEstelle Karsen · Mc Neal, AZBuilt 2003 · S/N 1299N41402Isofly LLC · Canyon Country, CABuilt 2008 · S/N 1934N4154CSky Helicopters Inc · Garland, TXBuilt 2008 · S/N 1840N41584D Luckie LLC · Kalispell, MTBuilt 2008 · S/N 1897N4162MSilverhawk Aviation Academy LLC · Caldwell, IDBuilt 2008 · S/N 1877N416HHRotorwing LLC · Sheffield, ILBuilt 1997 · S/N 0415N4175PAero Specialty Finance LLC · Chesterfield, MOBuilt 2008 · S/N 1965N4181XFly For Fun Aircraft LLC · Rockville, MDBuilt 2008 · S/N 1948N41842Robinson Helicopter Co · Torrance, CABuilt 1993 · S/N 0010N418AFSkye Co LLC · South Williamson, KYBuilt 2002 · S/N 1204N41BEVintage Aero Collection Inc · Wilmington, DEBuilt 2007 · S/N 1690N41LYFedflyt LLC · Russell Springs, KYBuilt 2017 · S/N 30020N4204WWilbourne Danny L · Melbourne, FLBuilt 2008 · S/N 1970N4214MLawler Helicopter Leasing LLC · Rochester, MIBuilt 2009 · S/N 2008N422FIntegrity Aircraft Title Holdings LLC · Portland, ORS/N 0711N422RXEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 2001 · S/N 1094N422WHAirman Helicopter Inc · Fort Lauderdale, FLBuilt 2000 · S/N 0795N4230HHonolulu Helicopter Tours Inc · Honolulu, HIBuilt 2013 · S/N 2323N4269UAero380 Corp · Wilmington, DEBuilt 2017 · S/N 30021N427AFExecutive Jet A LLC · Danbury, CTS/N 1191N427RAHilty Benjamin D · South Boston, VABuilt 1994 · S/N 0067N430AFAir First LLC · Kalispell, MTS/N 1454N430DERotorwing LLC · Sheffield, ILBuilt 2000 · S/N 0904N433SKRycoe Air LLC · Auburn, NYBuilt 2012 · S/N 2193N436MRCedar Ridge Aviation LLC · Knox City, TXBuilt 2000 · S/N 0788N437LMGigliotti Darin · Pueblo, COBuilt 2003 · S/N 1349N438DEAirduce LLC · Cheriton, VABuilt 2005 · S/N 1521N43ALFloyd Air LLC · Searcy, ARBuilt 2004 · S/N 1375N440TKTim Kepp LLC · Point Pleasant, PABuilt 2008 · S/N 1991N441EKSkf Holdings LLC · Breckenridge, TXBuilt 2002 · S/N 1190N441HQSpitzer Helicopter LLC · Woodland Hills, CAS/N 1155N441KTHawaiian High LLC · Kaneohe, HIBuilt 2001 · S/N 1095N441MRHillsboro Aero Academy LLC · Hillsboro, ORBuilt 2003 · S/N 1329N441PFBusy Bee Helicopters LLC · Dover, DEBuilt 2005 · S/N 1522N441RHHobbs Jonnie L · Darnestown, MDBuilt 1997 · S/N 0401N441TBMansfield Heliflight Inc · Milton, VTBuilt 1999 · S/N 0631N4427HTotal Flight Aircraft Leasing LLC · Apex, NCBuilt 2000 · S/N 0923N442BHAfg Marietta LLC · Woodstock, GAS/N 1266N442EKCrop Doctor Aviation Inc · Hill City, KSS/N 1146N442MDMagill Zane · Castell, TXBuilt 2007 · S/N 1678N442MGYeti Heli LLC · Westminster, MABuilt 2001 · S/N 1087N442MRSleigh Helicopter LLC · Palm City, FLBuilt 2020 · S/N 30063N442RTRm Capital Holdings LLC · Hockessin, DEBuilt 2026 · S/N 30110N442UKSpitzer Helicopter LLC · Woodland Hills, CABuilt 2004 · S/N 1443N443DCSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 0284N443LCBlack Beauty Helicopters LLC · Davie, FLBuilt 2016 · S/N 2442N444DVSky High Helicopters LLC · Camarillo, CABuilt 2006 · S/N 1662N444RHHelisafe Inc · Long Beach, CABuilt 1992 · S/N 0004N444VHMf Helicopters LLC · East Troy, WIBuilt 1999 · S/N 0571
Back to AD 2000-07-03