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 ASAA0944575Shear Tie · corrodedFWD CARGO SHEAR TIE CORROSION OUT OF LIMITS BS 500 WL 148 STR RBL 5 LBL 5. REMOVED DAMAGED SHEAR TIE, FABRICATED REPAIR PARTS AND INSTALLED PER SRM 53-00-07 REPAIR 3.SDR ASAA0944574Shear Tie · corrodedFWD CARGO SHEAR TIE CORROSION OUT OF LIMITS BS 500 WL 148 STR BL 0. REMOVED DAMAGED SHEAR TIE, FABRICATED REPAIR PARTS AND INSTALLED PER SRM 53-00-07 REPAIR 3.SDR ASAA0944573Shear Tie · corrodedFWD CARGO SHEAR TIE CORROSION OUT OF LIMITS BS 500 WL 148 STR 27R. REMOVED DAMAGED SHEAR TIE, FABRICATED REPAIR PARTS AND INSTALLED PER SRM 53-00-07 REPAIR 3.SDR ASAA0944572Shear Tie · corrodedFWD CARGO SHEAR TIE CORROSION OUT OF LIMITS BS 500D WL 148 RBL 4. REMOVED DAMAGED SHEAR TIE, FABRICATED REPAIR PARTS AND INSTALLED PER SRM 53-00-07.SDR ASAA0944571Frame · chafedFRAME AT BS 601, 3 INCHES ABOVE STR 5 IS CHAFED. REPAIRED FRAME PER SRM.SDR ASAA0944563Seat Track · damagedNUMEROUS AREAS OF CORROSION/DAMAGE ON SEAT TRACK SEGMENT BS 540 727 LBL 23. REMOVED AND REPLACED SEAT TRACK.SDR ASAA0944562Seat Track · crackedSEAT TRACK BS 520-730 RBL 43 CORROSION AND MEC DAMAGE OUT OF LIMITS. REPLACED TRACK.SDR ASAA0944561Seat Track · damagedSEAT TRACK BS 540 727 LBL 44 CORROSION AND MEC DAMAGE OUT OF LIMITS. REMOVED AND REPLACED SEAT TRACK PER SRM 53-00-52.SDR ASAA0944559Seat Track · damagedSEAT TRACK BS 727B 907 RBL 45 CORROSION/ MECHANICAL DAMAGE OUT OF LIMITS. REMOVED AND REPLACED SEAT TRACK.SDR ASAA0944558Seat Track · corrodedSEAT TRACK BS 480-520 LBL 23 CORROSION/ MECHANICAL DAMAGE OUT OF LIMITS. REMOVED AND REPLACED SEAT TRACK.SDR ASAA0944560Web · gougedFWD CARGO BAY CLOSE OUT WEB GOUGED OUT OF LIMITS PER SRM 53-30-15. REMOVED CLOSE OUT WEB, FABRICATED NEW WEB AND INSTALLED PER SRM 53-30-15 AND 51-40-02.SDR ASAA0944557Web · corrodedCORROSION OUT OF LIMITS AFT CARGO BAY WEB BS 847 867 RBL 22 PER SRM 50-60-53. REMOVED AND REPLACED WEB.SDR ASAA0944556Support Angle · crackedUPPER AFT SUPPORT ANGLE CRACKED (WING TO BODY FAIRING SUPPORTS) BS 540 LT SIDE OF RAM AIR INLET. REMOVED DAMAGED SECTION, FABRICATED SPLICE PARTS.SDR ASAA0944555Support Angle · crackedUPPER AFT SUPPORT ANGLE CRACKED (WING TO BODY FAIRING SUPPORTS) RT SIDE OF RAM AIR INLET. REMOVED DAMAGED SECTION, FABRICATED SPLICE PARTS.SDR ASAA0944551Threshold · corrodedSUB THRESHOLD WEB AFT CARGO CORRODED. REMOVED, FABRICATED & INSTALLED NEW SUB THRESHOLD WEB PER SRM 51-40-05 & 51-20-01 AND DWG S330018186.SDR ASAA0944527Frame · corrodedCORROSION AFT CARGO BAY LOWER AFT FLANGE OF FRAME AT BODY STA 767 RBL 11.5. REPLACED FRAME FLANGE (ANGLE) PER SRM 53-60-08, 51-40-02 AND 51-40-05.SDR ASAA0944526Crease Beam · corrodedAREAS CORROSION ON INNER CREASE BEAM LT SIDE BS 500C-520. REMOVED AND REPLACED CREASE BEAM.SDR ASAA0945036Floor Support · corrodedCORROSION AFT CARGO BAY FLOOR SUPPORT STA 807+16 RBL 3. REPAIRED FLOOR.SDR ASAA0944977Stringer Clip · crackedSTR 6R CLIP CRACKED BS 601. REMOVED CRACKED CLIP, INSTALLED NEW CLIP PER ASA DWG A53100265816 AND SRM 51 40 02.SDR ASAA0944976Stringer Clip · crackedSTR 5R CLIP CRACKED BS 578. REMOVED CRACKED STR 5R CLIP, INSTALLED NEW PER ASA DWG A53100265823 AND SRM 51 40 02.SDR ASAA0944975Stringer Clip · crackedSTR 5L CLIP CRACKED BS 578. REMOVED CLIP, INSTALLED NEW CLIP PER ASA DWG A53100265823 AND SRM 51 40 02.SDR ASAA0944658Frame · dentedFRAME DENTED STA 727G BETWEEN 26R 25R. CUT OUT DAMAGED SECTION, FABRICATED AND INSTALLED REPAIR CHANNEL IAW B737 400 SRM 51 70 11 FIG 1.SDR ASAA0944528Seat Track · corrodedNUMEROUS AREAS OF CORROSION AND MECHANICAL DAMAGE ON SEAT TRACK. REMOVED AND REPLACED SEAT TRACK.SDR ASAA0944531Frame · crackedBS 986 STR 76 FRAME IS CRACKED AT STRINGER CUTOUT. REPAIRED PER EA 400-53EA-00968.SDR ASAA0944530Support · corrodedCORROSION AFT CARGO BAY AFT BULKHEAD PANEL LOWER CENTER SUPPORT. REMOVED SUPPORT, FABRICATED NEW SUPPORT AND INSTALLED PER SRM 51-40-02.SDR ASAA0944529Web · corrodedLT WEB STA 986-1016 LBL 44 CORRODED. REMOVED AND REPLACED WEB PER SRM 53-60-53.SDR ASAA0944524Sill · corrodedR2 DOOR MOP SILL CREASE BEAM CORRODED. REMOVED AND REPLACED R2 MOP SILL.SDR ASAA0944789Fitting · corrodedL1 DOOR AFT GIRT BAR MOUNT FITTING CORRODED. REMOVED FITTING REVIVED DRILLED AND INSTALLED NEW FITTING ASSY IAW B737 400 MM 20 50 11 912 002.SDR ASAA0944788Frame · corrodedFRAME UPPER SURFACE CORRODED STA 727G LT. REMOVED CORRODED AREA, FABRICATED, TREATED AND INSTALLED REPAIR ANGLE IAW B737 400 SRM 51 70 11.SDR ASAA0944659Skin · damagedRT OUTBOARD AFT FLAP O/B LOWER END DAMAGED. REMOVED DAMAGED SECTION, FABRICATED AND BONDED FILLER AND DOUBLER IAW B737 400 SRM 51 70 10.SDR ASAA0944665Doubler · corrodedINTERNAL DOUBLER FOR SKIN SPLICE CORRODED FWD PIT STA 500C STR 26L 26R. REMOVED DOUBLER, FABRICATED, LOCATED AND DRILLED, AND INSTALLED NEW SPLICE DOUBLER IAW B737 400 SRM 51 40 02.SDR ASAA0944632Skin · dentedRIGHT I/B AFT FLAP HAS TWO DENTS ON LOWER T/E. REMOVED DAMAGED AREA, FABRICATED AND BONDED REPAIR MATERIAL IAW B737 400 SRM 51 70 10.SDR ASAA0944513Support Channel · crackedFWD CARGO COMPARTMENT ANTENNA SUPPORT CHANNEL CRACKED AND CORRODED. REMOVED, FABRICATED NEW CHANNEL AND INSTALLED.SDR ASAA0944512Support · corrodedCORROSION ON AFT CARGO BAY FLOOR SUPPORT. REPAIRED AFT CARGO FLOOR SUPPORT PER SRM.SDR ASAA0944511Support · corrodedFWD CARGO COMPARTMENT FLOOR TO SIDEWALL SUPPORT HAS CORROSION. REMOVED SUPPORT, FABRICATED NEW SUPPORT AND INSTALLED.SDR ASAA0944510Support · corrodedFWD CARGO COMPARTMENT FLOOR TO SIDEWALL SUPPORT HAS CORROSION. REMOVED SUPPORT, FABRICATED NEW SUPPORT AND INSTALLED.SDR ASAA0944509Support Channel · corrodedCORROSION AFT CARGO BAY RT SUPPORT ZEE CHANNEL. REMOVED AND REPLACED FLOOR TO SIDEWALL SUPPORT.SDR ASAA0944502Support · corrodedAFT CARGO BAY CORROSION ON FLOOR TO SIDEWALL SUPPORT. REPLACED SUPPORT.SDR ASAA0944501Support · corrodedAFT CARGO BAY CORROSION ON FLOOR TO SIDEWALL SUPPORT. REMOVED AND REPLACED FLOOR TO SIDEWALL SUPPORT.SDR ASAA0944500Stringer Clip · crackedFWD CARGO COMPARTMENT BS 500F STR 25L STRINGER CLIP IS CRACKED. REPLACED STR CLIP.SDR ASAA0944499Stringer Clip · crackedFWD CARGO COMPARTMENT BS 500G STR 26R STRINGER CLIP IS CRACKED. REMOVED AND REPLACED STRINGER CLIP.SDR ASAA0944498Support · damagedAFT CARGO BAY LT SUPPORT ZEE HAS NUMEROUS ELONGATED FASTENER HOLES BETWEEN STA 847 AND 947. REMOVED, FABRICATED NEW AND INSTALLED.SDR ASAA0944497Support · corrodedCORROSION AFT CARGO BAY LT SUPPORT ZEE. REMOVED, FABRICATED NEW AND INSTALLED.SDR ASAA0944664Carriage · corrodedRIGHT O/B MID FLAP OUTBOARD CARRIAGE HALVES HAVE CORROSION IN BORES. REMOVED I/B CARRIAGE HALF INSTALLED NEW I/B CARRIAGE HALF IAW MM 27 51 14 O/B HALF CORROSION REMOVED AND IN LIMITS.SDR ASAA0944630Skin · dentedLT OUTBOARD FOREFLAP DENTED T/ LOWER SURFACE APPROX WBL 360. REMOVED DAMAGED AREA, FABRICATED AND BONDED REPAIR MATERIAL IAW B737 400 SRM 51 70 10.SDR ASAA0944594Attach Fitting · corrodedRT INBOARD MID FLAP O/B TORQUE TUBE ATTACH FITTING CORRODED. REMOVED FITTING, LOCATED, DRILLED AND INSTALLED NEW ATTACH FITTING IAW 737 400 SRM 51 40 02.SDR ASAA0944516Skin · dentedFUSELAGE SKIN HAS DENT 15 INCHES AFT OF AFT SERVICE DOOR CUTOUT. REMOVED AND REPLACED FUSELAGE SKIN.SDR ASAA0944515Skin · gougedSKIN GOUGED AT AND BELOW LAP. REMOVED AND REPLACED SKIN.SDR ASAA0944521Crease Beam · corrodedR1 DOOR CREASE BEAM CORRODED. REMOVED AND REPLACED CREASE BEAM PER SRM 51-40-02.SDR ASAA0944520Floor Support · corrodedFLOOR SUPPORT CORRODED AT SPLICE REPAIR. REPAIRED FLOOR SUPPORT PER SRM.
Back to Boeing 737-4Q8