Boeing 737-7Q8
Service difficulty reports · 3,964
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 = '7377Q8' 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 = '7377Q8' 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 SWAA2016102709143Shield · corrodedFORWARD CARGO BAY, CORRODED ON SHIELD CORRODED BETWEEN BS 430 TO BS 440, RBL 24. R&R SHIELD IAW SRM.SDR SWAA2016102709142Web · corrodedFORWARD CARGO BAY LOWER MAIN SILL SUB THRESHOLD WEB CORRODED BETWEEN BS 440 TO BS 490, RBL 32. R&R WEB IAW SRM.SDR SWAA2016102709141Support Angle · corrodedCENTER AFT LOWER BULKHEAD PANEL SUPPORT ANGLE CORRODED AT BS 500D, BETWEEN RBL 23 TO LBL 23. R&R ANGLE PER SRM.SDR SWAA2016120510189Structure · crackedFUSELAGE SKIN COMMON TO BULKHEAD CHORD CRACKED AT BS 540, BETWEEN STR 22R TO STR 23R. REPAIRED CHORD IAW ER AND EA.SDR SWAA2016120510188Structure · crackedFUSELAGE SKIN COMMON TO BULKHEAD CHORD CRACKED AT BS 540, BETWEEN STR 22L TO STR 23L. REPAIRED CHORD IAW EA & ER.SDR SWAA2016102409056Scuff Plate · crackedFORWARD CARGO BAY, FORWARD SCUFF PLATE CRACKED. R&R SCUFF PLATE IAW EA.SDR SWAA2016092608182Sign · faultyL2 DOOR LOWER EXIT SIGN FAULTY. R & R SIGN IAW AMM.SDR SWAA2016092608181Sign · faultyR2 DOOR LOWER EXIT SIGN FAULTY. R & R SIGN IAW AMM.SDR SCNA20160916190Lens · missingEMERGENCY EXIT LENS AT SEAT 13F MISSING. REPLACED EMERGENCY EXIT LENS AT SEAT 13F.SDR SWAA2016102409055Bracket · crackedFORWARD CARGO BAY BULKHEAD SUPPORT BRACKET CRACKED AT BS 500D, STR 19L. R&R BRACKET IAW SRM.SDR SWAA2016102409054Baffle · crackedFORWARD CARGO BAY FLOOR BAFFLE CRACKED BETWEEN BS 500A TO BS 500B, RBL 23. R&R BAFFLE PER SRM.SDR SWAA2016091607888Gusset · crackedSTRINGER TO FRAME GUSSET CRACKED AT BS 500D, STRINGER 19R. R & R THE GUSSET IAW SRM.SDR SWAA2016091255673Attach Fitting · crackedINTERCOSTAL TO FRAME ATTACH CLIP CRACKED AT BS 400, LBL 25. R & R CLIP IAW SRM.SDR SWAA2016100308406Baffle · crackedAFT CARGO BAY BAFFLE CRACKED BETWEEN BS 727A TO 727B, LBL 21. R & R BAFFLE IAW SRM.SDR SWAA2016091255672Attach Fitting · crackedFORWARD CARGO BAY BAFFLE ATTACH CLIP CRACKED AT BS 500C, RBL 23. R & R CLIP IAW SRM.SDR SWAA2016092608180Floor Support · crackedFORWARD CARGO BAY FLOOR SUPPORT CRACKED BETWEEN BS 500 TO 500A, LBL 23. R & R THE FLOOR SUPPORTA IAW SRM.SDR SWAA2016091907968Baffle · crackedFORWARD CARGO BAY BAFFLE CRACKED BETWEEN BS 400 TO 420, LBL 23. R & R THE BAFFLE IAW SRM.SDR SCNA20160904142Window Frame · crackedFLIGHT DECK R1 WINDOW FRAME, O/B UPPER CORNER OF WINDOW PANE CUTOUT, CRACK IN FRAME ON INNER EDGE TO AFT FACE, .100 X .100. VERIFIED BY NDT INDP. REPAIRED IAW SB.SDR SCNA20160904141Cover · gougedRIGHT WING INBOARD FLAP, HAS A DEEP GOUGE. REPAIRED RT I/B FLAP SLAT FAIRING. REMOVED AND INSTALLED RT COVER PLATE PANEL.SDR SCNA20160904140Skin · puncturedLEFT INBOARD AFT FLAP IS PUNCTURED 29 INCHES INBOARD FROM THE OUTBOARD EDGE AND 4 INCHES FORWARD OF THE TRAILING EDGE. REPAIRED LT WING FLAP.SDR SCNA20160904139Skin · wornWING PANEL 651EB HAS WEAR MARKS. REPAIRED THE PANEL.SDR SCNA20160904138Floor Panel · corrodedAFT CARGO FLOOR PANEL 140CF HAS CORROSION AT FWD ENTRY SIDE. BLENDED CORROSION. VERIFIED DAMAGE EXCEEDS 3 ICHES IN LENGTH AND FOUND TO BE OUT OF LIMITS. FABRICATED NEW FLOOR PANEL.SDR SCNA20160904137Floor Support · corrodedAFT CARGO FLOOR PANEL SPLICE AT BS 727D IS CORRODED IN SEVERAL AREAS. BLENDED CORROSION ON FLOOR PANEL TEE SPLICE. VERIFIED 100% MATERIAL LOSS AND FOUND TO BE OUT OF LIMITS.SDR SCNA20160904136Scuff Plate · corrodedAFT CARGO BAY FWD ENTRY SCUFF PLATE IS CORRODED. REMOVED COROSION .SDR SCNA20160904135Angle · dentedRIGHT ZEE ANGLE AT BS 500A+16 HAS A DENT. REMOVED & REPLACED THE ANGLE.SDR SCNA20160904134Door · crackedNR 2 OUTBOARD FAN COWL, STRUCTURE AFT OF OIL SERVICE DOOR IS CRACKED IN RADIUS. REMOVED AND REPLACED STRUCTURE AFT OF NR 2 ENGINE OIL SERVICE DOORSDR SCNA20160904133Skin · crackedDURING HFEC INSPECTION, FOUND A CRACK INDICATION IN THE SKIN JUST BELOW STRINGER 22L, BS 540 BULKHEAD UPPER FRAME. REMOVED DAMAGE, HFEC CUT-OUT & HOLE, NO OTHER DEFECT NOTED, FABRICATED DOUBLER, TRIPLER, AND FILLERS. TREATED AND PRIMED ALL REPAIR. INSTALSDR SCNA20160904132Mount · corrodedBOTH CENTER DIVIDERS ON G4 GALLEY FLOOR MOUNTS ARE CORRODED. REMOVED AND REPLACED FLOOR MOUNTS FOR BOTH CENTER DIVIDERS, ON G4 GALLEY.SDR SCNA20160904131Floorboard · corrodedAFT WET AREA FLOORBOARD HAS CORRODED INSERTS. REMOVED AND REPLACED THE INSERTS.SDR SCNA20160904130Floorboard · corrodedAFT WET AREA FLOORBOARD HAS CORRODED INSERTS. REMOVED AND REPLACED THE INSERTS.SDR SCNA20160904129Floorboard · corrodedAFT WET AREA FLOORBOARD HAS CORRODED AND MISSING INSERTS. REMOVED THE DAMAGED INSERTS. REPLACED THE DAMAGED INSERTS AND THE MISSING INSERTS.SDR SCNA20160904128Floorboard · damagedWET AREA FLOORBOARD HAS EVIDENCE OF WATER DAMAGE AND CORRODED INSERTS. REPAIRED THE FLOORBOARD.SDR SCNA20160904127Floorboard · damagedAFT WET AREA FLOORBOARD HAS EVIDENCE OF WATER DAMAGE AND CORRODED INSERTS. REPAIRED THE FLOORBOARDSDR SCNA20160904126Floorboard · damagedAFT WET AREA FLOORBOARD HAS EVIDENCE OF WATER DAMAGE AND CORRODED INSERTS. REPAIRED THE FLOORBOARD.SDR SCNA20160904125Insert · missingAFT WET AREA FLOORBOARD HAS PULLED AND MISSING INSERTS. REPLACED THE INSERT.SDR SCNA20160904124Crease Beam · corrodedR2 DOOR CREASE BEAM FROM BS 947-960 HAS CORROSION. REMOVED CORROSION.SDR SCNA20160904123Floor Support · corrodedFLOOR SUPPORT BETWEEN BS 967 - 986.5 LBL 16 HAS CORROSION. REMOVED AND REPLACED THE FLOOR SUPPORT.SDR SCNA20160904122Floor Support · damagedFLOOR SUPPORT BETWEEN BS 967 - 986.5, RBL 16 HAS A SCRIBE LINE. REMOVED DAMAGE. FOUND OUT OF LIMITS. REMOVED AND REPLACED THE FLOOR SUPPORT.SDR SCNA20160904121Insert · corrodedFWD WET AREA FLOORBOARD HAS CORRODED INSERTS. REMOVED AND REPLACED THE INSERTS.SDR SCNA20160904120Insert · corrodedFWD WET AREA FLOORBOARD HAS CORRODED INSERTS. REMOVED AND REPLACED THE INSERTS.SDR SCNA20160904119Insert · corrodedFWD WET AREA FLOORBOARD HAS CORRODED INSERTS. REMOVED AND REPLACED THE INSERTS.SDR SCNA20160904118Insert · corrodedFWD WET AREA FLOORBOARD HAS CORRODED INSERTS. REMOVED AND REPLACED THE INSERTS.SDR SCNA20160904117Insert · corrodedFWD WET AREA FLOORBOARD HAS CORRODED INSERTS. REMOVED AND REPLACED THE INSERTS.SDR SCNA20160904116Floorboard · damagedFWD WET AREA FLOORBOARD HAS A BROKEN EDGE. REPAIRED THE FLOORBOARD.SDR SCNA20160904115Insert · corrodedFWD WET AREA FLOORBOARD HAS CORRODED INSERTS. REMOVED AND REPLACED THE INSERTS.SDR SCNA20160904114Insert · corrodedFWD WET AREA FLOORBOARD HAS CORRODED INSERTS. REPAIRED THE FLOORBOARD.SDR SCNA20160904113Insert · corrodedFWD WET AREA FLOORBOARD HAS CORRODED INSERTS. REPAIRED THE FLOORBOARD.SDR SCNA20160904112Floor Support · damagedFLOOR SUPPORT BETWEEN BS 294.5 - 312, LBL 11 HAS A SCRIBE LINE. REPLACED THE FLOOR SUPPORT.SDR SCNA20160904111Bracket · crackedR2 DOOR AFT SWEEPER SEAL BRACKET IS CRACKED. REMOVED AND REPLACED SEAL BRACKET.SDR SCNA20160904110Bracket · crackedL2 DOOR PANEL 834DZ, SUPPORT BRACKET CRACKED. REMOVED AND REPLACED THE BRACKET.
Back to Boeing 737-7Q8