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 ASAA0741816Frame · crackedR1 DOOR SURROUND STRUCTURE FWD STUB FRAME CRACKED 3/4 WAY UP IN O/B FLANGE RADIUS. REMOVED R1 STUB FRAME, FABRICATED, TREATED & PRIMED, TOPCOATED AND INSTALLED NEW STUB FRAME IAW SRM 51-30-01, 51-40-02 AMM 51-21-21 PG 704 & 706 AND ASA EA 5210 01133.SDR ASAA0741815Girt Bar · corrodedL2 DOOR SLIDE GIRT BAR CORRODED AND PITTED. REMOVED FROM SLEEVE PER TC 45125011. REMOVED AND REPLACED L2 DOOR SLIDE GIRT BAR PER CMM 25-66-07 PG 664 STEPS 14 (A, B, C AND D).SDR ASAA0741814Flap Track · wornNR 4 FLAP TRACK SIDE LOAD LINK LOOSE. REMOVED AND REPLACED NR 4 FLAP TRACK SIDE LOAD LINK IAW AMM 27-51-27 STEP 5D (2) (B) PG 411 AND AMM 20-50-11.SDR ASAA0741791Skin · delaminatedRIGHT AILERON LOWER SURFACE IS SEPARATING. REPAIRED RIGHT AILERON LOWER SURFACE DAMAGE IAW SRM 51-70-03 REPAIR 6 PG 16.SDR ASAA0741790Skin · delaminatedRIGHT AILERON I/B FWD UPPER SURFACE PANEL IS SEPARATING AT EDGE. REPAIRED RIGHT AILERON UPPER SURFACE DAMAGE IAW SRM 51-70-03 REPAIR 6 PG 16.SDR ASAA0741789Skin · delaminatedRIGHT AILERON FWD SPAR IS SEPARATING AT I/B UNDER LWR SURFACE. REPAIRED RIGHT AILERON I/B LWR SURFACE DAMAGE IAW SRM 51-70-03 REPAIR 6 PG 16 AND EA 5760 01011.SDR ASAA0741784Web · corrodedAFT CARGO DOOR SILL WEB HAS AREAS OF CORROSION. REMOVED DAMAGED WEB SILL LOCATED AND DRILLED NEW SILL AND INSTALLED IAW SRM 51-40-02, 51-10-02 AND SOPM 20 41 05.SDR ASAA0741783Skin · dentedFUSELAGE SKIN IS DENTED OVER A STRINGER AND IN ADJACENT BAYS. CUT OUT DAMAGED AREA OF SKIN FABRICATED AND INSTALLED REPAIR FILLER DOUBLER AND TRIPLER IAW SRM 53-00-01 FIG 201 REPAIR 31.SDR ASAA0741717Skin · dentedFUSELAGE SKIN SCRATCHED AND DENTED. REMOVED DAMAGED SECTION, FABRICATED AND INSTALLED REPAIR FILLER AND DOUBLER IAW ASA EA 5330 02212.SDR ASAA0741716Skin · dentedDENT IN FUSELAGE SKIN. REMOVED DAMAGED SECTION, FABRICATED AND INSTALLED REPAIR FILLERS DOUBLERS AND TRIPLER IAW ASA EA 5330 02211.SDR ASAA0741703Attach Fitting · crackedNR 4 GROUND SPOILER O/B ACTUATOR ATTACH FITTING IS BROKEN IN TWO PIECES. NR 4 GROUND SPOILER REMOVED AND REPLACED IAW AMM 27-62-12.SDR ASAA0741702Skin · delaminatedLEFT WING O/B TRAILING EDGE FLAP IS DELAMINATED AT I/B AFT CORNER. REMOVED DAMAGED AREA, FABRICATED AND INSTALLED REPAIR FILLER AND DOUBLER IAW SRM 51-70-10.SDR ASAA0741701Fitting · gougedNR 9 FLIGHT SPOILER FITTING IS GOUGED AT ACTUATOR ATTACH POINT. REMOVED AND REPLACED SPOILER ASSY IAW AMM 27-62-71.SDR ASAA0741700Shear Tie · crackedSHEAR TIE IS CRACKED. REMOVED DAMAGED SECTION OF FRAME SHEAR TIE, FABRICATED AND INSTALLED REPAIR SHEAR TIE FILLER AND ANGLE IAW SRM 53-00-07 REPAIR 3.SDR ASAA0741699Frame · crackedFRAME SKIN ATTACHMENT ANGLE IS CRACKED AT ATTACHMENT HOLE. REMOVED DAMAGED SECTION OF FRAME FABRICATED AND INSTALLED REPAIR SHEAR TIE FILLER AND ANGLE IAW SRM 53-00-07 REPAIR 3.SDR ASAA0741698Frame · corrodedFRAME IS CORRODED. REMOVED CORRODED SECTION OF FRAME, FABRICATED AND INSTALLED REPAIR SECTION OF FRAME IAW SRM 53-00-07 REPAIR 3.SDR ASAA0741697Cargo Track · gougedCARGO TIE DOWN IS GOUGED. REMOVED DAMAGED SECTION OF TRACK, FABRICATED AND INSTALLED REPLACEMENT TRACK IAW ASA EA 5310 02722.SDR ASAA0741696Fitting · corrodedNR 4 SPOILER INBOARD ACTUATOR MOUNT FITTING HAS FRETTING CORROSION. REMOVED FITTING, INSTALLED NEW FITTING IAW SRM 51-40-02.SDR ASAA0741692Stiffener · corrodedAPU AIR INLET TORQUE BOX OPENING AFT VERTICAL STIFFENER CORRODED AT FASTENER HOLES. REMOVED CORRODED STIFFENER, FABRICATED AND INSTALLED STIFFENER IAW SRM 51-30-01 AND 51-40-02.SDR ASAA0741691Skin · chafedNR 4 SLAT IS CHAFED AT INBOARD CORNER. REMOVED DAMAGED AREA, FABRICATED AND INSTALLED FILLER AND DOUBLER IAW SRM 51-70-10.SDR ASAA0741690Skin · damagedNR 3 SLAT INBOARD TRAILING EDGE HAS COMPOSITE LAYERS SHOWING. REMOVED DAMAGED AREA, FABRICATED AND INSTALLED FILLER AND DOUBLER IAW SRM 51-70-10.SDR ASAA0741689Floorbeam · corrodedFLOORBEAM UPPER CHORD IS CORRODED. REMOVED CORROSION, FABRICATED AND INSTALLED REPAIR STRAP AND TAPERED SHIMS IAW ASA EA 5310 02721.SDR ASAA0741652Web · corrodedWEB BELOW R1 DOOR CUTOUT IS CORRODED ON LOWER SURFACE. REMOVED CORRODED WEB, FABRICATED AND INSTALLED NEW WEB IAW SRM 51-40-02.SDR ASAA0741655Skin · dentedLEFT WING O/B FORE FLAP LOWER SURFACE HAS MULTIPLE DENTS. REMOVED DAMAGED AREA, FABRICATED AND INSTALLED REPAIR DOUBLER IAW SRM 51-70-10.SDR ASAA0741654Tab · crackedRIGHT ELEVATOR TAB NR 3 HINGE CUTOUT IS CRACKED. PREPPED DAMAGED AREA, FABRICATED AND BONDED REPAIR IAW SRM 51-70-17 REPAIR 7.SDR ASAA0741640Stringer · crackedAIR START UNIT CONTACTED RIGHT SIDE OF AIRCRAFT BELOW DOOR R1. REPAIRED PER EA 5330 02206. NOTE ADDITIONAL P/N 65C36745 23.SDR ASAA0741639Sill · corrodedR1 DOOR SILL (INNER CHORD) IS CORRODED. REMOVED CORRODED SILL, REPLACED WITH NEW PART IAW SRM 51-40-02.SDR ASAA0741637Sill · corrodedAR AFT MOPSILL CORRODED (INNER CHORD). REMOVED CORRODED SILL, REPLACED SILL WITH NEW PART IAW SRM 51-40-02.SDR ASAA0741636Sill · corrodedLEFT AFT MOP SILL CORRODED (INNER CHORD). REMOVED CORRODED SILL, REPLACED SILL WITH NEW PART IAW SRM 51-40-02.SDR ASAA0741635Tab · delaminatedLEFT AILERON TAB IS DELAMINATED AT T/E. REMOVED AND REPLACED LEFT AILERION TAB IAW AMM 27-11-21 PG 401.SDR ASAA0741642Bearing · erodedCATERING REPORTED THE L1 DOOR INOPERABLE. FERRIED TO SEA, REMOVED AND REPLACED R1 DOOR PER AMM.SDR ASAA0741634Web · crackedFLOOR WEB BELOW L2 DOOR CRACKED (UNDER MOPSILL). REMOVED DAMAGED WEB, FABRICATED AND INSTALLED REPLACEMENT WEB IAW SRM 51-40-2.SDR ASAA0741633Floorbeam · corrodedFLOORBEAM CORRODED UPPER CHORD. REMOVED CORRODED SECTION OF UPPER CHORD FABRICATED AND INSTALLED REPLACEMENT CHORD ANGLES AND SHIMS IAW SRM 53-10-51.SDR ASAA0741641Skin · damagedDAMAGE TO LEFT LEADING EDGE HORIZ STAB. REMOVED L/E AND ACCOPMLISHED REPAIR IAW SRM 55-10-01 REPAIR 3.SDR ASAA0741630Web · puncturedAFT CABIN FLOOR WEB PUNCTURED. REMOVED DAMAGED AREA, FABRICATED AND INSTALLED REPAIR DOUBLERS IAW SRM 51-70-13 FIG 1.SDR ASAA0741629Shear Tie · crackedSHEAR TIE CRACKED. CUT OUT DAMAGED SECTION OF FRAME (SHEAR TIE) FABRICATED AND INSTALLED A REPAIR SHEAR TIE DOUBLER AND RADIUS FILLERS IAW SRM 53 00 07 FIG 201 REPAIR 5.SDR ASAA0741628Skin · puncturedTHE IB FORE FLAP IS PUNCTURED NEAR THE CENTER TRACK. REMOVED THE DAMAGED AREA OF LWR SKIN FABRICATED AND INSTALLED A SKIN FILLER AND A REPAIR DOUBLER IAW SRM 51 70 10 PARA 8 11 15 18 AND 20.SDR ASAA0741627Skin · chafedTHE RT OB MID FLAP IS CHAFED ON AN EXITING LE DOUBLER AT THE IB END. REMOVED THE EXITING REPAIR DOUBLER FABRICATED AND INSTALLED A REPAIR DOUBLER IAW SRM 57 53 01 FIG 201 REPAIR 8.SDR ASAA0741626Skin · crackedNR 2 SLAT SKIN LWR LIP IS CRACKED AROUND FASTENER HOLES JUST BELOW THE O B AUX TRACK. CUT OUT THE DAMAGED AREA OF SKIN FABRICATED AND INSTALLED A SKIN FILLER AND EXTERNAL SPLICE PLATE IAW SRM 57 40 01 FIG 206 REPAIR 6.SDR ASAA0741625Skin · damagedOUTWARD DING IN FUSELAGE SKIN REMOVED SKIN DAMAGE BY DRILLING A 0.1935" HOLE INSTALLED A BACR15BB6 RIVET IAW ASA EA 5330 02205 REV NEW AND AAR EA 112004 REV IR.SDR ASAA0741623Doubler · chafedRT IB FORE FLAP CHAFED ON AN EXITING REPAIR DOUBLER ON THE UPPER SIDE. REMOVED THE EXITING REPAIR DOUBLER AND FILLER FABRICATED AND INSTALLED A REPLACEMENT DOUBLER AND FILLER IAW SRM 51 70 10 PARA 7 8 11 15 18 AND 20.SDR ASAA0741622Skin · dentedLT IB FOR FLAP DENTED OUT OF LIMITS NEAR CENTER TRACK. REMOVED THE DAMAGED AREA OF LOWER SKIN FABRICATED AND INSTALLED A SKIN FILLER AND REPAIR DOUBLER IAW SRM 51 70 10 PARA 8 11 15 18 AND 20.SDR ASAA0741621Skin · delaminatedLT ELEV TAB UPPER SURFACE T E IS SPLIT 51" FROM I B END. PREPPED THE TAB UPPER SKIN SURFACE FOR BONDING CUT AND APPLIED REPAIR PLIES IAW SRM 51 70 05 PAPR 3.SDR ASAA0741596Stringer · crackedSTR 11L FOUND CRACKED AT FASTENER HOLES. CRACK REPAIRED IAW EA 5310 02714.SDR ASAA0741595Frame · crackedFRAME CRACKED AT 37L INTERCOSTAL ATTACHMENT HOLE. FRAME REPAIRED IAW EA 5310 02714.SDR ASAA0741594Sill · corrodedCORROSION FOUND ON R2 SILL CHORD. CORRODED SILL CHORD REPLACED WITH NEW PART IAW SRM 51-40-05 AND 51-40-02.SDR ASAA0741593Sill · corrodedL2 DOORWAY LOWER SILL CHORD CORROSION FOUND. REPLACED LWR SILL CHORD WITH NEW PART IAW SRM 51-40-05 AND 51-40-02.SDR ASAA0741592Floor Support · corrodedAFT CABIN CORROSION FOUND ON FLOOR SUPPORT ANGLE. CORRODED FLOOR ANGLE REPLACED WITH FABRICATED REPAIR PART IAW SRM 53-60-51 FIG 20, 51-40-05 AND 51-40-02.SDR ASAA0741591Skin · crackedRIGHT WING O/B LEADING EDGE AT WS 290 FIXED LEADING EDGE SKIN CRACKED. FIXED LEADING EDGE SKIN REPAIRED IAW SRM 51-70-17.SDR ASAA0741590Intercostal · crackedINTERCOSTAL CRACKED. CRACKED INTERCOSTAL REPLACED WITH NEW PART IAW SRM 51-40-05 AND 51-40-02.
Back to Boeing 737-4Q8