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 ASAA0843324Skin · corrodedEXFOLIATION CORROSION FOUND ON UPPER WING PLANK AT FS 661, RBL 57 REPAIRED IAW EA-5710 01153.SDR ASAA0843388Frame · crackedCRACK FOUND ON LT BS 616 FRAME INNER CHORD WL 201 TO WL 200 AREA DURING ACCOMPLISHMENT OF EO 5310 02528. REMOVED DAMAGED FRAME INNER CHORD, CUT OUT AREA, FABRICATED FILLER SHIM AND STIFFENING ANGLE AND INSTALLED IAW EO 5310 02528 SECTION 5.SDR ASAA0843292Floorbeam · crackedFLOORBEAM LOWER STABILIZER AT STA 312, BL42 IS CRACKED STOP DRILLED, CRACKED FABBED DOUBLER AND INSTALLED REPAIR IAW SRM 53 10 51.SDR ASAA0843288Floorbeam · crackedFLOORBEAM STABILIZER AT STA 312 + BL 45 R IS CRACKED BROKEN FABRICATED DOUBLER + INSTALLED REPAIR IAW SRM 51-70-13, PG 3.SDR ASAA0843381Floorbeam · corrodedCABIN FLOORBEAM UPPER CHORD CORRODED LBL 20 TO RBL 60 STA 294.5. REMOVED DAMAGED UPPER CHORD, FABRICATED REPAIR PARTS, LOCATED DRILLED AND INSTALLED SPLICE ANGLE AND UPPER BEAM CHORD IAW B737 400 SRM 53 10 51 FIG 201.SDR ASAA0843350Floorbeam · corrodedCABIN FLOORBEAM STA 312 SEVERAL AREAS OF CORROSION ON CAP RBL 32 TO LBL 27. REMOVED DAMAGED UPPER CHORD, FABRICATED UPPER CHORD AND REPAIR SPLICES, LOCATED DRILLED AND INSTALLED IAW B737 400 SRM 53 10 51 REPAIR 5 PAGE 203 FIG 201.SDR ASAA0843390Floorbeam · corrodedCABIN FLOORBEAM STA 328 CORRODED IN SEVERAL AREAS ON UPPER SURFACE. REMOVED DAMAGED UPPER CHORD, FABRICATED, LOCATED, DRILLED INSTALLED REPAIR PARTS AND UPPER CHORD IAW AAR EA 12802 AND ASA EA 5310 02813SDR ASAA0843378Floorbeam · corrodedFUSELAGE STA 947.5 CENTER OF FRAME HAS CORROSION ON UPPER CAP. REPAIRED FLOORBEAM IAW ASA EA 5310-02812, REMOVED AND REPLACED T-CAP WITH SPLICE ANGLES AND STRAPS.SDR ASAA0843377Floorbeam · corrodedFLOORBEAM UPPER CHORD CORRODED STA 344 CENTER AREA TO LBL 35. REMOVED DAMAGED CHORD, FABRICATED UPPER CHORD AND REPAIR PARTS, LOCATED DRILLED AND INSTALLED IAW ASA EA 5310 02811 AND AAR EA 12804.SDR ASAA0843385Threshold · corrodedR1 DOOR THRESHOLD WEB CORRODED BETWEEN STA 298 TO 328 AREA. REMOVED DAMAGED WEB, FABRICATED LOCATED DRILLED AND INSTALLED NEW WEB IAW B737 400 SRM 51 30 01 PG 7 AND 51 40 02 PAGES 2 AND 4.SDR ASAA0843384Sill · corrodedR1 DOOR THRESHOLD INNER CHORD (MOP SILL) CORRODED. REMOVED DAMAGED INNER CHORD. LOCATED, DRILLED AND INSTALLED A REPLACEMENT INNER CHORD IAW B737 400 SRM 51 40 02 PAGE 2 AND 4.SDR ASAA0843380Sill · corrodedL2 DOOR MOP SILL IS CORRODED FROM STA 948 TO 1006. REMOVED AND REPLACED MOP SILL IAW B7373 400 SRM 51 40 02 AND 51 40 05.SDR ASAA0843371Sill · corrodedCABIN R2 DOOR INNER CHORD (MOP SILL) CORRODED. REMOVED DAMAGED INNER CHORD, LOCATE, DRILLED AND INSTALLED A REPLACEMENT INNER CHORD IAW SRM 51 40 02 PAGES 2 AND 6.SDR ASAA0843269Intercostal · crackedINTERCOSTAL BETWEEN STA 380-400 AT BL "0" HAS UPPER ANGLE CRACKED AT THE FWD END. REMOVED DAMAGED ANGLE & REPLACE IAW SRM 51-40-02.SDR ASAA0843370Bear Strap · corrodedFWD CARGO PIT BILGE AREA BEAR STRAP EXFOILATED STA 490 RBL 10.5 TO RBL 13. REMOVED DAMAGED AREA, HFEC INSPECTED IAW NDTM PT6 FIG 23 AND FIG 16, NO DEFECTS NOTED. FABRICATED, LOCATED, DRILLED AND INSTALLED REPAIR PARTS AND EXT DOUBLER AND TRIPLER IAW ASA EA 5SDR ASAA0843267Skin · dentedRT IB FOREFLAP LOWER SURFACE HAS A DENT ON IB END REMOVED DAMAGE FABBED FILLER & DOUBLER, BONDED IAW SRM 51-70-10 REPAIRS.SDR ASAA0843287Fitting · gougedAT THE AFT SIDE OF THE APB STRINGER 4RT END FITTING IS GOUGED. REMOVED AND REPLACED STRINGER 4RT END FITTING ON THE AFT SIDE OF THE APB IAW SRM 51-40-02, P6.SDR ASAA0843285Fitting · gougedAT THE AFT SIDE OF THE APB STRINGER 5R END FITTING IS GOUGED. REMOVED AND REPLACED STRINGER 5R END FITTING ON THE AFT SIDE OF THE APB IAW SRM 51-40-02, FIG 8.SDR ASAA0843394Skin · chafedRT WING NR 4 2 E SLAT LOWER TRAILING EDGE WEDGE CHAFED. PREPARED DAMAGED AREA, FABRICATED FILLERS AND DOUBLERS AND BONDED IAW SRM 51-70-10 REPAIR 4.SDR ASAA0843376Wedge · dentedRIGHT I/B MID FLAP LOWER SURFACE OF TRAILING EDGE WEDGE DENTED JUST O/B OF NR 3 TRACK. PREPARED DAMAGED AREA, FABRICATED REPAIR DOUBLER AND BONDED IAW B737 400 SRM 51 70 10.SDR ASAA0843368Skin · dentedRT WING NR 8 SPOILER DENTED ON LOWER SURFACE CENTER AREA. PREPARED DAMAGED AREA, FABRICATE REPAIR DOUBLER AND BONDED IAW B737 400 SRM 51 70 10 PAGES 201 203 REPAIR 2.SDR ASAA0843367Skin · dentedRT WING NR 5 SPOILER UPPER SURFACE DENTED AT 8 INCHES FROM TRAILING EDGE AND 2.5 FROM O/B EDGE. PREPARED DAMAGED AREA, FABRICATED REPAIR DOUBLER AND BONDED IAW B747 400 SRM 51 70 10 PAGES 201 203 REPAIR 2.SDR ASAA0843366Skin · dentedLT WING TRAILING EDGE I/B FORE FLAP SEVERAL DENTS ON LOWER SURFACE CENTER I/B AREAS. REMOVED DAMAGED DOUBLERS AND SKINS, FABRICATED REPAIR PARTS AND BONDED IAW B737 400 SRM 51 70 10.SDR ASAA0843363Skin · dentedLEFT WING NR 3 SPOILER UPPER SURFACE HAS AREA OF SEVERAL DENTS. REMOVED DAMAGED AREA, FABRICATED AND INSTALLED DOUBLER IAW SRM 51-70-10.SDR ASAA0843354Skin · dentedLT WING O/B TRAILING EDGE AFT FLAP 3 EACH DENTS ON LOWER SURFACE. PREPARED DAMAGED AREAS, FABRICATED DOUBLERS AND BONDED IN ACCORDANCE WITH B737 400 SRM 51 70 10 REPAIR 2.SDR ASAA0843351Skin · dentedRT WING I/B TRAILING EDGE FOREFLAP HAS MULTIPLE DENTS ON LOWER SURFACE I/B AREA. PREPARED DAMAGED AREA, APPLIED ADHESIVE FILLER, FABRICATED REPAIR DOUBLER AND BONDED IAW B737 400 SRM 51 70 10 REPAIR 2.SDR ASAA0843357Skin · chafedLT WING NR 3 L/E SLAT I/B LWR SURFACE OF T/E WEDGE CHAFED. REMOVED DAMAGED AREA OF SKIN, FABRICATED REPAIR PARTS AND DOUBLER BONDED IAW B737 400 SRM 51 70 10 REPAIR 4.SDR ASAA0843359Skin · dentedEXTERNAL FUSELAGE STA 368 DENTED WITHIN 3 INCHES OF LAP SPLICE BETWEEN STR 18R AND 19R. CUT OUT DAMAGED AREA OF SKIN, HFEC AND MFEC INSPECTED AREA, NO DEFECTS NOTED, FABRICATED FILLERS AND DOUBLER, LOCATED, DRILLED & INSTALLED IAW B737 400 SRM 53 00 01 DETAILSDR ASAA0843353Skin · dentedFUSELAGE SKIN DENTED WITH CREASE STA 400 JUST BELOW STR 15R. REMOVED DAMAGED AREA, FABRICATED REPAIR DOUBLED, LOCATED, DRILLED AND INSTALLED IAW SRM 53-00-01 REPAIR 31.SDR ASAA0843303Skin · chafedFUSELAGE SKIN CHAFED FROM DORSAL FIN FWD SEAL BLENDED AREA FABRICATED AND INSTALLED REPAIR DOUBLER SPLICE STRAPS AND TAPERED FILLERS IAW SRM 53-60-01 REPAIR 10 PROCEDURE II.SDR ASAA0843312Skin · dentedOB L/E OF NR 6 SLAT IS DENTED REMOVED DAMAGED AREA FABRICATED REPAIR PARTS AND INSTALLED IAW SRM 57 43 01 FIG 201.SDR ASAA0843289Stringer Fitting · gougedAT THE AFT SIDE OF THE APB STRINGER 17A LT END FITTING IS GOUGED. REMOVED AND REPLACED STRINGER 17A LT END FITTING ON THE AFT SIDE OF THE APB IAW
SRM 51-40-02, P4.SDR ASAA0843286Fitting · gougedAT AFT SIDE OF THE APB STRINGER 18L END FITTING IS GOUGED. REMOVED AND REPLACED STRINGER 18L END FITTING ON THE AFT SIDE OF THE APB IAW SRM 51-40-02, P 4.SDR ASAA0843281Fitting · gougedAT THE AFT SIDE OF THE APB STRING 17L END FITTING IS GOUGED REMOVE AND REPLACE APB STRINGER 17L END FITTING ON THE AFT SIDE OF THE APB IAW SRM 51-40-02, FIG 8, PG 6.SDR ASAA0843279Fitting · gougedAT THE AFT SIDE OF THE APB STRINGER 20L END FITTING IS GOUGED. REMOVED AND REPLACED STRINGER 20L END FITTING ON THE AFT SIDE OF THE APB IAW SRM 51-40-02, FIG 8.SDR ASAA0843278Fitting · gougedAT THE AFT SIDE OF THE APB STRINGER 21L END FITTING IS GOUGED. REMOVED AND REPLACED STRINGER 21L END FITTING ON THE AFT SIDE OF THE APB IAW SRM 51-40-02, FIG 8.SDR ASAA0843277Fitting · gougedSTRINGER 16L END FITTING ON THE AFT SIDE OF THE APB HAS A GOUGE MARKS. REMOVED AND REPLACED STRINGER 16L END FITTING IAW SRM 51-40-02, PG 4.SDR ASAA0843276Fitting · gougedSTRINGER 14 L, END FITTING ON THE AFT SIDE OF THE APB HAS A GOUGE MARKS. REMOVED AND REPLACED STRINGER 14L END FITTING IAW SRM 51-40-02, PG 4.SDR ASAA0843290Fitting · gougedAT THE APB STRINGER 15L END FITTING HAS GOUGES. REMOVED & REPLACED STRINGER 15L END FITTING ON THE AFT SIDE OF THE APB IAW SRM 51-40-05, P1.SDR ASAA0843265Skin · dentedNR 5 SPOILER DENTED ON THE TOP SIDE IB END CENTER OF PANEL PREPPED DAMAGED AREA FABBED DOUBLER & BONDED REPAIR IAW SRM 51 70 10 PG 257.SDR ASAA0843172Link · wornNR 5 FLAP TRANSMISSION UPPER BALL LINK WORN. REPLACED TRANSMISSION REF 27-51-71-004-001 AND 27-51-71-404-026.SDR ASAA0843262Floorbeam · crackedFLOORBEAM LOWER STABILIZER AT STA 312 + BL "O" AS IS CRACKED STOPPED DRILLED THE CRACK, FABBED A DOUBLER + INSTALLED THE REPAIR IAW SRM 53-10-51, REPAIR 4.SDR ASAA0843291Floor Support · crackedCENTER ISLE FLOOR SUPPORT AT STA 540 IS CRACKED REMOVED + REPLACE FLOOR SUPPORT IAW SRM 51-40-05.SDR ASAA0843243Skin · dentedNR 3 SPOILER LOWER SURFACE IB T/E IS DENTED. INSTALLED DOUBLERS AND BONDED REPAIRS IAW SRM 51-70-10.SDR ASAA0843225Channel · corrodedL 1 DOOR LOWER CUTOUT U CHANNEL IS CORRODED. REPLACED CHANNEL IAW SRM 51 40 02.SDR ASAA0843224Angle · corrodedFWD PASSENGER (L 1) DOOR LOWER CUTOUT Z ANGLE IS CORRODED. REPLACED ANGLE IAW SRM 51 40 02.SDR ASAA0843309Skin · chafedRT IB FORE FLAP UPPER SURFACE CHAFED ALONG OB EDGE. REMOVED DAMAGED AREA FABBED FILLER, DOUBLER, BONDED REPAIR IAW SRM 51-70-10 REPAIR 4.SDR ASAA0843307Floor Support · corrodedCORROSION ON UPPER SURFACE OF FLOOR SUPPORT AT STA 767 RBL1380 REMOVED DAMAGE AND FABRICATED REPAIR PARTS & INSTALL PER ASA EA 5320 01844SDR ASAA0843295Floor Support · corrodedAFT CARGO FLOOR SUPPORT IS CORRODED REMOVED DAMAGED AREA FABRICATED REPAIR PARTS & INSTALLED IAW EA 53 20 01844.SDR ASAA0843317Floor Support · corrodedAFT PIT FLOOR SUPPORT AT STA 767 LBL 3.0 IS CORRODED REMOVED DAMAGED AREA FABBED REPAIR PARTS & INSTALLED IAW ASA EA 5320 01844.
Back to Boeing 737-4Q8