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.

N153WFSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1995 · S/N 0152N154ABills Helicopter Service LLC · Woodlawn, VAS/N 0558N158CRA2heli LLC · Ann Arbor, MIBuilt 2017 · S/N 2466N159MHPw Air LLC · Rockingham, VABuilt 2001 · S/N 1135N159RPHeadings Norman D · Walnut, ILBuilt 1997 · S/N 0342N161CMR&J Helicopters LLC · Port Byron, ILBuilt 2016 · S/N 2444N161WPJax Transport LLC · Amarillo, TXBuilt 2005 · S/N 1490N164SAOlson Helicopters LLC · Corpus Christi, TXBuilt 2006 · S/N 1559N165SUBeckett David · Wasilla, AKBuilt 2020 · S/N 30074N167SUSouthern Utah University · Cedar City, UTBuilt 2020 · S/N 30064N168AVAce Helicopters LLC · Colfax, WIBuilt 2008 · S/N 1968N168BANomad Aircraft Leasing And Sales LLC · Panama City Beach, FLBuilt 2002 · S/N 1176N169CSChavi LLC · Fredericksburg, TXBuilt 2015 · S/N 2407N171WCRegistration Pending · Flora, ILRegistration pendingBuilt 1997 · S/N 0331N171WTB&B Aero LLC · Arlington, MABuilt 2009 · S/N 2064N177CS833 Lakeside LLC · Downers Grove, ILS/N 1269N17EMSegerstrom Ricky G Trustee · Grandview, TXBuilt 2006 · S/N 1580N181AFSmoketown Helicopters LLC · Smoketown, PABuilt 2010 · S/N 2100N181MBSpitzer Helicopter LLC · Woodland Hills, CABuilt 2016 · S/N 2425N183ASCorporate Helicopter Leasing · Dallas, TXBuilt 2000 · S/N 0827N183PSHc02 LLC · Vero Beach, FLBuilt 2014 · S/N 2328N187JHSouthern Ag Helicopter Services LLC · Zebulon, NCBuilt 1995 · S/N 0203N189MXL&W Holdings LLC · North Fort Myers, FLBuilt 2012 · S/N 2194N18EKKrahenbuhl Edward L Trustee · Waldport, ORBuilt 2018 · S/N 30042N18FHParatus Air Inc · Auburn, INBuilt 1999 · S/N 0651N18MQCr Helicopters Inc · Nashua, NHBuilt 2000 · S/N 0830N1953RSmith Helicopters Inc · Cotulla, TXS/N 30018N1976BEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1999 · S/N 0637N197HLCedar Ridge Aviation LLC · Knox City, TXBuilt 2004 · S/N 1386N202BRRc Aviation LLC · Ladysmith, WIBuilt 2020 · S/N 2616N202WTEngstad Kai · Gig Harbor, WABuilt 2008 · S/N 1847N204DJl Leasing LLC · Elbow Lake, MNBuilt 2004 · S/N 1447N205SHBuzzard Aviation Inc · Freer, TXS/N 0773N207PDFirefly Leasing Inc · South Carver, MABuilt 2003 · S/N 1330N211TBSteinbach Philipp · Bentonville, ARBuilt 2011 · S/N 2106N21279Kerry Air LLC · Wilmington, DEBuilt 2016 · S/N 2448N212LSHeli Ag LLC · Waller, TXBuilt 2006 · S/N 1650N212PDGrossman Steven J · Amherst, NHBuilt 2008 · S/N 1895N213SFSeaton Flying Services · Killeen, TXBuilt 2005 · S/N 1534N217DKHawaii Pacific Aviation Inc · Kailua Kona, HIBuilt 2018 · S/N 2556N224RHCedar Ridge Aviation LLC · Knox City, TXBuilt 2001 · S/N 1137N225MLSeaton Flying Services · Killeen, TXBuilt 2007 · S/N 1810N225TVBuell Travis · Harper, TXS/N 0253N2263WJax Transport LLC · Amarillo, TXBuilt 2002 · S/N 1213N227GCHansen Arland · Warden, WABuilt 2002 · S/N 1205N230DMGillespie Flying Services LLC · Trenton, SCBuilt 1997 · S/N 0325N2323Medicine Aviation & Petroleum LLC · Youngsville, LAFirst renewal noticeS/N 1025N234ZTDrax Enterprise LLC · Miami Beach, FLBuilt 2017 · S/N 30027N239DJDj Wings Holding LLC · Greenlawn, NYBuilt 2022 · S/N 30089N240KHBurns Shane H · Waxahachie, TXBuilt 2001 · S/N 0978
Back to AD 2000-07-03