N302AW, cancelled Apr 26, 2012
Service difficulty reports · 273
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 = 'N302AW' AND deregistration_id = 'N302AW-2012-04-26' 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 = 'N302AW' AND deregistration_id = 'N302AW-2012-04-26' 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 USAA2011090600017Control Panel · faultyMAINTENANCE REPORTED THE FIRST OFFICER'S 02 MASK EMERGENCY LIGHT INOPERATIVE. MAINTENANCE REPLACED THE ELECTRICAL LIGHTING PANEL. OPERATIONAL CHECK GOOD.SDR USAA2011081800006Skin · crackedLAP SEAM INSP - FUSELAGE SKIN CRACK AT S24R BETWEEN BS 867 & BS 887. REPAIRED FUSELAGE BETWEEN BS 867 & BS 887, S24R IAW B737 SRM 53-00-01 REPAIR 31.SDR USAA2011050991798Skin · crackedPHX - DAILY - CRACK IN FUSELAGE SKIN AT BS 520, S16R. REPAIRED FUSELAGE SKIN AT BS520, S16R IAW B737 SRM 53-00-01 REPAIR 30.SDR USAA20110429SB069Light · inoperativeDFW - MAINTENANCE REPORTED THE AFT RIGHT LAVATORY EMERGENCY LIGHT WAS INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE AFT RIGHT LAVATORY EMERGENCY LIGHT. OPERATIONAL CHECK GOOD.SDR USAA20110428SB068Connector · disconnectedDFW - MAINTENANCE REPORTED THE EMERGENCY LIGHT AT SEAT 2C WAS INOPERATIVE. MAINTENANCE FOUND THE CONNECTOR UNPLUGGED. RECONNECTED CONNECTOR AS REQUIRED AND TIE WRAPPED CABLE AS REQUIRED AT SEAT 2C. OPS CHECKED GOOD.SDR USAA20110412SB052Wire · brokenPHX - MAINTENANCE REPORTED THE WIRE PULLED OUT OF THE EMERGENCY LIGHT AT SEAT 18. MAINTENANCE FIXED BROKEN EMERGENCY LIGHT WIRE IN ASSOCIATION WITH BOEING SWPM. OPS CHECKS GOOD.SDR USAA20101227SB205Unknown · odorPHX - ON CLIMBOUT FROM DFW, FLIGHT ATTENDANT REPORTED A STRONG ODOR. SOURCE UNKNOWN. REPORTEDLY SMELLED LIKE SOMETHING ELECTRICAL FROM SEAT 4F TO OVERWING. NO VISIBLE SMOKE NOTED. FLIGHT CONTINUED AND LANDED AT PHX WITHOUT FURTHER INCIDENT. MAINTENANCE POSDR USAA2010122293211Battery · dischargedMCN - C20 - EEL - FORWARD OUTBOARD FLIGHT ATTENDANT SEAT FLASHLIGHT BATTERY IS INOP. REPLACED FORWARD OUTBOARD FLIGHT ATTENDANT SEAT FLASHLIGHT BATTERY. OPS CHECK GOOD.SDR USAA2010121793148Skin · crackedMCN - MAJOR REPAIR - C20 CHECK - L1 DOOR INNER SKIN CRACKED AFT END 5TH STOP FROM TOP. REPAIRED L1 DOOR INNER SKIN IAW EA 130465.SDR USAA2010121793173Fuse Pin · corrodedMCN - MAJOR REPAIR - C20 CHECK - CORROSION ON NR 1 PYLON FUSE PIN AT NAC STATION 257.25. REPLACED NR 1 PYLON FUSE PIN AT NAC STATION 257.25.SDR USAA2010121793172Fuse Pin · corrodedMCN - MAJOR REPAIR - C20 CHECK - CORROSION ON NR 2 PYLON FUSE PIN AT NAC STATION 257.25. REPLACED NR 2 PYLON FUSE PIN AT NAC STATION 257.25.SDR USAA2010122293215Hinge Pin · corrodedMCN - C20 - MAJOR REPAIR - CORROSION ON RIGHT HORIZONTAL STABILIZER OUTER HINGE PIN AT STAB STA 67.31. REPLACED RIGHT HORIZONTAL STABILIZER OUTER HINGE PIN AT STAB STA 67.31 IAW TASKCARD I6C55040.SDR USAA2010122293214Hinge Pin · corrodedMCN - C20 - MAJOR REPAIR - CORROSION ON RIGHT HORIZONTAL STABILIZER INNER HINGE PIN AT STAB STA 67.31. REPLACED RIGHT HORIZONTAL STABILIZER INNER HINGE PIN AT STAB STA 67.31 IAW JOB CARD I6C55040.SDR USAA2010121793174Hinge Pin · corrodedMCN - MAJOR REPAIR - C20 CHECK - CORROSION ON THE INNER AND OUTER HINGE PINS ON THE LEFT HORIZONTAL STABILIZER. REPLACED THE INNER AND OUTER HINGE PINS ON THE LEFT HORIZONTAL STABILIZER.SDR USAA2010122293217Structure · corrodedMCN - C20 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON LOWER CHORD AT BS 227.8 BETWEEN LBL 6 TO RBL 8. REPAIRED LOWER CHORD AT BS 227.8 BETWEEN LBL 6 TO RBL 8 IAW EA 130471.SDR USAA2010122293216Stiffener · corrodedMCN - C20 - MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON VERTICAL STIFFENER AT BS 227.8, BL 0. REPLACED VERTICAL STIFFENER AT BS 227.8, BL 0 IAW B737 SRM 51-40-02.SDR USAA2010121793151Stiffener · corrodedMCN - MAJOR REPAIR - C20 CHECK - LEVEL 2 EXFOLIATION CORROSION ON STIFFENER AT BS 219.8 - BS 227.8, BL 0. REPLACED STIFFENER AT BS 219.8 - BS 227.8, BL 0 IAW B737 SRM 51-40-02.SDR USAA2010121793149Bolt · corrodedMCN - MAJOR REPAIR - C20 CHECK - LEVEL 2 CORROSION ON THE RIGHT HORIZONTAL STABILIZER FWD LOWER BOLT. REPLACED THE RIGHT HORIZONTAL STABILIZER FWD LOWER BOLT IAW TASK CARD I6C55038.SDR USAA2010120192724Bulkhead · crackedMCN - MAJOR REPAIR - C20 CHECK - BULKHEAD 178 AFT SIDE RT VERTICAL BEAM RBL 17.1 LOWER INSULATION HOLDER PIN HOLE IS CRACKED. REPAIRED BULKHEAD 178 AFT SIDE RT VERTICAL BEAM RBL 17.1 LOWER INSULATION HOLDER IAW B737 SRM 51-70-13 FIG 1.SDR USAA2010120992957Bulkhead · crackedMCN - C20 - MAJOR REPAIR - CRACK IN BS 178 BULKHEAD INBOARD WEB AT LBL 10. REPAIRED BS 178 BULKHEAD INBOARD WEB AT LBL10 IAW B737 SRM 53-10-08.SDR USAA2010122293218Doubler · crackedMCN - C20 - MAJOR REPAIR - CRACK IN FRAME DOUBLER AT FORWARD LOWER DOOR STOP FITTING BS 303.9 BETWEEN S15L TO S17L. REPLACED FRAME DOUBLER AT FORWARD LOWER DOOR STOP FITTING BS 303.9 BETWEEN S15L TO S17L IAW EO 5311-01025.SDR USAA2010122293213Door Frame · crackedMCN - C20 - MAJOR REPAIR - CRACK IN FRAME WEB AT FORWARD LOWER DOOR STOP FITTING BS 303.9 BETWEEN S15L TO S17L. REPLACED FRAME WEB AT FORWARD LOWER DOOR STOP FITTING BS 303.9 BETWEEN S15L TO S17L IAW EO 5311-01025.SDR USAA2010122293212Skin · crackedMCN - C20 - MAJOR REPAIR - CRACK IN FUSELAGE SKIN IN UPPER FASTENER ROW AT BS 518, S10L. REPAIRED FUSELAGE SKIN IN UPPER FASTENER ROW AT BS 518, S10L IAW EA 130470.SDR USAA2010120992956Frame · crackedMCN - C20 - MAJOR REPAIR - CRACK IN FRAME RE-INFORCEMENT FITTING AT R1 DOOR AFT LOWER CORNER AT BS 328 BETWEEN S16R TO S17R. REPLACED FRAME RE-INFORCEMENT FITTING AT R1 DOOR AFT LOWER CORNER AT BS 328 BETWEEN S16R TO S17R IAW B737 SRM 51-40-02 & BOEING DRAWINSDR USAA2010121793150Skin Panel · crackedMCN - MAJOR REPAIR - C20 CHECK - NR 2 PYLON SKIN PANEL CRACKED AT NAC STATION 224. REPAIRED NR 2 PYLON SKIN PANEL AT NAC STATION 224 IAW ER 03-5433-01037-DL1.SDR USAA2010120992959Floorbeam · corrodedMCN - C20 - MAJOR REPAIR - LEVEL 2 FILIFORM CORROSION ON FLOORBEAM AT BS 312 BETWEEN LBL 17 TO LBL 24. REPLACED FLOORBEAM AT BS 312 BETWEEN LBL 17 TO LBL 24 IAW B737 SRM 53-10-51.SDR USAA2010120992958Channel · crackedMCN - C20 - MAJOR REPAIR - CRACK IN CHANNEL AT BS 500C + 15 INCHES, S16L. REPAIRED CHANNEL AT BS 500C + 15 INCHES, S16L IAW ER 03-5312-01094-DD1.SDR USAA2010120992955Frame · crackedMCN - C20 - MAJOR REPAIR - CRACK IN FUSELAGE FRAME AT BS 360 BETWEEN S13R TO S14R. REPAIRED FUSELAGE FRAME AT BS 360 BETWEEN S13R TO S14R IAW TYPICAL REPAIR 53-10-21.SDR USAA2010122393221Gusset · crackedMCN - MAJOR REPAIR - C20 CHECK - CRACKED GUSSET WHERE THE NLG UPPER ACTUATOR ATTACHES. REPLACED GUSSET WHERE THE NLG UPPER ACTUATOR ATTACHES IAW B737 SRM 51-40-02.SDR USAA2010120992960Floorbeam · corrodedMCN - C20 - MAJOR REPAIR - LEVEL 2 FILIFORM CORROSION UPPER SIDE OF FLOORBEAM CHORD AT BS 294.5 BETWEEN LBL 22 TO RBL 60. REPAIRED FLOORBEAM CHORD AT BS294.5 BETWEEN LBL 22 TO RBL 60 IAW B737 SRM 53-10-51.SDR USAA2010120192743Skin · crackedMCN - MAJOR REPAIR - C20 CHECK - E&E DOOR SKIN CRACKED, BS 328. REPAIRED E&E DOOR SKIN AT BS 328 IAW B737 SRM 52-00-01 FIG 201.SDR USAA20101014SB159Uplock Actuator · faultyPHX - ON CLIMB OUT FROM PHX, CREW REPORTED A RIGHT MAIN LANDING GEAR RED LIGHT AFTER GEAR RETRACTION. CREW FOLLOWED QRH PROCEDURES AND AFTER RECYCLING THE GEAR TO THE UP POSITION, RECEIVED NORMAL GEAR INDICATION. FLIGHT RETURNED TO FIELD AT PHX AND LANDED WISDR USAA2010071291398Skin · crackedPHX - WALKAROUND - MAJOR REPAIR - CRACK IN FUSELAGE SKIN AT BS 767, S24L. REPAIRED FUSELAGE SKIN AT BS 767, S24L IAW B737 SRM 53-00-01 REPAIR 31.SDR USAA2010071291397Skin · crackedPHX - WALKAROUND - MAJOR REPAIR - CRACK IN FUSELAGE SKIN AT BS 727E, S23R. REPAIRED FUSELAGE SKIN AT BS 727E, S23R IAW B737 SRM 53-00-01 REPAIR 31.SDR USAA2010041390782Tab · debondedPHX - OVERNIGHT - MAJOR REPAIR - AREA OF DISBOND ON LEFT ELEVATOR TAB UPPER SURFACE AT OUTBOARD EDGE. REPLACED LEFT ELEVATOR TAB IAW JOB CARD R6C27007.SDR USAA2010020590293Bushing · wornPHX - MAJOR REPAIR - WEEKLY CHECK - RT MLG UPPER DRAG STRUT UPPER ATTACH FITTING AFT HAT BUSHING INNER RACE IS DAMAGED / MATERIAL LOSE FROM SPINNING HAT BUSHING. REF NR 4591155. REPLACED THE AFT HAT BUSHING ON THE RT MLG UPPER DRAG STRUT UPPER ATTACH FITTINGSDR USAA2010020890300Strut · crackedPHX - MAJOR REPAIR - WEEKLY - RIGHT MAIN LANDING GEAR UPPER STRUT FAILED ULTRASONIC INSPECTION, NUMEROUS CRACK INDICATIONS WERE NOTED. REPLACED RIGHT MAIN LANDING GEAR ASSEMBLY.SDR USAA2010020590294Bushing · wornPHX - MAJOR REPAIR - WEEKLY CHECK - RT MLG UPPER DRAG STRUT UPPER ATTACH FITTING FWD HAT BUSHING INNER RACE IS DAMAGED / MATERIAL LOSE FROM SPINNING HAT BUSHING. REF NR 4591155. REPLACED THE FWD HAT BUSHING ON THE RT MLG UPPER DRAG STRUT UPPER ATTACH FITTINGSDR USAA2010011990128Skin · debondedDISBOND ON INBOARD END OF RIGHT INBOARD AFT FLAP. REPLACED RIGHT INBOARD AFT FLAP IAW JOB CARD NR R3M27007.SDR USAA20090713SB116Bracket · misinstalledPHX - FLIGHT ATTENDANT REPORTED THE L2 AND R2 DOOR SLIDE RETENTION BRACKETS ARE MOUNTED BACKWARDS. MAINTENANCE REMOVED SLIDE BRACKETS AND RE-INSTALLED CORRECTLY.SDR USAA2009070891732Connector · looseBFM - C19 - EEL - WITH EMERGENCY EXIT LIGHTS SWITCH ON THE P5 PANEL TO THE ON POSITION, NOT ARMED LIGHT ON P5 MASTER CAUTION L16AT & OVERHEAD MASTER CAUTION LIGHT ON THE LIGHT SHIELD PANEL FAILED TO COME ON. PERFORMED TROUBLESHOOTING FOUND D419 OP, PLUG CONNESDR USAA2009070891731Connector · looseBFM - C19 - EEL - WITH EMERGENCY EXIT LIGHTS SWITCH ON THE P5 PANEL TO THE ARM POSITION, ALL EMERGENCY LIGHTS ALWAYS "ON". PERFORMED TROUBLESHOOTING BY CHECKING 28DV VOLTAGE AT EMERGENCY EXIT LIGHT SWITCH IAW WDM 33-51-1, NO VOLTAGE FOUND D419 OP, PLUG CONNECSDR USAA2009070891730Light · inoperativeBFM - C19 - EEL - AFT CABIN LOWER EMERGENCY EXIT SIGN IN BETWEEN THE TWO LAVS INOP. RESEATED AFT CABIN LOWER EMERGENCY EXIT SIGN CONNECTOR, OPS CHECK GOOD IAW B737 AMM 33-51-81-2.SDR USAA2009070891728Battery Pack · dischargedBFM - C19 - EEL - AFT RIGHT EMERGENCY LIGHT BATTERY INOP. REPLACED BATTERY PACK, OPS CHECK GOOD.SDR USAA2009070891729Power Supply · dischargedBFM - C19 - EEL - LEFT AFT CEILING BATTERY PACK ASSEMBLY INOP. REPLACED EMERGENCY LIGHT POWER SUPPLY, OPS CHECKED GOOD IAW B737 AMM 33-51-51.SDR USAA2009070291662Bulkhead · crackedBFM - C19 - MAJOR REPAIR - CRACK ON AFT PRESSURE BULKHEAD WEB AT BS 1016, S6R. REPAIRED AFT PRESSURE BULKHEAD WEB AT BS 1016, S6R IAW SRM 53-80-08.SDR USAA2009070291661Web · corrodedBFM - C19 - MAJOR REPAIR - LEVEL 2 CORROSION ON AFT GALLEY FLOOR WEB BETWEEN BS 986.5 TO BS 1006, RBL 42. REPAIRED AFT GALLEY FLOOR WEB BETWEEN BS 986.5 TO BS 1006, RBL 42 IAW SRM 53-60-51.SDR USAA2009062591593Floorbeam · corrodedBFM - C19 - MAJOR REPAIR - LEVEL 2 CORROSION ON FLOORBEAM UPPER CHORD AT BS 967, RBL 18. REPAIRED FLOORBEAM UPPER CHORD AT BS 967, RBL 18 IAW B737 SRM 53-60-51.SDR USAA2009062591592Web · corrodedBFM - C19 - MAJOR REPAIR - LEVEL 2 CORROSION ON FLOOR WEB BETWEEN BS 986.5 TO 1006, LBL 42. REPLACED FLOOR WEB BETWEEN BS 986.5 TO 1006, LBL 42 IAW B737 SRM 53-60-51.SDR USAA2009062491584Floorbeam · corrodedBFM - C19 - MAJOR REPAIR - LEVEL 2 CORROSION ON FLOORBEAM AT BS 986.5, WL 208.1, RBL 18. REPAIRED FLOORBEAM AT BS 986.5, WL 208.1, RBL 18 IAW B737 SRM 53-60-51 & 53-00-51.
Back to N302AW, cancelled Apr 26, 2012