Boeing 737-4Q8
Service difficulty reports · 6,250
Newest first. General aviation reporting is voluntary.
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 aircraft_model_key = '7374Q8' 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 aircraft_model_key = '7374Q8' 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 ASAA1149550Stringer Clip · crackedSTRINGER CLIP CRACKED AT STR 4R BS 727F. INSTALL REPLACEMENT CLIP IAW DWG A53100265816.SDR ASAA1149549Stringer Clip · crackedSTRINGER CLIP CRACKED AT STR 4R BS 727B. REMOVED AND REPLACED STRINGER CLIP IAW DWG A53100265816.SDR ASAA1149548Stringer Clip · crackedSTRINGER CLIP CRACKED AT STR 4R BS 727A. INSTALL REPLACEMENT CLIP IAW DWG A53100265816.SDR ASAA1149547Stringer Clip · crackedSTRINGER CLIP CRACKED AT STR 4L BS 727B. INSTALL REPLACEMENT CLIP IAW DWG A53100265816.SDR ASAA1149555Channel · crackedMAIN CABIN LEFT SIDE BS 360 STR 14 STRINGER SPLICE CHANNEL CRACKED. REMOVED AND REPLACED CHANNEL AND CLIP IAW TIMCO REO G13605 REV 1R AND ALASKA EA AD20091614 400 53 100.SDR ASAA1149552Stringer · gougedSTRINGER 16L AT BS 294 IS GOUGED. REPAIRED STRINGER IAW B737 400 SRM 51 70 11.SDR ASAA1149551Stringer Clip · crackedSTRINGER CLIP CRACKED AT STR 4L BS 727D. INSTALL REPLACEMENT CLIP IAW DWG A53100265816.SDR ASAA1149546Stringer Clip · crackedSTRINGER TIE CRACKED AT STR 4L BS 727C. INSTALL REPLACEMENT CLIP IAW DWG A53100265816.SDR ASAA1149545Stringer Clip · crackedSTRINGER CLIP AT STR 4R BS 727A CRACKED. REMOVED AND REPLACED STRINGER CLIP IAW B737 400 SRM 51 40 02.SDR ASAA1149450Intercostal · crackedMAIN CABIN INTERCOSTAL WEB CRACKED AT BS 294 STR 7L. REMOVED AND REPLACED INTERCOSTAL WEB P/N 65 17684 642 IAW TIMCO REO G13610 REV IR.SDR ASAA1149421Intercostal · crackedMAIN CABIN INTERCOSTAL WEB CRACKED AT BS 294 STR 11L. REMOVED AND REPLACED WEB IAW TIMCO REO G 13608 REV 1R AND ASA EA 400 53EA 05235.SDR ASAA1149420Intercostal · crackedINTERCOSTAL WEB CRACKED AT BS 294.5 STR 12L. REMOVED AND REPLACED WEB IAW TIMCO REO G 13609 REV 1R AND ASA EA 400 53EA 05237.SDR ASAA1149416Stringer Clip · crackedCRACKED STRINGER CLIP AT BS 294.5 STR 11L. REMOVED AND REPLACED STRINGER CLIP IAW TIMCO REO G 13607 REV 1R AND ASA EA 400 53EA 05236.SDR ASAA1149371Stringer Clip · corrodedAFT PIT STRINGER CLIP CORRODED AT BS 947.5 RBL 12 RBL 20. REMOVED AND REPLACED STRINGER CLIP IAW B737 400 SRM 51 40 02.SDR ASAA1149285Structure · damagedDEEP BLEND MARK AT BS 455 STR 21L. CUT OUT DAMAGED AREA FABRICATED REPAIR PARTS AND INSTALLED IAW PEMCO 737 400 SRM SUPPLEMENT 53 30 81 FIG 204.SDR ASAA1149157Flap · damagedRIGHT INBOARD AFT FLAP DAMAGED. TRAILING EDGE REMOVED DAMAGED FABRICATED REPAIR PARTS AND INSTALLED IAW B737 400 SRM 51 70 10 REPAIR 2.SDR ASAA1149284Beam · crackedVERTICAL STABILIZER TRAILING EDGE BEAM CRACKED LEFT SIDE. REMOVED AND REPLACED BEAM IAW B737 400 SRM 51 40 02 AND 51 40 05.SDR ASAA1149282Stringer Splice · damagedBS 908 BUTT SPLICE FROM 4R TO 10R STRINGER SPLICE HAS TOOLING MARKS ON INSIDE AND IN RADIUS. REMOVED AND REPLACED STRINGER SPLICE IAW B737 400 SRM 51 40 02.SDR ASAA1149283Skin · puncturedLEFT RUDDER SKIN PUNCTURED BONDED DAMAGED AREA IAW B737 400 SRM 51 70 17 REPAIR 1.SDR ASAA1149099Flap · damagedLT OUTBOARD FLAP OUTBOARD END DAMAGED. REPAIRED IAW B737 400 SRM 51 70 10.SDR ASAA1149189Splice · damagedSCRIBE AT BS 908 BUTT JOINT. REMOVED AND REPLACED BUTT SPLICE IAW B737 400 SRM 51 40 02.SDR ASAA1149188Splice · damagedSCRIBE AT BS 727G BUTT JOINT. REMOVED AND REPLACED BUTT SPLICE IAW B737 400 SRM 51 40 02.SDR ASAA1149159Buttstrap · damagedSCRIBE AT BS 727G SCRIBE LENGTH 1.25 INCH UPPER STR X 11L DISTANCE FROM SCRIBE UPPER END TO STR X 10 INCH LOWER STR Y 13L DISTANCE FROM SCRIBE END TO STR Y 6 INCH DEPTH .002. REMOVED AND REPLACED BUTT SPLICE STRAP IAW B737 400 SRM 51 40 02.SDR ASAA1149158Splice Plate · damagedSCRIBE AT BS 727G SCRIBE LENGTH 20 INCHES UPPER STR X1 DISTANCE FROM SCRIBE UPPER END TO STR X 6.250 IN. LOWER STR Y 4L DISTANCE FROM SCRIBE END TO STR Y 3.750 IN. DEPTH .003. REMOVED AND REPLACED BUTT SPLICE PLATE IAW B737 400 SRM 51 40 02.SDR ASAA1149098Splice · scratchedSCRIBE AT BS 908 SCRIBE LENGTH 3.5 INCH UPPER STR X 3R DISTANCE FROM SCRIBE UPPER END TO STR X 5.5 IN. LOWER STR Y 4R DISTANCE FROM SCRIBE END TO STR Y 2.250 IN. SCRIBE DEPTH 0.002 IN REMOVED AND REPLACED BUTT SPLICE AT BS 908 STR 4L TO STR 4R IAW B737 400 SRMSDR ASAA1149013Bulkhead · corrodedCORROSION ON BS 1016 BULKHEAD LOWER FORWARD CHORD FORWARD RADIUS AT RBL 2 AND WL 189. FABRICATED AND INSTALLED NEW SPLICE ANGLE IAW B737 400 SRM 53 80 08 FIG 101 51 40 05 51 20 01 AND 51 40 02.SDR ASAA1149012Stiffener · corrodedCORROSION ON BS 1016 BULKHEAD BL 0 RIGHT CHANNEL STIFFENER ON VERTICAL LEG OUTBOARD FACE AT WL 191. REPAIRED STIFFENER IAW ASA EA 400 53EA 04756 REV A.SDR ASAA1149011Bulkhead · corrodedCORROSION ON BS 1016 BULKHEAD WEB BL 0 ON BOTH SIDES OF CHANNEL STIFFENER FORWARD FACE WL 191. REMOVED CORRODED GORE WEB AND INSTALLED REPLACEMENT SECTION IAW ASA EA 400 53EA 04756 REV A.SDR ASAA1149008Snubber · bindingL2 (AFT ENTRY) DOOR HARD TO CLOSE (BINDS ABOUT 3/4 CLOSED). REMOVED AND REPLACED AFT ENTRY DOOR SNUBBER PER B737 400 AMM 52 13 71.SDR ASAA1149005Skin · dentedLEFT WING OUTBOARD TRAILING EDGE FLAP UPPER SURFACE HAS DENT 11.25 INCH FROM INBOARD EDGE AND 4.75 INCH FROM TRAILING EDGE. DEPTH = 0.055 INCH MAJOR AXIS = 2.07 INCH MINOR AXIS = 1.23 INCH. REPAIRED TRAILING EDGE FLAP UPPER SURFACE IAW B737 400 SRM 51 70 10.SDR ASAA1148980Support · chafedLEFT PYLON OUTBOARD FAN COWL SUPPORT CHORD IS CHAFED NAC STA 129.074 TO 196.70. REPAIRED LEFT PYLON O/B CHORD IAW EA 400 54EA 04609.SDR ASAA1149006Skin · corrodedEXTERNAL SKIN CORRODED AT BS 727G+8 AT STR 23R. REMOVED DAMAGE FABRICATED REPAIR PARTS AND INSTALLED IAW ASA EA 400 53EA 04772.SDR ASAA1148870Stringer Clip · crackedFRAME STRINGER TIE CLIP CRACKED BS 500C STR 11R. REMOVED AND REPLACED STRINGER TIE CLIP IAW B737 400 SRM 51 40 02 51 40 05 51 10 02 AND BOEING DRAWING 65 46536.SDR ASAA1148869Door · out of adjustFA'S REPORT L 2 DOOR MORE DIFFICULT TO OPEN THAN NORMAL. ADJUSTED L 2 DOOR PER B737 400 MM 52 13 31.SDR ASAA1148878Frame · damagedBS 312 FRAME SPLICE MISSING MATERIAL AT ONE OF FOUR END FASTENERS. REPAIRED FRAMES IAW ASA EA 400 53EA 04649 REV NEW DATED 26 JAN 2011.SDR ASAA1148838Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 616 AT STR 5R. REMOVED AND REPLACED STRINGER CLIP IAW ASA DRAWING A53100265832.SDR BJNA110101Lamp · burned out1 RED AND 1 WHITE EMERGENCY FLOOR LIGHTS INOPERATIVE. REPLACED 2 EA LAMPS ON EMERGENCY FLOOR LIGHTS IAW AMM 33-51-81. OPS CK NORMAL.SDR ASAA1148889Fairing · crackedNR 2 PYLON INBOARD FAIRING ASSEMBLY IS CRACKED NAC STA 266. REMOVED AND REPLACED INBOARD FAIRING ASSEMBLY IAW BOEING DRAWING 313A1200 AND B737 400 SRM 51 40 05 51 40 02.SDR ASAA1148821Structure · delaminatedRIGHT WING INBOARD FORE FLAP EXISTING REPAIR DELAMINATED. REPAIRED DAMAGED AREA IAW B737 400 SRM 51-70-10 REPAIR 4.SDR ASAA1148820Skin · dentedLEFT INBOARD FORE FLAP LOWER SURFACE HAS MULTIPLE DENTS. REPAIRED DAMAGED AREA IAW B737 400 SRM 51 70 10 REPAIR 2.SDR ASAA1148888Support Bracket · crackedLEFT WING INBOARD UPPER NO STEP PANEL INBOARD SUPPORT BRACKET CRACKED. REMOVED AND REPLACED BRACKET IAW B737 400 SRM 51 40 02.SDR ASAA1148841Frame · crackedBS 827 FRAME CRACKED AT INBOARD FASTENER FOR A/C RAIL ATTACH BRACKET. REPAIRED FRAME IAW ATS ER 11 01120SDR ASAA1148851Frame · crackedFRAME CRACKED AT BS 787 STR 8R TO 9R. REPAIRED FRAME IAW ATS ER 11 01120.SDR ASAA1148842Frame · crackedBS 747 FRAME CRACKED AT INBOARD FASTENER FOR A/C RAIL ATTACH BRACKET. REPAIRED FRAME IAW ATS ER 11 01120.SDR ASAA1148850Frame · crackedFRAME CRACKED AT BS 747 STR 8-9L AT BIN RAIL. REPAIRED FRAME IAW AD20062609-400-53-111.SDR ASAA1148849Stringer Splice · crackedBS 360 STR 16L STRINGER SPLICE CHANNEL IS CRACKED. REPAIRED CHANNELS IAW AD20091614-400-53-102 AND ER 11-01119.SDR ASAA1148848Frame · crackedFRAME CRACKED AT BS 907 STR 8L TO 9L AT BIN RAIL. REPAIRED FRAME IAW AD20062609-400-53-111.SDR ASAA1148847Frame · crackedBS 300 FRAME CRACKED AT A/C RAIL ATTACH BRACKET. REPAIRED FRAME IAW AD20062609-400-53-115 AND ER 11-01257.SDR ASAA1148846Frame · crackedFRAME CRACKED AT BS 867 STR 8-9L AT BIN RAIL. REPAIRED FRAME IAW AD20062609-400-53-111.SDR ASAA1148845Frame · crackedBS 727F FRAME CRACKED AT INBOARD FASTENER HOLE FOR A/C ATTACH BRACKET. REPAIRED FRAME IAW AD20062609-400-53-111.
Back to Boeing 737-4Q8