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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
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)SDR 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)SDR USAA000021Web · crackedWEB CRACKED AT BS 639, WL 208 RIGHT BUTTLINE 63. INSTALLED REPAIR PER SRM 51-40-4. (M)SDR USAA000020Skin · crackedSKIN CRACKED AT LOWER CORNER OF AFT ENTRY DOOR CUTOUT. INSTALLED DOUBLER AND TRIPLER PER SRM 53-30-3 FIG 24. (M)SDR 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)SDR USAA000018Web · crackedWEB CRACKED AT BS 695 LEFT BUTT LINE 61.5 WATER LINE 206. INSTALLED REPAIR DOUBLER PER SRM 41-40-21. (M)SDR USAA000017Tie Clip · crackedFOUND TIE CLIP CRACKED AT BS 685 STRINGER 5R.. INSTALLED NEW TIE CLIP PER EO 5393G227. (M)SDR USAA000016Tie Clip · crackedFOUND TIE CLIP CRACKED AT BS 867 STRINGER 10R. INSTALLED NEW TIE CLIP PER EO 5393G227. (M)SDR USAA000015Tie Clip · crackedFOUND TIE CLIP CRACKED AT BS 706 STRINGER 10L. REPLACED TIE CLIP PER EO5393G227. (M)SDR USAA000014Tie Clip · crackedFOUND TIE CLIP CRACKED AT BS 807, STRINGER 5L. INSTALLED NEW TIE CLIP PER EO5393G227. (M)SDR USAA000013Tie Clip · crackedFOUND TIE CLIP CRACKED AT BS 639, STRINGER 6R. INSTALLED NEW TIE CLIP PER EO 5393G227. (M)SDR USAA000012Tie Clip · crackedFOUND TIE CLIP CRACKED AT BS 559, STRINGER 8R. INSTALLED NEW TIE CLIP PER EO 5393G227. (M)SDR USAA000011Tie Clip · crackedFOUND TIE CLIP CRACKED AT BS 847 STRINGER 10R. INSTALLED NEW TIE CLIP PER EO 5393G227. (M)SDR USAA000010Tie Clip · crackedFOUND TIE CLIP CRACKED AT BS 663 STRINGER 10R. INSTALLED NEW TIE CLIP PER EO 5393G227. (M)SDR USAA000009Tie Clip · crackedTIE CLIP HAS 2 CRACKS AT BS 663 STRINGER 10L.. INSTALLED NEW TIE CLIP PER EO 5393G227. (M)SDR USAA000008Tie Clip · crackedTIE CLIP CRACKED AT BS 827 STRINGER 4R. INSTALLED NEW TIE CLIP PER EO 5393G227. (M)SDR USAA000007Tie Clip · crackedTIE CLIP CRACK AT BS 767 STRINGER 10R. INSTALLED NEW TIE CLIP PER EO 5393G227. (M)SDR USAA000006Tie Clip · crackedFOUND TIE CLIP CRACKED AT BS 639. INSTALLED NEW TIE CLIP PER EO 5393G227. (M)SDR USAA000005Tie Clip · crackedTIE CLIP CRACKED AT BS 907, STRINGER 2L. INSTALLED NEW TIE CLIP PER EO 5393G227. (M)SDR USAA000004Web · crackedWEB CRACKED AT BS 616 STRINGER 17L. INSTALLED NEW CREASE BEAM WEB PER SRM 51-10-1. (M)SDR USAA000003Frame · crackedFRAME CRACKED AT BS 290 STRINGER 12R AND 13R.. INSTALLED NEW CHORD ANGLE PER SRM 51-10-1. (M)SDR 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)SDR 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 EXTINSDR USAASB98322Battery · dischargedBWI - MAINTENANCE FOUND THE MID CABIN CEILING EMERGENCY EXIT LIGHT INOP. MAINTENANCE REMOVED AND REPLACED THE BATTERY SUPPLY. OPERATIONAL CHECK GOOD. (M)SDR 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)SDR 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 INCIDENSDR 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)SDR 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 PACKSDR 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)SDR 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)SDR 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)SDR 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 WASDR 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)SDR 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)SDR 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)SDR 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)SDR 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)SDR 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)SDR 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)SDR 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)SDR 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)SDR 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)SDR 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)SDR 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)SDR 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)SDR 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)SDR 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)SDR 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)SDR 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)SDR 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)
Back to N243US, cancelled Sep 13, 2004