N243US, cancelled Sep 13, 2004

Service difficulty reports · 100

Matched to this aircraft by N-number and event date, checked against the reported serial number, make and model. Newest first.

Query with SQL
duckdb -csv -c "SELECT sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy
  FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet'
  WHERE n_number = 'N243US' AND deregistration_id = 'N243US-2004-09-13'
  ORDER BY difficulty_date DESC"

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.

SDR USAA991479Tie Clip · crackedCLT - DURING Q-1 CHECK VISUAL INSPECTION, FOUND A .25 INCH CRACK STATION 578, STRINGER 8R TIE CLIP. INSTALLED NEW TIE CLIP PER EO53936227. (M)Jan 12, 2000 · N243US · Boeing 737201 · Fuselage Miscellaneous StructureSDR USAA991478Tie Clip · crackedCLT - DURING Q-1 CHECK VISUAL INSPECTION, FOUND A 2 INCH CRACK STATION 578, STRINGER 5R TIE CLIP. INSTALLED NEW TIE CLIP PR EO53936227. (M)Jan 12, 2000 · N243US · Boeing 737201 · Fuselage Miscellaneous StructureSDR USAA000021Web · crackedWEB CRACKED AT BS 639, WL 208 RIGHT BUTTLINE 63. INSTALLED REPAIR PER SRM 51-40-4. (M)Jan 12, 2000 · N243US · Boeing 737201 · Fuselage Miscellaneous StructureSDR USAA000020Skin · crackedSKIN CRACKED AT LOWER CORNER OF AFT ENTRY DOOR CUTOUT. INSTALLED DOUBLER AND TRIPLER PER SRM 53-30-3 FIG 24. (M)Jan 12, 2000 · N243US · Boeing 737201 · Fuselage Main, Plate/SkinSDR USAA000019Web · crackedWEB CRACKED AT BS 578 RIGHT RIGHT BUTT LINE 62.5 WL 207. INSTALLED NEW WEB AND DOUBLER PER SRM 51-10-02. (M)Jan 12, 2000 · N243US · Boeing 737201 · Fuselage Miscellaneous StructureSDR USAA000018Web · crackedWEB CRACKED AT BS 695 LEFT BUTT LINE 61.5 WATER LINE 206. INSTALLED REPAIR DOUBLER PER SRM 41-40-21. (M)Jan 12, 2000 · N243US · Boeing 737201 · Fuselage Miscellaneous StructureSDR USAA000017Tie Clip · crackedFOUND TIE CLIP CRACKED AT BS 685 STRINGER 5R.. INSTALLED NEW TIE CLIP PER EO 5393G227. (M)Jan 12, 2000 · N243US · Boeing 737201 · Fuselage Miscellaneous StructureSDR USAA000016Tie Clip · crackedFOUND TIE CLIP CRACKED AT BS 867 STRINGER 10R. INSTALLED NEW TIE CLIP PER EO 5393G227. (M)Jan 12, 2000 · N243US · Boeing 737201 · Fuselage Miscellaneous StructureSDR USAA000015Tie Clip · crackedFOUND TIE CLIP CRACKED AT BS 706 STRINGER 10L. REPLACED TIE CLIP PER EO5393G227. (M)Jan 12, 2000 · N243US · Boeing 737201 · Fuselage Miscellaneous StructureSDR USAA000014Tie Clip · crackedFOUND TIE CLIP CRACKED AT BS 807, STRINGER 5L. INSTALLED NEW TIE CLIP PER EO5393G227. (M)Jan 12, 2000 · N243US · Boeing 737201 · Fuselage Miscellaneous StructureSDR USAA000013Tie Clip · crackedFOUND TIE CLIP CRACKED AT BS 639, STRINGER 6R. INSTALLED NEW TIE CLIP PER EO 5393G227. (M)Jan 11, 2000 · N243US · Boeing 737201 · Fuselage Miscellaneous StructureSDR USAA000012Tie Clip · crackedFOUND TIE CLIP CRACKED AT BS 559, STRINGER 8R. INSTALLED NEW TIE CLIP PER EO 5393G227. (M)Jan 11, 2000 · N243US · Boeing 737201 · Fuselage Miscellaneous StructureSDR USAA000011Tie Clip · crackedFOUND TIE CLIP CRACKED AT BS 847 STRINGER 10R. INSTALLED NEW TIE CLIP PER EO 5393G227. (M)Jan 11, 2000 · N243US · Boeing 737201 · Fuselage Miscellaneous StructureSDR USAA000010Tie Clip · crackedFOUND TIE CLIP CRACKED AT BS 663 STRINGER 10R. INSTALLED NEW TIE CLIP PER EO 5393G227. (M)Jan 11, 2000 · N243US · Boeing 737201 · Fuselage Miscellaneous StructureSDR USAA000009Tie Clip · crackedTIE CLIP HAS 2 CRACKS AT BS 663 STRINGER 10L.. INSTALLED NEW TIE CLIP PER EO 5393G227. (M)Jan 11, 2000 · N243US · Boeing 737201 · Fuselage Miscellaneous StructureSDR USAA000008Tie Clip · crackedTIE CLIP CRACKED AT BS 827 STRINGER 4R. INSTALLED NEW TIE CLIP PER EO 5393G227. (M)Jan 11, 2000 · N243US · Boeing 737201 · Fuselage Miscellaneous StructureSDR USAA000007Tie Clip · crackedTIE CLIP CRACK AT BS 767 STRINGER 10R. INSTALLED NEW TIE CLIP PER EO 5393G227. (M)Jan 11, 2000 · N243US · Boeing 737201 · Fuselage Miscellaneous StructureSDR USAA000006Tie Clip · crackedFOUND TIE CLIP CRACKED AT BS 639. INSTALLED NEW TIE CLIP PER EO 5393G227. (M)Jan 11, 2000 · N243US · Boeing 737201 · Fuselage Main, StructureSDR USAA000005Tie Clip · crackedTIE CLIP CRACKED AT BS 907, STRINGER 2L. INSTALLED NEW TIE CLIP PER EO 5393G227. (M)Jan 11, 2000 · N243US · Boeing 737201 · Fuselage Miscellaneous StructureSDR USAA000004Web · crackedWEB CRACKED AT BS 616 STRINGER 17L. INSTALLED NEW CREASE BEAM WEB PER SRM 51-10-1. (M)Jan 11, 2000 · N243US · Boeing 737201 · Fuselage Miscellaneous StructureSDR USAA000003Frame · crackedFRAME CRACKED AT BS 290 STRINGER 12R AND 13R.. INSTALLED NEW CHORD ANGLE PER SRM 51-10-1. (M)Jan 11, 2000 · N243US · Boeing 737201 · Fuselage Main, FrameSDR USAA991024Skin · crackedTPA - DURING A CX-3 CHECK VISUAL INSPECTION, FOUND A 2 INCH CRACK IN LOWER INNER LINER OF CARGO DOOR SKIN. INSTALLED REPAIR DOUBLER PER SRM 53-00-2 FIG 1. (X)Sep 25, 1999 · N243US · Boeing 737201 · Cargo/Baggage DoorsSDR USAASB99153Regulator · failedTPA - FLT 2636 - ON CLIMB-OUT FROM TPA, CAPT OBSERVED A DUCT PRESSURE OF OVER 100 PSI ON THE RIGHT SIDE AND 40 PSI ON THE LEFT SIDE. THE NR 5 LEADING EDGE SLAT TRANSIT LIGHT WAS ALSO ILLUMINATED. CREW CYCLED LEADING EDGE SLATS TWICE BUT LIGHT WOULD NOT EXTINJun 23, 1999 · N243US · Boeing 737201 · Pneumatic Distribution SystemSDR USAASB98322Battery · dischargedBWI - MAINTENANCE FOUND THE MID CABIN CEILING EMERGENCY EXIT LIGHT INOP. MAINTENANCE REMOVED AND REPLACED THE BATTERY SUPPLY. OPERATIONAL CHECK GOOD. (M)Dec 11, 1998 · N243US · Boeing 737201 · Emergency LightingSDR USAA980566Web · crackedCLT - DURING CHECK VISUAL AND EDDY CURRENT INSPECTION, FOUND A 1.5 INCH CRACK BL 0 STATION 259 TOP OF NOSE W/W WEB. REMOVED AND REPLACED DAMAGED WEB PER SRM 51-10-1 AND SRM 51-30-2. (M)Nov 9, 1998 · N243US · Boeing 737201 · Fuselage Miscellaneous StructureSDR USAASB98066Circuit Breaker · failedCLT - FLT 1503 - ON CLIMB-OUT FROM CLT, THE NR 1 GENERATOR WAS LOST AT APPROXIMATELY 6,000 FEET. CREW PUT THE APU GENERATOR ON LINE AND IT CEASED AT 11,000 FEET. WITH ONLY ONE POWER SOURCE LEFT, CREW RETURNED TO FIELD AT CLT AND LANDED WITHOUT FURTHER INCIDENMar 16, 1998 · N243US · Boeing 737201 · AC Generation SystemSDR USAA970344Skin · crackedROA - DURING CX-1 CHECK VISUAL, VERIFIED WITH HFEC INSPECTION, FOUND 2 INCH CRACK IN SKIN STATION 727A AT STRINGER 18R. INSTALLED DOUBLER, REPAIRED PER SRM 53-30-3. (M)Nov 30, 1997 · N243US · Boeing 737201 · Fuselage Main, Plate/SkinSDR USAASB97036Coalescer Bag · dirtyCLT - FL 832 - IMMEDIATELY AFTER TAKEOFF, CREW HEARD A FLAPPING NOISE ON THE RIGHT SIDE OF AIRCRAFT AND NOTICED A BURNING OIL TYPE ODOR. CREW SUSPECTED RIGHT PACK AND TURNED PACK OFF. NOISE AND ODOR WENT AWAY. MAINTENANCE REMOVED AND REPLACED THE RIGHT PACKJan 29, 1997 · N243US · Boeing 737201 · Humidity Control SystemSDR USAA970012Skin · crackedROA - DURING CX-6 CHECK VISUAL/EDDY CURRENT INSPECTION, FOUND 3 INCH CRACK FORWARD GALLEY DOOR CUT OUT AFT LOWER CORNER FUSELAGE SKIN. REMOVE CRACK AND INSTALLED DOUBLER, REPAIRED PER SRM 53-30-3. (M)Jan 9, 1997 · N243US · Boeing 737201 · Fuselage Main, Plate/SkinSDR USAA970011Stringer · corrosionROA - DURING CX-6 CHECK VISUAL INSPECTION, FOUND 2 INCH BY 4 INCH CORROSION STRINGER 27L, BS 965 TO 969. REMOVED CORROSION AND INSTALLED STRINGER SPLICE, REPAIRED PER SRM 53-10-3. (M)Jan 9, 1997 · N243US · Boeing 737201 · Fuselage Main, Longeron/StringerSDR USAASB96250Air Cycle Mach · failedORF - FLT 916 - AFTER TAKEOFF, CREW NOTED ACRID SMELL IN COCKPIT FOLLOWED BY BOTH SMOKE DETECTORS ACTIVATING. FLIGHT RETURNED TO ORF AND LANDED WITH NO FURTHER INCIDENT. MAINTENANCE REPLACED THE RT AIR CYCLE MACHINE. (X)Dec 2, 1996 · N243US · Boeing 737201 · Cabin Cooling SystemSDR USAASB96153Retract Mech · malfunctionedGOO - FLT 8028 - AFTER TAKEOFF FROM GSO, CAPTAIN WAS UNABLE TO RAISE LANDING GEAR LEVER. TWO OTHER ATTEMPTS WERE MADE BUT WERE UNSUCCESSFUL. CIRCUIT BREAKERS WERE ALL IN AND GEAR PINS WERE ONBOARD. CAPTAIN ELECTED TO RETURN TO FIELD AT GSO. NO EMERGENCY WAAug 14, 1996 · N243US · Boeing 737201 · Landing Gear Retraction/Extension SystemSDR USAA960514Shear Beam · crackedROA - DURING BX-CHECK, VISUAL INSPECTION FOUND .75 INCH CRACKSTRINGER 18 A RIGHT SHEAR BEAM AT BS 706. INSTALLED REPAIR KIT, REPAIREDPER EO 5393G256 PART 3 STEP 4. (M)Jul 18, 1996 · N243US · Boeing 737201 · Fuselage Miscellaneous StructureSDR USAA960289Chord · corrosionINT - DURING Q-6 CHECK VISUAL INSPECTION, FOUND 1 INCH BY 2 INCH CORROSION Z-ANGLE STATION 270 AT BL 0. REMOVED CORROSION AND INSTALLED DOUBLER, REPAIRED PER TR 53-20-04. (M)Feb 24, 1996 · N243US · Boeing 737201 · Fuselage Miscellaneous StructureSDR USAA960287Frame · crackedINT - DURING Q-6 CHECK VISUAL INSPECTION, FOUND .25 INCH CRACK BS 328 AT NR 3 STOP FOR FORWARD CABIN SERVICE DOOR FRAME. STOP DRILLED CRACK AND INSTALLED DOUBLER, REPAIRED PER SRM 51-40-3 PAGE 1. (M)Feb 24, 1996 · N243US · Boeing 737201 · Fuselage Main, FrameSDR USAA960283Skin · crackedINT - DURING Q-6 CHECK VISUAL INSPECTION, FOUND 2 INCH CRACK IN FUSELAGE SKIN AT STATION 727 B 2 INCH AND STRINGER 17. INSTALLED REPAIR DOUBLER, REPAIRED PER SRM 53-30-3 FIG 6. (M)Feb 24, 1996 · N243US · Boeing 737201 · Fuselage Main, Plate/SkinSDR USAA960282Frame · crackedINT - DURING Q-6 CHECK VISUAL INSPECTION, FOUND .5 INCH CRACK NR 3 STOP CUT OUT (AFT FRAME) AT FORWARD CABIN SERVICE DOOR. STOP DRILLED CRACK, REPAIRED PER SRM 52-00-2 PAGE 4, FIG 1 AND SRM 51-40-3 PAGE 1. (M)Feb 24, 1996 · N243US · Boeing 737201 · Service DoorsSDR USAA960281Angle · corrosionINT - DURING Q-6 CHECK VISUAL INSPECTION, FOUND 4 INCH BY 20 INCH CORRODED AREA RIGHT Z-ANGLE AT AFT SERVICE DOOR STATION 940 TO STATION 1010. REMOVED CORROSION ON ALODINE AND PRIMED. COMPLETED REPAIR PER SRM 51-10-6. LEVEL 1 CORROSION. (M)Feb 24, 1996 · N243US · Boeing 737201 · Fuselage Miscellaneous StructureSDR USAA960280Bulkhead · crackedINT - DURING Q-6 CHECK VISUAL INSPECTION, FOUND 2 INCH LONG CRACK FUSELAGE BULKHEAD STATION 178, WL 200, RBL 6 INCHES. INSTALLED REPAIRED DOUBLER, REPAIRED PER TR 53-10-11. (M)Feb 24, 1996 · N243US · Boeing 737201 · Fuselage Main, BulkheadSDR USAA960279Hinge Fitting · crackedINT - DURING Q-6 CHECK VISUAL INSPECTION, FOUND .25 INCH CRACK LEFT WING AT WS 537.8 LOWER FLANGE OF AILERON HINGE FITTING. FABRICATED AND INSTALLED FLANGE REPAIR PER EA 40893. (M)Feb 24, 1996 · N243US · Boeing 737201 · Wing, Control Surface Attach FittingsSDR USAA960278Floor Beam · corrosionINT - DURING Q-6 CHECK VISUAL INSPECTION, FOUND CORRODED NUT PLATE HOLES AT FLOOR BEAM STATION 460-500 ABOVE STRINGER 27 R. REPLACED ANGLE, REPAIRED PER SRM 53-10-5 FIG 6. CORROSION TASK NR C53-202-01, CORROSION LEVEL 2. (M)Feb 24, 1996 · N243US · Boeing 737201 · Fuselage Main, Floor BeamSDR USAA960277Frame · crackedINT - DURING Q-6 CHECK VISUAL INSPECTION, FOUND .5 INCH CRACK NR 4 STOP CUTOUT (AFT FRAME) AT FORWARD CABIN SERVICE DOOR. STOP DRILLED CRACK, REPAIRED AND INSTALLED. REPAIRED PER SRM 52-00-2 PAGE 4 FIG 1 AND SRM 51-40-3 PAGE 1. (M)Feb 24, 1996 · N243US · Boeing 737201 · Service DoorsSDR USAA960276Clip · corrodedINT - DURING Q-6 CHECK VISUAL INSPECTION, FOUND 2 INCH CORRODED AREA AT STRINGER TIE CLIP BS 540 STRINGER 26 L. REPLACED STRINGER TIE CLIP, REPAIRED PER SRM 53-10-1. CORROSION TASK NR C53-202-01, CORROSION LEVEL 2. (M)Feb 24, 1996 · N243US · Boeing 737201 · Fuselage Miscellaneous StructureSDR USAA960275Intercostal · corrosionINT - DURING Q-6 CHECK VISUAL INSPECTION, FOUND 2 INCH BY 6 INCH CORROSION INTERCOSTAL, STATION 270 TO STATION 294 LBL 10 INCHES. INSTALLED NEW PREFAB INTERCOSTAL, REPAIRED PER BOEING DRAWING 65-45634. (M)Feb 24, 1996 · N243US · Boeing 737201 · Fuselage Miscellaneous StructureSDR USAA960274Skin · crackedINT - DURING Q-6 CHECK VISUAL INSPECTION, FOUND 2 INCH CRACK IN FUSELAGE SKIN 1156 BULKHEAD STRINGER 2 L AND STRINGER 3 L. INSTALLED DOUBLER, REPAIRED PER SRM 53-30-3. (M)Feb 24, 1996 · N243US · Boeing 737201 · Fuselage Main, Plate/SkinSDR USAA960273Skin · crackedINT - DURING Q-6 CHECK VISUAL INSPECTION, FOUND 1 INCH CRACK ON SKIN BS 380 BETWEEN STRINGER 28 L AND BL 0. INSTALLED DOUBLER, REPAIRED PER TR 53-30-04 AND EA 25454. (M)Feb 24, 1996 · N243US · Boeing 737201 · Fuselage Main, Plate/SkinSDR USAA960134Web · crackedINT - DURING Q-6 CHECK VISUAL INSPECTION, FOUND 2 INCH CRACK STATION 639 STUB BEAM WEB LBL 48 WL 206.5. INSTALLED WEB, REPAIRED PER BOEING DRAWING 65C25211. (M)Feb 24, 1996 · N243US · Boeing 737201 · Fuselage Miscellaneous StructureSDR USAA960116Frame · crackedINT - DURING Q-6 CHECK VISUAL AND EDDY CURRENT INSPECTION, FOUND .75 INCH CRACK ON CIRCUMFERENTIAL FRAME WEB STATION 328 4 INCHES BELOW STRINGER 20R. INSTALLED REPAIR DOUBLER, REPAIRED PER SRM 51-40-3. (M)Feb 24, 1996 · N243US · Boeing 737201 · Fuselage Main, FrameSDR USAA960106Frame · crackedINT - DURING Q-6 CHECK VISUAL INSPECTION, FOUND 4 INCH CRACK IN CIRCUMFERENTIAL FRAME STATION 360 4 INCHES BELOW STRINGER 19 R. INSTALLED DOUBLER, REPAIRED PER SRM 51-40-3. (M)Feb 24, 1996 · N243US · Boeing 737201 · Fuselage Main, FrameSDR USAASB95032Retract Mech · malfunctionedFLT NR 1177 - BWI - RETURN TO FIELD, UNABLE TO RETRACT LANDING GEAR. GEAR HANDLE WOULD NOT GO TO UP, DID NOT ATTEMPT TO OVERRIDE. (M)Dec 25, 1995 · N243US · Boeing 737201 · Landing Gear Retraction/Extension System
Back to N243US, cancelled Sep 13, 2004