N492MC
Service difficulty reports · 206
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 = 'N492MC' 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 = 'N492MC' 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 UIEA2021040200795Hinge · corrodedCORROSION - HINGE, AIR CONDITION BAT PANEL 141EL FWD MID AFT HINGE, UPPER HALF X1 (AFT), LOWER HALF X1 (AFT), LOWER ANGLE X2 (MID, AFT) UPPER ANGLE X3 (FWD, MID, AFT). IAW SMM 20-51-01-902-008 REV 100, RMV LOWER ANGLE 2EA (MID AFT) AT PNL 191EL. IAW EI NO T202SDR UIEA2021040200796Torque Box · corrodedCORROSION - DAMAGE ON LH HST TORQUE BOX TOP SKIN PANEL UPPER SURFACT OUTBOARD OF STAB STA 165.64. STRINGER 3. REMOVE THE AFFECTED FASTENERS IAW SRM 51-40-02 REV 91. BLENDED OUT THE DAMAGE AREA IAW SRM 55-10-01 REV 91. PFM NDT INSP REFER TO JOB CARD ATTACHING SSDR UIEA2021040200797Skin · deformedDEFORM - SKIN, FUSELAGE SEC 46 MAIN ENTRY DOOR LH NO. 5 EXTERNAL SKIN. AFT LWR CORNER AREA.REPAIR THE L5 MAIN ENTRY DOOR SKIN DAMAGED AREA IAW 747-400F SRM 52-00-01-2R-9 REV 91 AND EI NO T2021A52M-548 REV 1. JOB COMPLETED AND CONDITION CHECK NORMAL.SDR UIEA2021040200798Channel · crackedCRACK DAMGE ON A FASTENER HOLE OF TENSION TIE AFT CHANNEL AT STA 860 RH SIDE.REPAIR DAMAGED AREA IAW SRM 53-20-30-2R-1 REPAIR 1 REV 91 AND EI NO T2021A53M-694 REV 1. JOB COMPLETED AND CONDITION CHECK NORMAL.SDR UIEA2021040200799Seat Track · crackedFOUND MD TRACK STRUCTURE CRACK AT STA 1485 RBL 75.92.REPAIR DAMAGE AREA IAW SRM 53-00-52-2R-13 REPAIR 13, DETAIL 1. REV 91 AND BOEING DWG NO 65B38251 SH 32 REV -. JOB COMPLETED AND CONDITION CHECK NORMAL.SDR UIEA2021040200800Seat Track · corrodedFOUND MD SEAT TRACK STRUCTURE CORROSION BETWEEN STA 1930 AND STA 2100 LBL 98.58(<P>REPAIR DAMAGED AREA IAW SRM 53-00-52-2R-6 REPAIR 6 REV 91 AND EI NO T2021A53M-782 REV 2 BOEING DWG NO 65B38251 SH 61 REV A, 65N38288 SH3 REV A 65B38406 SH8 REV A, 65B38306 SH6 RSDR UIEA2021040200801Floorbeam · corrodedFOUND MD CGO SUPPORT STRUCTURE CORROSION AT STA 540 LBL10 - RBL10(<P>REPAIR DAMAGED AREA IAW SRM 53-00-51-2R-3 REPAIR 3. REV 91 AND BOEING DWG NO 65B38027 SH6 REV A, 65B38027 SH7 REV C AND EI NO T2021A53M-957 REV 0. JOB COMPLETED AND CONDITION CHK NORMAL</P>)SDR UIEA2021040200802Seat Track · corrodedFOUND MD SEAT TRACK STRUCTURE CORROSION AT STA 2158, LBL 11.33(<P>REPAIR DAMAGE AREA IAW SRM 53-00-52-2R-12 REPAIR 12, DETAIL III REV 91 AND BOEING DWG NO 65B38253 SH53 REV -, 65B38253 SH54 REV -. JOB COMPLETED AND CONDITION CHK NORMAL.</P>)SDR UIEA2021040200803Seat Track · corrodedFOUND M/D SEAT TRACK STRUCTURE CORROSION AT STA 2020 LBL 11.33(<P>REPAIR DAMAGED AREA IAW SRM 53-00-52-2R-12. REPAIR 12 DETAIL III REV 91 AND BOEING DWG NO 65B38253 SH51 REV A, 65B38253 SH52 REV A. JOB COMPLETED AND CONDITION CHK NORMAL.</P>)SDR UIEA2021040200804Seat Track · corrodedFOUND MD SEAT TRACK STRUCTURE CORROSION AT STA 1610 RBL 11.33(<P>REPAIR DAMAGED AREA IAW SRM 53-00-52-2R-12 REPAIR 12, DETAIL III REV 91 AND BOEING DWG NO 65B38253 SH48 REV -. JOB COMPLETED AND CONDITION CHECK NORMAL.</P>)SDR UIEA2021040200805Floorbeam · corrodedFOUND MD FLOOR BEAM CORROSION AT STA 1580, LBL 90(<P>REPAIR DAMAGED AREA IAW SRM 53-00-51-2R-3 REPAIR 3 REV 91 AND BOEING DWG NO 65B38079 SH9. REV -. JOB COMPLETED AND CONDITION CHK NORMAL.</P>)SDR UIEA2021040200806Seat Track · corrodedFOUND MD SEAT TRACK STRUCTURE CORROSION AT STA 1920-1940, RBL 98.58(<P>REPAIR DAMAGE AREA IAW SRM 53-00-52-2R-6 REPAIR 6 REV 91. AND EI NO T2021A53M-764 REV 2 BOEING DWG NO 65B38251 SH 67 REV A, 65B38406 SH8 REV A. JOB COMPLETED AND CONDITION CK NORMAL.</P>)SDR UIEA2021040200807Seat Track · corrodedFOUND MD SEAT TRACK CORROSION AT STA 2100, RBL 98.58(<P>REPAIR DAMAGE AREA IAW SRM 53-00-52-2R-6 REPAIR 6 REV 91 AND EI NO T2021A53M-764 REV 2 BOEING DWG NO 65B38251 SH67, REV A, 65B38406 SH8 REV A. EI NO T2021A53M-764 REV 2. ATTACHED THE JC NO 5629861 (801). SDR UIEA2021040200808Seat Track · corrodedFOUND MD SEAT TRACK STRUCTURE CORROSION AT STA 2160, LBL 89.67.(<P>REPAIR DAMAGE AREA IAW SRM 53-00-52-2R-6 REPAIR 6 REV 91, EI NO T2021A53M-766 REV 1, BOEING DWG NO 65B38251 SH35 REV A. JOB COMPLETED AND CONDITION CHK NORMAL.</P>)SDR UIEA2021040200809Skin · corrodedCORROSION - FOUND CORROSION AT STA 1240 5-6R INNER SURFACE SKIN.(<P>REMOVED THE AFFECTED FASTENERS IAW SRM 51-40-02 REV 91. BLENDED UT THE DAMAGED AREA IAW SRM 53-00-01 REV 91. PFM NDT INSP REFER TO JOB CARD ATTACHING SHEET NO 0296229, 0296264 8 DATA SHEET NO SDR UIEA2021040200810Seat Track · corrodedCORROSION DAMAGES ON SEAT TRACK (PN 65B16026-34) BETWEEN STA 110 AND STA 1200 RBL 11.33(<P>REMOVED DAMAGED PART IAW SRM 51-40-02 REV 91. REPAIR THE TRACK IAW EI NO T2021A53M-804 REV 1, SRM 51-40-02 REV 91 BOEING DWG 11140801 SH2 REV D AND SH3 REV E. JOB COMPLESDR UIEA2021040200811Seat Track · corrodedCORROSION DAMAGES ON SEAT TRACK (PN 65B16026-33) BETWEEN STA 1100 AND 1200 AT LBL 11.33(<P>REMOVE DAMAGED PART IAW SRM 51-40-02 REV 91. REPAIR THE TRACK IAW EI NO T2021A53M-803 REV 1, SRM 51-40-02 REV 91, BOEING DWG 11140801 SH2. REV D. AND SH 3. REV E. JOB COSDR UIEA2021040200812Structure · corrodedCORROSION - DAMAGED ON CENTER WING REAR SPAR WEB RH SIDE NEAR JETTISON PUMP AT RBL 94(<P>BLENDED OUT THE DAMAGED AREA IAW SRM 51-10-02 REV 91. ACCOMPLISHED DAMAGED AREA REPAIR IAW EI NO T2020A57M-802 REV G. JOB COMPLETED AND CONDITION CHK NORMAL.</P>)SDR UIEA2021021400308Interface Unit · faultedALT DISAGREE EICAS CAUTION, MAWEA SCID EIU-L FAIL (REMOVED AND REPLACED L EIU IAW AMM 31-61-01, EIU SOFTWARE VERIFIED CURRENT. INSPECTED PITOT PROBES IAW AMM 34-11-01, NO FINDINGS. NO ACTIVE MESSAGES. AUTO-LAND UNIQUE TEST PASSED PER AMM 22-10-00.)SDR UIEA2020123002633Smoke Warning · false activationLAV SMOKE SIREN STARTED AT 7000 FEET. RESET AND PERFORMED OPERATIONAL CHECK, IAW AMM 26-13-00. OPERATIONS NORMAL.SDR UIEA2020090101894Fire Warning · false activationAPU FIRE IN CRUISE AT FL 400(<P>INSP APU COMPARTMENT NO EVIDENCE OF FIRE, FOUND DEFECTIVE HARNESS, PERFORMED APU FIRE INSP PER AMM 49-11-00-208-029. DEACTIVATED APU & FIRE DETECTION SYSTEM / EXTINGUISHING SYSTEM PER DDG & EO4426A077.</P>)SDR UIEA2020040100611Fire Bottle · leakingUPPER DECK WATER FIRE EXTINGUISHER LEAKING.(<P>REMOVED AND REPLACED UPPER DECK WATER FIRE EXTINGUISHER PER AMM 26-26-02</P>)SDR UIEA2020012219093Cdu · failedRH CDU FAILED. SWAPPED RH CDU WITH CTR POSITION IAW AMM 34-61-02. RT CDU OPS NORMAL. DEFERRED CTR CDU PER MEL 34-61-02-01, MDDR 123620, CAT 'C'LP 1220047: TESTED CENTER CDU IAW AMM 34-61-02. OPS CHECK OK. THIS CLEARS MDDR 123620.SDR UIEA2019121656078Motor · failedLEFT BODY GEAR FAILED TO EXTEND USING ALTN EXT. (<P>REMOVED AND REPLACED BODY GEAR ALTN EXTENSION MOTOR IAW AMM 32-35-01, OPS CHECK OK. </P>)SDR UIEA2019051404200O-Ring · damagedATB DURING CLIMB, ENGINE OIL QUANTITY DROPPED TO .3. ALL OTHER PARAMETERS NORMAL AND NO OTHER EICAS MSG ASSOCIATED WITH IT. WE REDUCED THRUST TO IDLE ON AFFECTED ENG NR 4. CONTACTED MX CONTROL WHO INSTRUCTED US NOT TO SHUTDOWN. OVERWEIGHT LANDING RATHER THAN FSDR UIEA2019032903708Cable · bentFOUND NLG STEERING CONTROL CABLE TERMINAL BENDING (NW52A1, NW52A-2, NW52B-1, NW52B-2)(<P>1. IAW AMM 20-11-12-020-801 REV.94 AND AMM 20-11-12-420-801 REV.94 REPLACED NLG STEERING CONTROL CABLE</P><P>2. CONDITION CHECK NORMAL.</P>)SDR UIEA2019032903707Structure · corrodedCORROSION - FWD CARGO FOUND WALL CURTAIN STRUCTURE AT STA 980 RBL 96 LBL 96(<P>REMOVE DAMAGE PART IAW SM 51-40-02 REV.85</P><P>2. INSTALL NEW PART IAW SRM 51-00-02 REV.85 AND DWG NO. 453M1563 SH11 REV.B 453U1183 SH3 REV.B</P><P>3. JOB COMPLETED AND CONDITION SDR UIEA2019032903689Skin · crackedCRACK ON FUSELAGE SKIN AT STA 1720, S-45L(<P>1. REPAIR DAMAGE AREA IAW EI NO T2019A53M-1058 REV.1 2. JOB COMPLETED AND CONDITION CHECK NORMAL.</P>)SDR UIEA2019032903690Strap · crackedREPAIR - CRACK DAMAGE ON FRAME STRAP AT STA 2231, S-16L.(<P>1. REPAIR THE DAMAGED ARE IAW EI NO T2019A53M-1155 REV. 1 AND DWG 65B04235 SH3 REV.J 2. JOB COMPLETED AND CONDITION CHECK NORMAL.</P>)SDR UIEA2019032903691Stringer · corrodedCORROSION - STRINGER FWD CARGO COMPARTMENT BELOW STRUCTURE STA 680 - STA 745 S-47R(<P>1. REPAIR DAMAGED AREA IAW SRM 53-00-03-2R-3 FIG 201 REV.85 2. JOB COMPLETED AND CONDITION CHECK NORMAL.</P>)SDR UIEA2019032903692Seat Track · corrodedCORROSION - FOUND M/D CARGO SEAT TRACK HAD CORROSION AT STA 1960 LBL 11(<P>1. REPAIR DAMAGED AREA IAW SRM 53-00-52-2R-12 FIG 201 REV.85 2. DETAIL DATA REFER TO JOB CARD ATTACHING SHSET NR 0224102, 0224103, 0224104. 3. JOB COMPLETED AND CONDITION CHECK NORMALSDR UIEA2019032903693Seat Track · corrodedCORROSION - FOUND M/D CARGO SEAT TRACK HAD CORROSION AT STA 1480 - STA 1520 LBL 11(<P>1. REPAIR DAMAGE AREA IAW SRM 53-00-52-2R-12 FIG 201 REV.85 2. DETAIL REFER TO JOB CARD ATTACHING SHEET NR 0199690, 0199688, 3. JOB COMPLETED AND CONDITION CHECK NORMAL.</SDR UIEA2019032903694Seat Track · corrodedCORROSION - FOUND MD CARGO SEAT TRACK HAD CORROSION AT STA 1900 - 1920 RBL 11(<P>1. REPAIR DAMAGED AREA IAW SRM 53-00-52-2R-12 FIG 201 REV.85 2. DETAIL DATA REFER TO JOB CARD ATTACHING SHEET NO. 0224108, 0224109, 0224110 3. JOB COMPLETED AND CONDITION CHECK SDR UIEA2019032903695Shear Web · corrodedREPAIR - SEVERE CORROSION ON THE SHEAR WEBS OF MAIN DECK CARGO CENTER GUIDE RESTRAINT(<P>1. REMOVE DAMAGED PARTS IAW SRM 51-40-02 REV.85 2. ACCOMPLISHED DAMAGE WEB REPAIR IAW EI NR T2019A53M-1132 REV.1 3. INSTALL WEB IAW DWG NO 65B38403 SH1 REV.B AND SRM 51SDR UIEA2019032903696Skin · corrodedCORROSION - 33EA CORROSION LOCATION FOUND DURING PERFROM SB 747-53A2878(<P>1. ACCOMPLISHED FUSELAGE SKIN REPAIR IAW EI. NR T2019A53M-1156 REV.3 2. JOB COMPLETED AND CONDITION CHECK NORMAL.</P>)SDR UIEA2019032903697Spar Web · crackedREPAIR - CRACK FASTENER HOLE WAS FOUND ON LT WING INBD FRONT SPAR WEB PER SB 747-57A2357(<P>1. REPAIR CRACK AREA IAW EI NO. T2019A57M-1242 REV.1 </P><P>2. JOB COMPLETED AND CONDITION CHECK NORMAL.</P>)SDR UIEA2019032903698Spar Web · crackedREPAIR - CRACK FASTENER HOLE WAS FOUND ON RT WING INBD FRONT SPAR WEB PER SB 747-57A2357(<P>1. REPAIR FRONT SPAR WEB IAW EI NO. T2019A57M-1278 REV.1 2. JOB COMPLETED AND CONDITION CHECK NORMAL.</P>)SDR UIEA2019032903699Skin · gougedGOUGE ON RT WING LWR SKIN LWR SURFACE AT WBL 743.828 BETWEEN S-5 AND S-10(<P>1. REPAIR DAMAGE AREA IAW EI NO. T2019A57M-1310 REV.1</P><P>2. JOB COMPLETED AND CONDITION CHECK NORMAL</P>)SDR UIEA2019032903700Web · corrodedREPAIR - CORROSION DAMAGES ON THE REAR SPAR WEB AT STA 1241 LBL 91(<P>1. REPAIR DAMAGE AREA IAW EI NO. T2019A57M-1307 REV.1</P><P>2. JOB COMPLETED AND CONDITION CHECK NORMAL.</P>)SDR UIEA2019032903701Skin · dentedREPAIR - BULGE AND DENT ON SKIN OF NOSE CARGO DOOR NEAR STA 140 AT S-42R(<P>1. REPAIR BULGE AND DENT ARE IAW EI NO. T2019A52M-1196 REV.3</P><P>2. JOB COMPLETED AND CONDITION CHECK NORMAL (YELLOW DOR NO. 30410)</P>)SDR UIEA2019032903703Seat Track · corrodedCORROSION DAMAGE ON STA 1770 LBL 11.33 MAIN DECK FLOOR SEAT TRACK(<P>1. REPAIR DAMAGE AREA IAW EI NO. T2019A53M-1247 REV.1</P><P>2. DETAIL DATA REFER TO JOB CARD ATTACHING NO. 0224106, 0224105.</P><P>3. JOB COMPLETED AND CONDITION CHECK NORMAL.</P>)SDR UIEA2017083001578Line · leakingNR 3 HYDRAULIC QUANTITY MESSAGE, NR 3 HYDRAULIC SYSTEM PRESSURE INDICATION. FOUND A CRACKED LINE NEAR THE QUANTITY TRANSMITTER, INSTALLED FLEX LINE. LEAK CHECKED IAW AMM 20-11-18</P>)SDR UIEA2017030200253Blade · damagedWINDSHEILD WIPER ON FO & CAP SIDES BENT OUTWARD IN FLIGHT. DUMPED FUEL AND PERFORMED AN AIR RETURN IAW AMM 30-42-01 CAPTAIN`S AND FIRST OFFICER`S WIPER BLADES REPLACED IAW AMM 30-42-01.SDR UIEA2017030300275Doubler · corrodedBS 994 STRINGERS 45 - 46R, EXTERNAL DOUBLER FOUND CORRODED. REPLACED THE DOUBLER IAW SRM 51-10-02, AND SRM 51-40-02.SDR UIEA2017030300279Frame · damagedNR 1 ENG CORE COWL NR 2 FRAME FOUND DAMAGED. THE FRAME WAS REPAIRED IAW EO 197A116PART 1.SDR UIEA2017030300277Stiffener · crackedAPU BULKHEAD AT BS 2658 FWD FACE NR 2 STIFFENER FROM BOTTOM, FOUND BOTH SIDE ENDS CRACKED. THE STIFFENER WAS REPAIRED IAW RI-53-83-11741.SDR UIEA2017030300276Frame · corrodedRIGHT BODY FAIRING FRAME AT BS 1540, RBL 45.5 FOUND CORRODED. THE FAIRING FRAME WAS REPAIRED IAW RI-53-67-11739, REV A.SDR UIEA2017030300274Skin · crackedBS 983, STRINGER 38R AT DRAG SPLICE FT AREA FOUND CRACK IN SKIN LAYER. THE SKIN WAS REPAIRED IAW SRM 53-20-R2, REPAIR 2, FIG 201.SDR UIEA2017030300273Skin · crackedBS 983, STRINGER 38L AT DRAG SPLICE FITTING AREA FOUND CRACKED AT SKIN LAYER. THE SKIN WAS REPAIRED IAW SRM 53-20-2R2, REPAIR 2, FIG 201.SDR UIEA2017030300272Skin · crackedLEFT NLG AFT WW CORNER AT BS 400 FOUND CRACKED. THE SKIN WAS REPAIRED IAW EO 4453A516 PART 3 AND RI-53-10-11743.
Back to N492MC