OpenAirDocs.org
AD 2002-19-08

Registered aircraft · 51

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:2002-19-08')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-19-08')
  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.

N14XTMccole Kevin · Brookline, NHBuilt 1986 · S/N 361N170WLIdpa Aircraft Leasing LLC · Austin, TXBuilt 2012 · S/N 468/CN17ZXIdpa Aircraft Leasing LLC · Austin, TXBuilt 2007 · S/N 433-29/OB2N19WLSouth Carolina Department Of Natural Resources · Columbia, SCBuilt 2004 · S/N 425-25/OB2N23MWNortheast Wisconsin Aero LLC · Sturgeon Bay, WIBuilt 1978 · S/N 151N291CJArndt Scott · Pearland, TXBuilt 1983 · S/N 291N300LFAspen Helicopters Inc · Oxnard, CAS/N 295N321RTBarr Air Patrol LLC · Mesquite, TXBuilt 1979 · S/N 189N340PNAspen Helicopters Inc · Oxnard, CABuilt 1985 · S/N 340-02/OTCN357PNWashington State Dept Of Fish And Wildlife · Olympia, WABuilt 1985 · S/N 357-38/TCN384VPAspen Helicopters Inc · Oxnard, CAS/N 384-01-OB2N3927UFresh Air Aviation Inc · Charlevoix, MIBuilt 1983 · S/N 282N419FWFlorida Fish & Wildlife Conservation Commission · Lakeland, FLBuilt 2002 · S/N 419-19/0B2N420KWCleghorn Aviation Inc · Key West, FLBuilt 1983 · S/N 294N4465YIdpa Aircraft Leasing LLC · Austin, TXBuilt 1983 · S/N 320-26/TCN44959Aspen Helicopters Inc · Oxnard, CAS/N 319-14/OBN468CBorn John · Jupiter, FLBuilt 1980 · S/N 213N480NROhio Division Of Wildlife · Columbus, OHBuilt 1986 · S/N 345N483FWNeel Aviation LLC · Lakeland, FLBuilt 1983 · S/N 271N490NROhio Department Of Natural Resources · Columbus, OHBuilt 1982 · S/N 281N4958KPilot Corp Of The Palm Beaches DBA · West Palm Beach, FLBuilt 1983 · S/N 269N53695N53695 LLC · Miami, FLBuilt 1979 · S/N 126N564BCBravo Charlie Aviation Inc · Middletown, DENon-citizen corporation, flight hours not reportedBuilt 1984 · S/N 299N590WASchellhorn Frederick Jr · Harxheim MainzS/N 61N605New York State Police · Albany, NYBuilt 1984 · S/N 321-15/OBN6307MN6307m LLC · Terra Ceia, FLBuilt 1985 · S/N 306N6602LMclaughlin Charles W Trustee · Oxnard, CABuilt 1984 · S/N 326 19 OBN668TCOly Aero LLC · Central Point, ORS/N 317-25/TCN683KWOwyhee Air Research LLC · New Braunfels, TXBuilt 1983 · S/N 305N684KWFour Kilo Whiskey LLC · Key West, FLBuilt 1991 · S/N 387N686KWSix Kilo Whiskey LLC · Key West, FLS/N 364N68PVAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2007 · S/N 442-07/OTCN68VAAspen Helicopters Inc · Oxnard, CABuilt 2007 · S/N 440/CN68VRGene Coleman Machine Inc · Menominee, MIBuilt 2004 · S/N 434N69HANorth County Flying LLC · North Palm Beach, FLBuilt 1990 · S/N 373N701United States Department Of Interior · Boise, IDBuilt 1990 · S/N 390-03-0B2N73N73n Aviation LLC · North Miami Beach, FLS/N 230N742WGTop View Corp · Livingston, MTBuilt 2023 · S/N 522/CN75NLFresh Air Aviation Inc · Charlevoix, MIS/N 312N7668BPacific Flight Academy LLC · Honolulu, HIS/N 28N766FEdge Logistics Inc · South Lake, TXBuilt 1983 · S/N 313-23/TCN76TWTennessee Wildlife Resources Agency · Nashville, TNBuilt 1991 · S/N 393-04-0B2N789FWWalton Marketing Inc · Fort Worth, TXS/N 28820TCN821BABarr Air Patrol LLC · Mesquite, TXBuilt 2007 · S/N 441-32/OB2N856HState Of Ohio · Columbus, OHBuilt 1982 · S/N 256-06-0BN881BABarr Air Patrol LLC · Mesquite, TXBuilt 1983 · S/N 274N88NAspen Helicopters Inc · Oxnard, CAS/N 352-37/TCN9000VState Of Oregon · Salem, ORS/N 259-07-0BN90UBS-T Manufacturing Inc · Granbury, TXBuilt 1984 · S/N 302N91GFNew Mexico Dept Of Game And Fish · Santa Fe, NMBuilt 2009 · S/N 454-10/OTC
Back to AD 2002-19-08