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 ASAA2013031294187Skin · damagedLT HORIZONTAL STAB LOWER SKIN INBD END AT T/E SPAR RIVETS SMOKING. APPEAR TO BE PULLING THROUGH SKIN. REPAIRED SKIN IAW SRM 55-10-01, FIG 202, DETAIL III.SDR ASAA2013031294185Cover · crackedL1 DOOR ESCAPE SLIDE HAS CRACK AT GRIT BAR RETAINER RIVETS. ACFT GROUNDED. REPAIRED L1 DOOR ESCAPE SLIDE COVER IAW EA 400-25EA-09929, REV NEW.SDR ASAA2013031194171Doubler · damagedTAILCONE AREA, LT SIDE STRAP ABOVE EDGE OF APU ACCESS DOOR. AFT END OF STRAP IS BENT AT RIVETS. REMOVED, FABRICATED AND INSTALLED NEW STRAP ABOVE EDGE OF LT APU ACCESS DOOR IAW SRM 51 40 02 AND 51 40 05.SDR ASAA2013030994188Skin · crackedRIGHT L/E CRACKING AT K-FLAP CUTOUT OTBD EDGE OF K-FLAP. REPAIRED RT OTBD K-FLAP L/E IAW ASA TYPICAL EA 5740-01310.SDR ASAA2013030794189Cargo Track · damagedCARGO TRACK DAMAGED. REMOVED DAMAGED SECTION OF CARGO TRACK AT BS 800 LBL 17 AND SPLICED IN NEW SECTION IAW SRM 53-00-53, FIG 201, REPAIR 2.SDR ASAA2013030694083Cargo Track · corrodedAFT PIT CARGO TRACK IS CORRODED RBL 13.8, STA 907. REMOVED CORRODED ON CARGO TRACK AT STA 907, RBL 13.8, MATERIAL LOSS FOUND TO BE OUT OF LIMITS IAW SRM 53 60 53, FIG 101, DETAIL IX. R & R CARGO TRACK SECTION IAW SRM 53 00 53, FIG 201, REPAIR 2W 1.90 O .140 RSDR ASAA2013030694070Floor Panel · chafedAFT CARGO NR 4 FLOOR PANEL EDGE DAMAGED. FABRICATED FLOOR PANEL AND REPLACED.SDR ASAA2013030594168Skin · dentedTHREE DENTS ON FUSELAGE AFT OF L2 DOOR & FWD OF BS 1016. NR 1 DENT AT BS 1011, 9.0 BELOW S-10L LAP, NR 2 DENT AT BS 1011.5, 2.0 BELOW S-11L AND NR 3 DENT AT BS 1007, 3.5 BELOW S11L. R & R SKIN IAW SRM 51-40-02.SDR ASAA2013030194063Wedge · debondedNR 3 SLAT T/E WEDGE UPPER SKIN HAS PREVIOUS REPAIR DOUBLER THAT IS DISBONDED. REPAIRED NR 3 SLAT UPPER SKIN T/E WEDGE IAW SRM 51 70 10, REP 4.SDR ASAA2013022894125Skin · damagedSCRIBE LINE AT BS 727G SKIN BUTT STRAP FROM STRINGER 5R TO 6R. R & R WITH NEW BUTT STRAP IAW SRM 51-40-02.SDR ASAA2013022894075Skin · crackedFUSELAGE SKIN HAS SUBSURFACE CRACK AT CHEM MILL LT STA 727D 2.5 INCHES BELOW STR 23L, APPROX .75 INCHES LONG. REPAIRED SKIN IAW SRM 53-00-01 REPAIR 31. THIS REPAIR IS A CAT B REPAIR.SDR ASAA2013022894072Buttstrap · damagedSCRIBE LINE AT BS 908 BUTT STRAP FROM STR 7L TO STR 8L. REMOVED, FABRICATED AND INSTALLED NEW BUTT JOINT STRAP IAW SRM 51 40 05 AND 51 40 02.SDR ASAA2013022794064Skin · chafedNR 3 SLAT LOWER INBD CORNER IS CHAFED ON SKIN FILLER. REPAIRED NR 3 SLAT LOWER INBD CORNER IAW SRM 51-70-10, REPAIR 4.SDR ASAA2013022794022Seat Track · corrodedRT LATERAL SEAT TRACK AT BS 520, CORRODED. ACFT GROUNDED. R & R SEAT TRACK IAW SRM 51-40-02.SDR ASAA2013022794019Seat Track · corrodedRT LATERAL SEAT TRACK AT BS 500G IS CORRODED. R & R SEAT TRACK IAW SRM-51-40-02.SDR ASAA2013022794003Strap · corrodedAFT CARGO FLOOR PANEL SPLICE STRAP AT BS 727D+5.6 IS CORRODED. FABRICATED NEW SPLICE STRAP IAW 51-40-05 SRM.SDR ASAA2013022794002Skin · chafedSKIN PANEL BELOW LT HORIZONTAL STAB AFT ATTACH FITTING IS CHAFED. R & R SKIN PANEL IAW SRM 51 40 02.SDR ASAA2013022793999Frame · corrodedUPON REMOVAL OF AFT PIT FLOOR PANEL FOR CARGO TRACK REPAIR FOUND FRAME SHEAR TIE AT STA 867 BETWEEN STR 27L AND 27R CORRODED. REMOVED CORROSION BY BLENDING, FOUND TO BE OUT OF LIMITS REPAIRED AREA IAW SRM 53-00-07, FIG 101 AND 53-60-07, FIG 201.SDR ASAA2013022793993Seat Track · corrodedLEFT LATERAL SEAT TRACK, BS 520 CORRODED. R & R SEAT TRACK IAW SRM 51-40-02.SDR ASAA2013022694184Web · corrodedLEFT MLG INNER DOOR WEB IS CORRODED. INSTALLED NEW WEB IN LT MLG INNER DOOR.SDR ASAA2013022694095Floor Panel · crackedAFT CARGO BAY FORWARD FLOOR PANEL HAS SMALL CRACK REMOVED, FABRICATED AND INSTALLED NEW FLOOR PANEL IAW AMM 25-52-51-004-001, SRM 51-40-05, AND MM 25-52-51-404-011.SDR ASAA2013022694093Skin · chafedLEFT OTBD FOREFLAP L/E CHAFED ON INBD END. REPAIRED IAW SRM 57-53-01, FIG 101.SDR ASAA2013022594143Skin · dentedRT FUSELAGE STA 516 SKIN HAS TWO DENTS AT 23R. REPAIRED SKIN DAMAGED IAW SRM 53 00 01, FIG 201, REPAIR 31 DET X.SDR ASAA2013022594120Tab · gougedRIGHT ELEVATOR TAB INBD HINGE CUTOUT HAS DAMAGE ON INBD EDGE. REPAIRED RT ELEVATOR TAB INBD HINGE CUTOUT ON INBD EDGE IAW SRM 51 70 04, REPAIR 10.SDR ASAA2013022394166Skin · dentedFOUND A DENT OUT OF LIMITS AT BS 1022, BL 0. REPAIRED DAMAGED AREA IAW EA 400-53EA-09950.SDR ASAA2013022393973Door · out of adjustR2 DOOR HARD TO CLOSE. FOUND FWD UPPER LATCH ROD END HITTING LATCH FITTING. DOOR NOT CLOSING PARALLEL, UPPER LATCH ROLLERS NOT ENGAGING AT THE SAME TIME. UPPER FWD LATCH ROLLERS WORN. REPLACED UPPER FWD LATCH ROLLER REF AMM 52-41-00, COMPLETED PARALLEL ADJUSDR ASAA2013022193996Skin · chafedRIGHT WING OTBD FOREFLAP INBD L/E SKIN IS CHAFED. REPAIRED IAW SRM 57-53-01, FIG 201.SDR ASAA2013021994012Skin · gougedAFT CARGO DOOR INNER SKIN HAS TOOLING DAMAGE LOWER CENTER RIVET LINE REPAIRED INNER SKIN IAW SRM 51-70-13.SDR ASAA2013021993957Floor Panel · puncturedFLOOR PANEL JUST LEFT OF BL 0 IS PUNCTURED AT BS 578 REPAIRED FLOOR PANEL USING FIBERGLASS CLOTH AND RESIN.SDR ASAA2013021894169Threshold · corrodedFWD CARGO AFT THRESHOLD CAP CORRODED. ON FURTHER INVESTIGATION CAP FOUND TO BE BROKEN AND OUT OF LIMITS IAW SRM 53-30-53, FIG 101. FABRICATED NEW THRESHOLD CAP IAW SRM 51-40-05.SDR ASAA2013021894102Cap · corrodedFWD CARGO FWD THRESHOLD CAP CORRODED, CORRODED THROUGH HOLES, 100 MATL LOSS OUT OF LIMITS IAW SRM 53 30 53, FIG 101. FABRICATED NEW THRESHOLD CAP IAW SRM 51- 40-05.SDR ASAA2013021894117Attach Angle · crackedFWD CARGO DOORWAY FWD FRAME ATTACHMENT TO STR 22R CRACKED ON INNER RADIUS. R & R FRAME ATTACH ANGLE IAW SRM 51 40 02.SDR ASAA2013021894104Skin · dentedRT FUSELAGE SKIN BS 233 AND S22R IS DENTED. DENT WITHIN 3" OF LAP SEAM. REPAIRED SKIN, REPAIR IS A CATEGORY B REPAIR.SDR ASAA2013021894065Cargo Track · corrodedAFT CARGO TRACK BS 945 LBL 17.2 IS CORRODED. REMOVED CORRODED ON CARGO TRACK FOUND TO BE OUT OF LIMITS IAW SRM 53 60 53, FIG 101. SPLICED IN NEW SECTION IAW SRM 53 00 53, FIG 201.SDR ASAA2013021894062Skin · chafedRIGHT WING OTBD FLAP LOWER SURFACE INBD OF NR 7 FLAP TRACK IS CHAFED. REPAIRED RT WING OTBD FLAP LOWER SURFACE IAW SRM 51-70-10, REPAIR 4.SDR ASAA2013021894054Skin · chafedRIGHT WING OTBD FLAP LOWER SURFACE OTBD OF FLAP JACKSCREW SKIN DAMAGED. REPAIRED IAW SRM 51 70 10, REPAIR 4.SDR ASAA2013021894048Skin · chafedRIGHT WING OTBD FLAP LOWER SURFACE OTBD OF NR 7 FLAP TRACK IS CHAFED ON EXISTING REPAIR. REPAIRED IAW SRM 51-70-10, REPAIR 4.SDR ASAA2013021893997Floor Panel · corrodedAFT PIT NR 2 FLOOR PANEL IS CORRODED. REMOVED CORRODED MATERIAL LOSS, FOUND TO BE OUT OF LIMITS IAW SRM 53-60-53. FABRICATED FLOOR PANEL IAW SRM 51-40-05, TREATED NEW FLOOR PANEL IAW AMM 51-21-41-377-032, STEP D 1-6 AND PRIMED NEW FLOOR PANEL IAW SOPM 20 44 SDR ASAA2013021794167Skin · chafedLEFT WING INBD MIDFLAP UPPER SURFACE IS CHAFED ON INBD END. REPAIRED MIDFLAP UPPER SURFACE IAW SRM 57-53-01, FIG 201, REPAIR 3.SDR ASAA2013021794165Skin · chafedLEFT WING OTBD MIDFLAP LOWER SURFACE SKIN IS CHAFFED INBD OF NR 1 FLAP TRACK FAIRING. ACFT GROUNDED. REPAIRED LT WING OTBD MIDFLAP LOWER SKIN IAW EA CMPT-57EA-09933.SDR ASAA2013021794098Skin · chafedLEFT WING INBD EXHAUST GATE IS CHAFED ON UPPER OTBD SURFACE. REPAIRED LT WING INBD EXHAUST GATE IAW SRM 57-53-01, REPAIR 10.SDR ASAA2013021794055Skin · chafedLEFT WING NR 3 SLAT T/E WEDGE IS CHAFED ON THE LOWER SURFACE BEHIND ACTUATOR. REPAIRED IAW SRM 51-70-10, REPAIR 4.SDR ASAA2013021794053Skin · chafedLEFT WING OTBD MIDFLAP LOWER SKIN IS CHAFED. REPAIRED IAW SRM 51 70 10, REPAIR 4.SDR ASAA2013021794052Skin · chafedLEFT WING OTBD MIDFLAP LOWER SURFACE SKIN IS CHAFED ON A PREVIOUS REPAIR INBD OF THE NR 2 FLAP TRACK FAIRING. REPAIRED LT WING OTBD MIDFLAP LOWER SURFACE SKIN IAW SRM 51-70-10, REPAIR 4.SDR ASAA2013021794024Skin · dentedLEFT WING OTBD AFT FLAP LOWER SURFACE IS DENTED. LT WING OTBD AFT FLAP LOWER SURFACE REPAIRED IAW SRM 51-70-10, REP 4.SDR ASAA2013021794011Skin · chafedLT WING OTBD FOREFLAP INBD L/E IS CHAFED REPAIRED L/E SKIN IAW SRM 57 53 01, FIG 201, REPAIR 1.SDR ASAA2013021793974Structure · chafedLT WING INBD FOREFLAP IS GOUGED. REPAIRED IAW SRM 51-70-10, REPAIR 4.SDR ASAA2013021694141Bulkhead · dentedMAIN CARGO AREA AFT PARTITION IS DENTED ON DOOR BELOW LATCH MAIN CARGO AREA AFT PARTITION DENT ON EDGE OF DOOR BELOW LATCH IS ACCEPTABLE TO LEAVE AS IS NO FURTHER ACTION REQUIRED IAW EA 15023, AND ASA EA 400 53EA 09926, REV IR.SDR ASAA2013021694139Bulkhead · dentedMAIN CARGO AREA AFT PARTITION RT BULKHEAD HAS SEVERAL DENTS ON SURFACE. REPAIRED MAIN CARGO AREA AFT PARTITION RT BULKHEAD DENTS ON FWD SURFACE IAW EA 15023 AND ASA EA 400-53EA-09926, REV IR.SDR ASAA2013021694138Bulkhead · dentedMAIN CARGO AREA AFT PARTITION DOOR IS GOUGED ON FWD SIDE REPAIRED MAIN CARGO AREA AFT PARTITION DOOR FWD SIDE GOUGE IAW EA 15023 AND EA 400-53EA-09926, REV IR.
Back to Boeing 737-4Q8