N46625, cancelled Jan 22, 2013
Service difficulty reports · 37
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 = 'N46625' AND deregistration_id = 'N46625-2013-01-22' 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 = 'N46625' AND deregistration_id = 'N46625-2013-01-22' 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 CALA2012120700854Skin · dentedFUSELAGE SKIN DENTED AT STA 827, BL 0 (BELOW AFT CARGO DOOR CUTOUT) CUT OUT DAMAGE AND INSTALLED FILLER AND DOUBLER REF ECRA 5331- 01668.SDR CALA2012120600849Skin · dentedDURING WALKAROUND, FOUND A DENT JUST AFT OF THE 178 BULKHEAD AT THE 7 O`CLOCK POSITION LOOKING FOWARD.SDR CALA2012092000620Seat Track · failedAT GATE , RELEASED PARK BRAKE, CAPTAIN`S SEAT BROKE. FOUND BOTH FWD CAPTAIN`S SEAT TRACKS CRACKED AND BROKEN OFF. REPLACED BOTH FWD SEAT TRACKS IAW AMM 25-11-11-406-005-001, PN S232T303 -1005, INSTALLED CAPTAIN`S SEAT IAW AMM 25-11-11- 422-132.SDR CALA2012081700512Warning Light · illuminatedON APPRAOCH, GEAR HANDLE DOWN, INDICATIONS SHOWED ONLY "RED" NOSE GEAR LIGHT. PERFORMED MANUAL GEAR EXTENSION, NO CHANGE, NOTICED LANDING GEAR AIR/GROUND RELAY CIRCUIT BREAKER TRIPPED & RESET, GEAR INDICATIONS NORMAL. REF L/PS 4584879 & 4584880, ACCOMPLISHED ASDR CALA2012070200423Control Valve · inoperativeAT AT FL250, RT EQUIPMENT COOLING EXHAUST LIGHT CAME ON, PERFORMED QRH PROCEDURES. REPLACED THE AIR FLOW CONTROL VALVE IAW AMM 21-58-31-401. OPS CHECKED NORMAL.SDR CALA2012010600014Uplock Sensor · failedLEFT GEAR UNSAFE LIGHT AFTER TAKEOFF. GEAR CAME DOWN NORMALLY FOR LANDING. T/S PER M/M 32-61-00-101. UPLOCK SENSOR S72 BAD. REPLACED S72 SW IAW M/M 36-61-21. SWUNG GEAR. OPS CHECK NORMAL.SDR CALA2010090800419Tee Fitting · corrodedSUPPORT TASK - INTERGRANULAR CORROSION IN E/E BILGE LBL 12 JUST FWD OF DOOR CUTOUT INTERIM REPAIRED ELECTRONIC ACCESS DOOR LBL 6.74 BEAM LOWER TEE CORD PER ECRA 5311-01503 AND INITIATED A DIP TO READ AS FOLLOWS: ON OR BEFORE SEPTEMBER /3/2012 PERFORM INSPECTISDR CALA2010090200412Shear Tie · corrodedB737-53-3-0306 CORROSION ON SHEAR TIE FWD AND AFT SIDE OF STA 767 BL 0 BETWEEN STR 27 L AND 27 RT FABRICATED AND INSTALLED SHEAR TIE REPAIR REF SRM 53-00-07.SDR CALA2010090200409Clevis · corrodedSUPPORT TASK RT HORZ STAB AFT LOWER CLEVIS HAS CORROSION REMOVED LIGHT CORROSION AND TREATED AS REQUIRED PER SOPM 20-10-03 AND SRM 55-10-10.SDR CALA2010090200408Frame · crackedSUPPORT TASK STA 303.9 FRAME WEB CRACKED AT S16L REF EA 5310-04 659 OP2 STEPS 8 & 9 CABIN INSTALLED REPAIR AT FRAME STA 303.9 REF EA 5310-04659 OP2.SDR CALA2010080400374Skin · crackedSUPPORT TASK REF EA 5330-03736 REV B STEP 14 TWO FASTENER HOLES SHOW CRACK INDICATIONS. BOTH FASTENERS ARE IN A ROW AT STA 304 ONE AT WL 260 AND ONE AT WL 258.30 FWD ENTRY DOOR UPPER HINGE. CRACKS INDICATE ON AFT EDGE OF HOLES. FASTENER HOLES HAVE BEEN REPASDR CALA2008121101142Strap · crackedBOTTOM OF FLOORBEAM STABILIZER STRAP CRACKED AT BODY STATION 312 RBL-36. REPAIRED DAMAGED STABILIZER STRAP ON BOTTOM OF FLOORBEAM AT BODY STATION 312 RBL-36 PER B737-500 SRM 53-10-51, REPAIR 4.SDR CALA0800968Cable · brokenL-2 DOOR ESCAPE SLIDE LATCH CABLE HAS BROKEN STRANDS, REFERENCE WORK CARD 24-0550-1-0004 STEP 16. REMOVED AND REPLACED L-2 DOOR ESCAPE SLIDE LATCH CABLE ASSY REF M/M 25-61-35.SDR CALA0800967Cable · brokenR-2 DOOR ESCAPE SLIDE LATCH CABLE HAS BROKEN STRANDS, REFERENCE WORK CARD 24-0550-1-0004 STEP 16. REMOVED AND REPLACED R-2 DOOR ESCAPE SLIDE LATCH CABLE ASSY REF M/M 25-61-35.SDR CALA0800703Fan · failedPASSING THROUGH 11000 ON DESCENT ELECTRICAL AND/OR RUBBER BURNING ODOR, WAS NOTED, NO SMOKE OBSERVED. A/C SMOKE FUME CHECKLIST PERFORMED AND ODOR LESSENED WHEN RT PACK ISOLATED. ODOR STARTED QUICKLY IN FIRST CLASS THRU MID CABIN AND DISSIPATED SOMEWHAT ONCE SDR CALA0800318Pan · crackedL1 DOOR PAN CRACKED AT AFT EDGE AROUND STOP PIN BRACKET 4TH FROM BOTTOM. INSTALLED REPAIR ANGLE REF ECRA 5210-02014.SDR CALA0800317Pan · crackedL1 DOOR PAN CRACKED AT AFT EDGE AROUND NR 5 STOP PIN BRACKET FROM BOTTOM. INSTALLED REPAIR ANGLE REF ECRA 5210-02014.SDR CALA0800316Intercostal · crackedL1 DOOR WEB CRACKED I/B OF TORQUE UPPER END (ONE BAY ABOVE TORQUE BOX). REMOVED AND INSTALLED NEW INTERCOSTAL AND CLOSED INNER SKIN REF SRM 51-40-02.SDR CALA0800314Door Frame · crackedFWD CARGO DOOR CUTOUT AFT FRAME HAS 1 INCH CRACK, AT BOTTOM DOOR STOP PAD FOOT PRINT. REMOVED & REPLACED FWD CARGO DOOR CUTOUT AFT FRAME REF SRM 51-40-02.SDR CALA0800614Door Frame · crackedFWD CARGO DOOR CUTOUT AFT FRAME HAS 1 INCH CRACK, AT BOTTOM DOOR STOP PAD FOOT PRINT. REMOVED & REPLACED FWD CARGO DOOR CUTOUT AFT FRAME REF SRM 51-40-02.SDR CALA0800304Stringer · crackedS16L CRACKED STA 482B-4". REPAIRED S16L STA 482B-4" REF SRM 53-00-03 REPAIR 1 FIG 201 PG 201.SDR CALA0800302Web · crackedWEB CRACKED STA 277 AT S14R. INSTALLED WEB ASSY IAW SRM 51-40-02.SDR CALA0800299Web · corrodedAFT CARGO DOOR CUTOUT LOWER WEB CORROSION MARKED. REMOVED AND REPLACED WEB REF SRM 51-40-02.SDR CALA0800297Bracket · corrodedAFT CARGO BETWEEN STA 747 AND 767, ANTENNA BRACKET CORROSION MARKED. REPLACED AFT CARGO ANTENNA BRACKET AT STA 747-767 PER SRM 51-40-02.SDR CALA0800291Intercostal · crackedRT SIDE OF FUSELAGE STA 277 TO 290 NR 9 INTERCOSTAL CRACKED. REPLACED INTERCOSTAL AS REQUIRED IN SRM 51-10-2.SDR CALA0800273Carriage · corrodedNR 3 MID FLAP CARRIAGE, BOTH ARMS PITTED WITH CORROSION. REMOVED AND REPLACED WITH SERVICEABLE I/B AND O/B CARRIAGE HALVES ON O/B SIDE OF NR 3 MID FLAP.SDR CALA0800272Torque Tube · corrodedNR 3 MID FLAP I/B AND O/B TORQUE TUBES CORRODED AND PITTED. REMOVED AND REPLACED WITH SERVICEABLE TORQUE TUBES I/B AND O/B REF CMM 57-53-17.SDR CALA0500282Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 986.5, RBL 9 TO RBL 45. REPAIRED IAW ECRA 5321-01273.SDR CALA0500269Angle · corrodedINSPECTION FOUND R-2 DOOR ZEE ANGLE CORRODED AT STA 975-990, RBL 50 TO RBL 51. THE ANGLE WAS REMOVED AND A NEW ANGLE WAS INSTALLED IAW SRM 51-40-02.SDR CALA0500268Channel · corrodedINSPECTION FOUND L-1 DOOR ENTRY Z-CNANNEL CORRODED AT STA 277-360, LBL 39. A NEW Z-CHANNEL WAS INSTALLED IAW SRM 51-40-02.SDR CALA0300249Strip · crackedINSPECTION FOUND A .25 INCH CRACK AT O/B CORNER OF RT WHEEL WELL FORWARD FAIRING AFT ATTACH STRIP. AN ANGLE WAS INSTALLED IAW SRM 51-40-02.SDR CALA0300238Intercostal · crackedINSPECTION FOUND A 1 INCH CRACK IN INTERCOSTAL AT STA 344-360, BL 0. THE INTERCOSTAL WAS REMOVED AND REPLACED IAW SRM 53-30-51.SDR CALA0300237Intercostal · crackedINSPECTION FOUND A 2 INCH CRACK IN INTERCOSTAL AT STA 380-400, BL 0. THE INTERCOSTAL WAS REMOVED NAD REPLACED IAW SRM 53-30-51.SDR CALA0300059Skin · crackedINSPECTION FOUND A 1.5" CRACK IN FUSELAGE SKIN BELOW AFT CARGO PIT THRESHOLD AT STA 807, S26R-S27R. THE SKIN WAS REPAIRED IAW ECRA 5330-03214.SDR CALA0300072Skin · damagedMAINTENANCE DISCOVERED A CREASE TO THE FUSELAGE SKIN AT BS 807 BETWEEN S26R AND S27R DURING GROUND OPERATIONS IN CLE. WHEN THE CREASED AREA WAS CUT OUT THE UNDERLYING SHEAR TIE WAS FOUND DAMAGED AND WAS REPLACED. A PERMANENT FUSELAGE SKIN REPAIR WAS PERFORMESDR CALA0002006Skin · dentedINSPECTION FOUND AFT CARGO DOOR EXTERNAL SKIN DENTED AND SCRATCHED. THE DAMAGED SKIN WAS REMOVED AND REPLACED IAW SRM 51-40-02.SDR CALA0001999Strap · corrodedINSPECTION FOUND STRAP AT LOWER JAMB OF AFT CARGO DOOR CORRODED AT STA 807-847 ABOVE L27R. A NEW STRAP WAS INSTALLED IAW SRM 51-10-2.
Back to N46625, cancelled Jan 22, 2013