N27246
Service difficulty reports · 149
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 = 'N27246' AND registry_match = 'registration' 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 = 'N27246' AND registry_match = 'registration' 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 CALA2014050900577Frame · crackedCRACK WAS FOUND ON THE FRAME HOLES WHICH ATTACH THE BRACKET BETWEEN STRINGER 8L - STRINGER 9L, STATION 400 L=0. 8 INCHES IAW EA 5310-04716 REV G OPERATION 02 TASK 9.0 FIG 3 STEP 1. REMOVED DICATION, APPLIED PRIMER & DRILLED HOLES IN ANGLE A FLANGE IAW EA5 THESDR CALA2014050900576Frame · crackedTHE CRACK WAS FOUND ON THE FRAME HOLES WHICH ATTACH THE BRACKET BETWEEN STRINGER 8R - STRINGER 9R STATION 440 L= 0.75 INCHES. REMOVED THE SUPPORT BRACKET FASTENERS. CUT OUT THE FRAME WEB & THE 2 RIVET HO 716 REV G OPERATION 02 TASK 9.0 FIG 3 STEP 5 MADE REPASDR CALA2014050900575Frame · crackedAFTER REMOVE THE BRACKET PERFORMED HFEC INSPECTION OF FRAME & BRACKET AT STATION 727B BTW STRINGER 8R & STRINGER 9R FOUND CRACK ON THE FRAME. REMOVED DICTATION & APPLIED PRIMER, DRILLED HOLES IN ANGLE A FLANGE IAW EA5 THE SUPPORT BRACKET FASTENERS. INSTALLEDSDR CALA2014050900574Frame · crackedAFTER REMOVING THE BRACKET PERFORMED HFEC INSPECTION OF FRAME & BRACKET AT STATION 500A BETWEEN STRINGER -8R & STRINGER -9R FOUND CRACK ON THE FRAME. IAW EA5310-04716 REV G OPERATION 02 TASK 9.0 FIG 3 STEP 1 REMOVED DICTATION. APPLIED PRIMER 02 TASK 9.0 FIG SDR CALA2014050900571Frame · crackedAFTER REMOVING THE BRACKET PERFORMED HFEC INSPECTION OF FRAME & BRACKET AT STATION 480 BETWEEN STRINGER -8L & STRINGER -9L. FOUND CRACK ON THE FRAME. REMOVED DICTATION IAW EA5310-04716 REV G OPERATION 02 TASK 9.0 FIG 3. APPLIED PRIMER 02 TASK 9.0 FIG 3 STEPSDR CALA2013092400695Warning System · false indicationLE TRANSIT LIGHT AFTER DEPARTURE MESSAGE NUMBER 27-81220. FOUND ON FAULT HIDTORYIN FSEU TRIED VISUAL INSPECTED PROX SENSORS CONDITION GOOD FSEU BITE TEST NO FAULT FOUND. ALSO OPERATIONS FLAP CHECKED NORMAL.SDR CALA2013072900520Limit Switch · faultyBOTH YOKE NOSE DOWN TRIM SWITCHES INOPERATIVE. YOKE NOSE UP AND AUTOPILOT NOSE UP & NOSE DOWN OPERATED NORMALLY. USED FOR ENTRY. R & R STABILIZER TRIM LIMIT SWITCH IAW AMM 27-41 -94. OPS NORMAL.SDR CALA2013050200245Battery · inoperativeDURING SERVICE 2 CHECK, FOUND SEAT ROW 15 TO 24 LT SIDE EMERGENCY LIGHTS INOPERATIVE. R & R BATTERY AND CHARGER IAW AMM 33-51-06-960-806. OPS CHECKED NORMAL.SDR CALA2012111900811Battery Pack · no testEMERGENCY LIGHT BATTERY PACK FAILED CAPACITY CHECK. R & R BATTERY PACK IAW AMM 33-51-06-960-805.SDR CALA2012111900810Battery Pack · no testEMERGENCY LIGHT BATTERY PACK FAILED CAPACITY CHECK. R & R BATTERY PACK IAW AMM 33-51-06-960-805.SDR CALA2012111900809Battery Pack · no testEMERGENCY LIGHT BATTERY PACK FAILED CAPACITY CHECK. R & R BATTERY PACK IAW AMM 33-51-06-960-805.SDR CALA2012111900808Battery Pack · no testEMERGENCY LIGHT BATTERY PACK FAILED CAPACITY CHECK. R & R BATTERY PACK IAW AMM 33-51-06-960-805.SDR CALA2012111900807Battery Pack · no testEMERGENCY LIGHT BATTERY PACK FAILED CAPACITY CHECK. R & R BATTERY PACK IAW AMM 33-51-06-960-805.SDR CALA2012111900806Battery Pack · no testEMERGENCY LIGHT BATTERY PACK FAILED CAPACITY CHECK. R & R BATTERY PACK IAW AMM 33-51-06-960-805.SDR CALA2012110900789Handle · dislodgedAFT CABIN ENTRY DOOR LIGHT ILLUMINATED ON TAKEOFF ROLL AT ABOUT 120 KTS. REJECTED, CHECKED BOTH AFT MAIN DOORS, OPS CHECKED OK, CLEANED TARGETS, ALL CHECKED NORMAL, IAW F/A ON T/O ROLL , LT AFT DOOR HANDLE POPPED UP CAUSING CAUTION LIGHT, INSPECTED IAW MM 05SDR CALA2012041800271Battery Pack · dischargedLEFT EXTERIOR OVERWING EMERGENCY LIGHT INOP FWD AND AFT R&R APPLICABLE BATTERY PACK IAW MM 33-51-06, OPS CHECKS GOOD.SDR CALA2012031400184Skin · damagedFWD CARGO DOOR CUTOUT HAS A GOUGE & DENT AT LOWER FWD EDGE PERFORMED INTERIM REPAIR PER PART 1 OF ECRA 5331-01585.SDR CALA2012021000078Stringer · corrodedW/C 29-5300-1-1800 FWD CARGO BAY 11 STRINGER S28L HAS 3 SPOTS OF CORROSION (MARKED). PERFORMED REPAIR ON STRINGER 28L FWD CARGO PER SRM 53-00-03. ALL DAMAGE REMOVED.SDR CALA2012020600073Battery Pack · dischargedEMERGENCY LIGHTS ON BULLNOSE AT 30L , 32L AND EXIT SIGN AT L2 DOOR (LWR) WOULD NOT ILLUMINATE DURING TEST. FOUND BATTERY PACK TO BE DEAD. REPLACE BATTERY AND LIGHTS CHECKED GOOD.SDR CALA2011072800516Access Panel · corrodedLOWER LEADING EDGE ACCESS PANEL 621 RB SLAT STATION 337.62HAS 2 AREAS OFF CORROSION (MARKED) REF W/C 29-2700-1-2109 REPAIR PER EC/RA 5730-02680 SEE ADDTL WORK COMPLETED ON FORM 44.0008 INITIATING DIP TO PERFORM A PERMANENT REPAIR W/IN 12 MONTHS PLANNING TO CONSDR CALA2011072800515Skin · corrodedFX STA 727J LBL 10 DRAIN HOLE CUTOUT AREA FOUND CORROSION AFTER DRAIN PLUG REMOVED FX STA 727J LBL 10 DRAIN HOLE CUTOUT AREA CORROSION REMOVED. DEPTH 0.024" (ORIG 0.98") OUT OF SRM 53-00-01 ALLOWABLE DAMAGE 1 FIG 103 LIMIT AND CORRODED SKIN AREA REPAIRED AS PSDR CALA2011072800514Skin · corrodedFX STA 727E RBL 10 DRAIN HOLE CUTOUT AREA FOUND CORROSION. AFTER DRAIN PLUG REMOVED. FX STA 727E RBL 10 DRAIN HOLE CUTOUT AREA CORROSION REMOVED. DEPTH 0.019" (ORIG 0.116") OUT OF SRM 53-00-01 ALLOWABLE DAMAGE 1 FIG 103 LIMIT AND SKIN CORRODED AREA REPAIREDSDR CALA2011072700513Floor Support · corrodedCABIN STA 992 RBL 35-38 FLOOR SUPPORT HAT SECTION CORRODED. CABIN STA 992 RBL 35-38 FLOOR SUPPORT HAT SECTION CORROSION REMOVED DEPTH 0.012 ORIG 0.055 OUT OFF SRM 53-70-51 ALLOWABLE DAMAGE 1 FIG 103 LIMIT AND CORRODED HAT SECTION REPLACED SRM 51-10-02 AND NEWSDR CALA2011050400339Stringer · corrodedFWD CARGO COMPARTMENT, STRINGER CORRODED AROUND FASTENERS, S-27L JUST AFT OF STA 500E. REPAIR OF STRINGER PER SRM 53-00-03. OKAY FOR SERVICE.SDR MZZA2010090900022Battery Pack · dischargedEMERGENCY LIGHTS AT OVERHEAD BINS/BULLNOSE SEAT ROWS 21, 23, 24, 26, 28 D, E, F AND 4,10,12, A, B, C INOP. REMOVED AND REPLACED BATTERY PACK AT STATION/WIRE CONNECTOR M1671 IAW AMM 33-51-06, OP CHECK NORMAL.SDR MZZA2010070800014Battery Pack · activatedEMERGENCY LIGHTS AT OVERHEAD BINS/BULLNOSE SEAT ROWS 21, 23, 24, 26, 28 D, E, F AND 4, 10, 12 A, B, C INOP. REMOVED AND REPLACED BATTERY PACK AT STATION / WIRE CONNECTOR M1671 IAW AMM 33-51-06, OP CHECK NORMAL.SDR MZZA2010051100008Switch · defectiveAFT ENTRY DOOR LIGHT ILLUMINATED WHEN T/O POWER APPLIED. PERFORMED AFT ENTRY DOOR TEST PER AMM 52-13-00-700-805. TEST IS GOOD. AIRCRAFT OK TO CONTINUE SERVICE.SDR MZZA2009110400109Cargo Track · crackedFWD BIN - RT CARGO TIE DOWN TRACK BETWEEN BAYS 5 AND 6 CRACK AT RADIUS. REMOVED AND REPLACED FWD CARGO TRACK TIE DOWN RT SIDE FROM FWD BULKHEAD TO SPLICE BETWEEN BAY 5 & 6 PER SRM 53-00-53. FABRICATED NEW TIE DOWN PER SRM 53-00-53, REPAIR 3. REF TO FORM 44.SDR MZZA2009110400108Stringer · corrodedFORWARD BIN STRINGER 26R BAY 13 HAS 21 EA FASTENERS WITH CORROSION. CLEAN CORROSION PER AMM 51-21-31. FIRST 7 RIVETS AFT OF FWD BELT FRAME IN BAY 13 ARE WITHIN LIMITS. THE REST ARE OUT OF LIMITS PER SRM 53-00-03. PERFORMED STRINGER REPAIR PER SRM 53-00-03 SDR MZZA2009101500106Oven · odorAN ELECTRICAL BURNING SMELL WAS DETECTED BY AFT FLIGHT ATTENDANTS IN THE AFT GALLEY. THE SMELL APPEARS TO BE FROM OVEN NR 1. INSPECTED AFT GALLEY OVEN PANEL CONTROLLERS POS NR 1, 2 AND 3, NO EVIDENCE OF BURNT WIRING OR SMELL. OPERATED OVENS FOR 15 MINUTES NSDR MZZA2009101400105Hmu · malfunctionedNUMBER 1 ENGINE FLAMED OUT DURING TAXI IN. ENG FAIL LIGHT ILLUMINATED. START LEVER REMAINED IN IDLE DETENT. MAIN PUMPS ON WITH SUFFICIENT FUEL IN TANKS. INSPECTED NUMBER 1 ENGINE INTAKE AND EXHAUST. NO DEFECTS. TROUBLESHOT PER FIM 73-05 TASK 805. ALL CHESDR MZZA2009072000100Battery Pack · inoperativeL-2 EXTERIOR EMERGENCY LIGHT INOPERATIVE, REMOVED AND REPLACED BATTERY ASSEMBLY PER AMM 33-51-06.SDR MZZA2009031000031Skin · corrodedCORROSION AT RT WING CENTER WING FWD LOWER SKIN AT STA 540 WBL 52 UNDER DRAG BRACE. REPAIR CARRIED OUT IAW EC/RA 5730-02550.SDR MZZA2009031000030Floorbeam · corrodedCORROSION FOUND AROUND SCREW HOLE ON CABIN FLOORBEAM BS 986.5 RBL 43. REPAIR CARRIED OUT IAW EC/RA 5320-01924.SDR MZZA2009030400026Seat Track · corrodedCORROSION FOUND ON CABIN SEAT TRACK LBL45 BS 370. SEAT TRACK REMOVED AND REPLACED IAW B737-800 SRM 51-10-02, HOLES PICKED UP AS PER SRM 51-40-05 REV 34. SEAT TRACK SUBSTITUTED AS PER EC/RA 5321-01379.SDR MZZA2009030400025Intercostal · corrodedCORROSION FOUND AT AFT CABIN FLOOR SUPPORT STRUCTURE INTERCOSTAL UPPER SURFACE BETWEEN BS 947 TO BS 967 RBL43. INTERCOSTAL REMOVED AND REPLACED IAW B737-800 SRM 51-10-02 AND HOLES PICKED UP AS PER SRM 51-40-05 REV 34.SDR MZZA2009030400024Seat Track · corrodedCORROSION FOUND ON CABIN SEAT TRACK LBL25, BS 370. SEAT TRACK REMOVED AND REPLACED IAW B737-800 SRM 51-10-02, HOLES PICKED UP AS PER SRM 51-40-05 REV 34. SEAT TRACK SUBSTITUTED AS PER EC/RA 5321-01379.SDR MZZA2009030400023Floor Support · corrodedSURFACE CORROSION FOUND ON FWD CABIN FLOOR SUPPORT STRUCTURE BL0 BETWEEN BS 268 TO BS 277. CHANNEL REMOVED AND REPLACED IAW SRM 51-10-02, HOLES PICKED UP AS PER SRM 51-40-05 REV.34.SDR MZZA2009030400022Floorbeam · corrodedCORROSION FOUND AT FWD CABIN FLOORBEAM BS 344 AT LBL4.5, LBL3.5, RBL7 AND LBL8. REPAIR CARRIED OUT IAW EC/RA 5321-01608.SDR MZZA2009030400021Spar · corrodedSURFACE CORROSION ON LT HORIZONTAL STABILIZER AFT SPAR UPPER CHORD BETWEEN STABILIZER STA.180 AND STABILIZER STA 193. REPAIRED PER EC/RA 5510-01974.SDR MZZA2009030400020Floorbeam · corroded3 AREAS AROUND SCREW HOLES ON CABIN FLOORBEAM BS 986.5 BETWEEN LBL 20 TO LBL40 CORRODED. REPAIR CARRIED OUT IAW EC/RA 5321-01429.SDR MZZA0800004Power Supply · dischargedEMERGENCY LIGHTS INOP EXT R1 DOOR OVERHEAD R1 DOOR AND AT EMERGENCY FLOODLIGHTS ABOVE SEAT 2EF, 3EF AND 4EF. REMOVED AND REPLACED POWER SUPPLY PER AMM33-51-06-960-806, OPERATION TEST OK PER AMM 33-51-00.SDR MZZA0800002Megaphone · inoperativeFORWARD MEGAPHONE FOUND INOPERATIVE. REMOVED AND REPLACED FORWARD MEGAPHONE IAW IFM 25-60-01. OK FOR SERVICE.SDR MZZA080002Megaphone · inoperativeFORWARD MEGAPHONE FOUND INOPERATIVE. REMOVED AND REPLACED FORWARD MEGAPHONE IAW IFM 25-60-01. OK FOR SERVICE.SDR MZZA0700005Bearing · frozenTHE L-1 DOOR WAS DIFFICULT TO OPEN AND CLOSE. MAINTENANCE FOUND THE CAM FOLLOWER BEARING FROZEN. THE BEARING WAS REPLACED. OPERATIONAL CHECKS WERE GOOD IAW MM 52-11-00.SDR MZZA0600010Charger · inoperativeTHE OVERHEAD EMERGENCY LIGHTS AT SEAT ROWS 12-21 WERE FOUND INOPERATIVE. THE M1671 CHARGER AND BATTERY PACK ASSEMBLY WAS REMOVED AND REPLACED IAW MM 33-51-06.SDR MZZA0500010Skin · corrodedINSPECTION FOUND CORROSION TO THE EXTERIOR OF THE FUSELAGE SKIN ADJACENT TO THE DRAIN HOLE AT STA 727J, BL 0. THE SKIN WAS REPAIRED IAW ECRA 5330-03490.SDR MZZA0500003Actuator · leakingA FUEL ODOR WAS NOTICED THOUGHOUT THE CABIN DURING LANDING AT GUM. THE FIRE TRUCKS WERE REQUESTED. MX FOUND NR 1 ENGINE VSV ACTUATOR LEAKING AT ENGINE VENT. THE NR 1 ENGINE RT VSV ACTUATOR WAS REMOVED AND REPLACED IAW MM. NR 1 ENGINE WAS RUN, OPS AND LEAKED CHSDR CALA0100108Skin · gougedTHE FUSELAGE SKIN WAS GOUGED FORWARD OF THE AFT LAV SERVICE PANEL AT STA 827. THE GOUGED SECTION OF SKIN WAS REMOVED AND THE AREA WAS REPAIRED IAW SRM 53-00-01.
Back to N27246