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 ASAA1048069Frame · gougedAFT PIT FRAME GOUGED BETWEEN STR 24R 25R. CUT OUT DAMAGED AREA, FABRICATED AND INSTALLED DOUBLER.SDR ASAA1048068Shear Tie · damagedSHEAR TIE DAMAGED WITH OVERSIZED HOLES. REMOVED SHEAR TIE, FABRICATED AND INSTALLED NEW SHEAR TIE.SDR ASAA1048067Shear Tie · damagedSHEAR TIE DAMAGED WITH OVERSIZED HOLES. REMOVED SHEAR TIE, FABRICATED AND INSTALLED NEW SHEAR TIE.SDR ASAA1048066Shear Tie · damagedSHEAR TIE DAMAGED WITH OVERSIZED HOLES. REMOVED SHEAR TIE, FABRICATED AND INSTALLED NEW SHEAR TIE.SDR ASAA1048065Shear Tie · damagedSHEAR TIE DAMAGED WITH OVERSIZED HOLES. REMOVED SHEAR TIE, FABRICATED AND INSTALLED NEW SHEAR TIE.SDR ASAA1048071Skin · dentedLEFT NR 3 FLIGHT PANEL HAS A DENT ON LOWER SKIN. REPAIRED NR 3 SPOILER.SDR ASAA1048029Roller · lack of lubeFLIGHT ATTENDANT REPORTS L1 DOOR HARD TO CLOSE, FWD ENTRY DOOR FAILS THE OPEN TEST REF AMM 52 11 00 755 051 PG 2 PARA 5 [C] ,1 DOOR DOES NOT OPEN AT 600 IN LBS OR LESS [62572]. LUBE DOOR AND ROLLERS AND HINGES REF 52 11 00 705 PGS 1 THRU 8. ALSO TORQUE WAS BSDR KNNA9160702KMIATire · separatedFLIGHT CREW - DURING POST FLIGHT INSPECTION NR 2 TIRE TREAD CAME OFF, SUBSEQUENT DAMAGE (PUNCTURE) TO AIRCRAFT LEFT FLAP.SDR ASAA1048003Rod End · out of adjustL2 DOOR DOES NOT CLOSE PROPERLY UPPER FWD LATCH ROLLER DOES NOT ENGAGE PLATE UNLESS DOOR IS PUSHED UP. ADJUSTED L2 DOOR HANDLE MECHANISM ROD END REF AMM 52 13 00 705 001, OPERATIONAL CHECKED NORMAL REF AMM 52 13 00 705 034.SDR ASAA1048002Control Rod · out of adjustL1 DOOR HARD TO CLOSE. ADJUSTED UPPER AND LOWER LATCH ROLLER CONTROL RODS AND LOWER GATE CONTROL ROD. REF AMM 52 11 00 705 007.SDR ASAA1047933Skin · dentedLT INBOARD FORE FLAP LOWER SURFACE HAS MULTIPLE MINOR DENTS BETWEEN INBOARD AND CNT TRACKS. REMOVED DAMAGED AREA AND BONDED REPAIR.SDR ASAA1047932Skin · dentedA CLUSTER OF 3 DENTS AND 6 PROTRUDING DENTS AT 913 JUST ABOVE REPAIR DOUBLER. REPAIRED FUSELAGE SKIN.SDR ASAA1047943Skin · dentedLEFT I/B TRAILING EDGE AFT FLAP CLUSTER OF DENTS ON UPPER SURFACE. REMOVED DAMAGED SKIN SECTION, FABRICATED FILLER AND DOUBLER AND BONDED.SDR ASAA1047942Skin · dentedFUSE LT EXTERIOR SKIN DENTED OUT OF LIMITS. REMOVED DAMAGED SKIN SECTION, FABRICATED SKIN BONDED DOUBLER AND INSTALLED.SDR BJNA100602Wire · brokenRT FWD EMERGENCY EXIT HATCH EXIT SIGN WILL NOT ILLUMINATE. REPAIRED BROKEN WIRE AS REQUIRED. OPS CK NORMAL.SDR ASAA1047913Skin · delaminatedLT INBOARD AFT FLAP LOWER SURFACE HAS AREAS OF DELAMINATION. REMOVED DAMAGE AND BONDED REPAIR.SDR ASAA1047887Skin · dentedLT FUSELAGE EXTERNAL SKIN DENTED APPROX STA 490 BELOW STR L16. CUT OUT DAMAGED AREA, FABRICATED REPAIR DOUBLER, FILLER AND INSTALLED.SDR ASAA1047833Shear Tie · damagedAFT LT SHEAR TIE HAS 2 CREASES. REMOVED WEB FABRICATED AND INSTALLED NEW WEB.SDR ASAA1047835Web · corrodedWEB AT LBL 55 AT STA 966 CORRODED. REMOVED WEB FABRICATED AND INSTALLED NEW WEB.SDR ASAA1047937Spar · delaminatedRUDDER FRONT IS DELAMINATED AT RUDDER STA 17.25. CUT OUT DAMAGED AREA AND BONDED REPAIR.SDR ASAA1047912Skin · crackedA .900 INCH CRACK EMANATING FROM LOWER HINGE CUTOUT ON FWD GALLEY SERVICE DOOR. CUT OUT DAMAGED AREA, FABRICATED AND INSTALLED REPAIR DOUBLER AND TRIPLER.SDR ASAA1047791Door · defectiveF/A REPORTS R2 DOOR DIFFICULT TO CLOSE. REMOVED OLD DOOR AND INSTALLED SERVICEABLE DOOR RIGGED AND OPS TESTED GOOD REF MM 52 41 00 404 012 STEP F [1] THRU F [9] D.SDR ASAA1047783Guide Arm · out of adjustL1 DOOR IS HARD TO CLOSE. ADJUSTED L1 ENTRY DOOR GUIDE ARM PER AMM 52 11 00 705 007 STEP G (1) (2) (A)(B)(C). PERFORMED L1 ENTRY DOOR TEST PER AMM 52 11 00 755 051. DOOR TEST GOOD.SDR ASAA1047955Frame · crackedFRAME CRACKED AT STA 500C. REMOVED DAMAGE AND INSTALLED NEW FRAME REPAIR.SDR ASAA1047931Frame · crackedFRAME CRACKED AT STA 500C BETWEEN 8L & 9L. REMOVED RIVET PLUGS AND CUTOUT DAMAGE INSTALLED FRAME REPAIR.SDR ASAA1047967Web · damagedCABIN FLOOR WEB DAMAGED FASTENER HOLES AFT OF FLOORBEAM. REMOVED DAMAGE AREA, INSTALLED NEW WEB.SDR ASAA1047966Web · damagedCABIN FLOOR WEB DAMAGED FASTENER HOLES AFT OF FLOORBEAM. REMOVED DAMAGE AREA, INSTALLED NEW WEB.SDR ASAA1047832Sill · corrodedR2 THRESHOLD MOP SEAL HAS SEVERAL AREAS OF CORROSION. REMOVED MOP SILL AND INSTALLED NEW MOP SILL.SDR ASAA1047953Sill · corrodedCABIN FLOOR STR RT STA 500 ON MOP SILL. REMOVED AND INSTALLED NEW MOP SILL.SDR ASAA1047911Floorbeam · corrodedAFT CABIN FLOORBEAM STA 967 HAS AREA OF CORROSION. CUT OUT DAMAGED AREA, FABRICATED AND INSTALLED FLOORBEAM REPAIR.SDR ASAA1047834Shear Tie · corrodedAFT PIT SHEAR TIE STA 727G CORRODED. REMOVED SHEAR TIE FABRICATED AND INSTALLED NEW SHEAR TIE.SDR ASAA1047939Skin · gougedGOUGE IN FUSELAGE SKIN. CUT OUT DAMAGED AREA, FABRICATED REPAIR PARTS AND INSTALLED.SDR ASAA1047841Floor Support · corrodedAFT PIT FLOOR SUPPORT CORRODED STA 860 CUTOUT DAMAGED AREA FABRICATED AND INSTALLED JOGGLE REPAIR.SDR ASAA1047840Floor Support · corrodedAFT PIT FLOOR SUPPORT CORRODED AT JOGGLE BETWEEN STA 727D CUTOUT DAMAGED AREA FABRICATED AND INSTALLED JOGGLE REPAIR.SDR ASAA1047839Floor Support · corrodedAFT PIT FLOOR SUPPORT CORRODED AT JOGGLE RBL 3 STA 727. CUTOUT DAMAGED AREA FABRICATED AND INSTALLED JOGGLE REPAIR.SDR ASAA1047838Floor Support · corrodedFLOOR SUPPORT CORRODED AT RBL 3 STA 727 O. CUTOUT DAMAGED AREA FABRICATED AND INSTALLED JOGGLE REPAIR.SDR ASAA1047837Floor Support · corrodedAFT PIT FLOOR SUPPORT CORRODED AT LBL 8 JOGGLE. CUTOUT DAMAGED AREA FABRICATED A AND INSTALLED JOGGLE REPAIR.SDR ASAA1047983Shear Tie · corrodedAFT CARGO COMPARTMENT SHEAR TIE CORRODED FWD SIDE OF FS 807. INSTALLED REPAIR ANGLE.SDR ASAA1047969Stringer · corrodedAPU COMPARTMENT RT STRINGER ABOVE AIRNET CUTOUT IS CORRODED. REMOVED AND REPLACED STRINGER.SDR ASAA1047957Frame · corrodedAFT CARGO PIT FRAME CORRODED. REMOVED DAMAGE AREA INSTALLED REPAIR.SDR ASAA1047956Intercostal · corrodedAFT PIT INTERCOSTAL CORRODED STA 767. REMOVED DAMAGE INTERCOSTAL INSTALLED NEW.SDR ASAA1047954Intercostal · corrodedAFT CARGO PIT INTERCOSTAL SUPPORT BRACKET CORRODED. REMOVED DAMAGED INTERCOSTAL AND INSTALLED NEW.SDR ASAA1047947Skin · dentedLEFT I/B AFT FLAP L/E IS DENTED 24 INCHES IN O/B OF I/B END. REMOVED DAMAGED AREA, INSTALLED REPAIR.SDR ASAA1047946Seat Track · crackedCABIN FLOOR T-CHORD UNDER O/B LEFT SEAT TRACK CRACKED AT FASTENER HOLE. CUT OUT DAMAGED AREA, INSTALLED REPAIR.SDR ASAA1047945Floorbeam · corrodedCABIN FLOORBEAM CORRODED AROUND FASTENER HOLES AT PREVIOUS REPAIR. REMOVED EXISTING UPPER T-CHORD REPAIR, INSTALLED NEW CHORD AND REPAIR PARTS.SDR ASAA1047944Sill · corrodedL2 ENTRY DOOR MOP SILL HAS CORROSION. INSTALLED NEW MOP SILL.SDR ASAA1047836Intercostal · crackedINTERCOSTAL STA 288 IS CRACKED. REMOVED INTERCOSTAL FABRICATED AND INSTALLED NEW INTERCOSTAL.SDR ASAA1047959Frame · gougedCABIN FRAME GOUGED. REMOVED DAMAGE AREA, INSTALLED REPAIR.SDR ASAA1047958Frame · gougedCABIN FRAME GOUGED. REMOVED DAMAGE AREA, INSTALLED REPAIR.SDR ASAA1047948Frame · chafedFRAME AT STA 559 IS CHAFED. REMOVED DAMAGED AREA, INSTALLED REPAIR.
Back to Boeing 737-4Q8