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 ASAA02402NNFrame · corrodedDURING C-CHECK, FOUND CORRODED FRAME AT BS 500. REPAIRED IAW SRM. (M)SDR ASAA02401DDSkin · chafedDURING C-CHECK, FOUND SKIN HAS AREAS OF CHAFING DAMAGE AT THE LEFT AFT LOWER SLIDE SEAL AT BS 1154. REPAIRED IAW SRM. (M)SDR ASAA02402CCThreshold · corrodedDURING C-CHECK, FOUND AFT CARGO DOOR CUTOUT THRESHOLD WEB IS CORRODED. REPAIRED IAW SRM. (M)SDR ASAA02402BBSkin · dentedDURING C-CHECK, FOUND LEFT HORIZONTAL STAB LE HAS DENT AT 91 IN OUTBOARD FROM REMOVEABLE LE SKIN INBOARD END. REPAIRED IAW SRM. (M)SDR ASAA02402AASupport · corrodedPAE - DURING C-CHECK, FOUND FLOOR TO SIDEWALL SUPPORT FROM BS 727E PLUS 14, 835 IS CORRODED. REPAIRED IAW SRM. (M)SDR ASAA0240216Support Angle · corrodedPAE - DURING C-CHECK, FOUND FORWARD CARGO BAY FLOOR TO AFT BULKHEAD SUPPORT ANGLE HAS CORROSION AT NUT PLATES. REPAIRED IAW SRM. (M)SDR ASAA0240198Skin · chafedDURING C-CHECK, FOUND EMPENNAGE SKIN HAS CHAFING DAMAGE AT RIGHT LOWER AFT HORIZONTAL STAB SEAL. REPAIRED IAW SRM. (M)SDR ASAA02401PPSupport · corrodedDURING C-CHECK FOUND FLOOR SUPPORT WEB IS CORRODED FROM BS 814-847. REPAIRED IAW SRM. (M)SDR ASAA02401MMFrame · corrodedDURING C-CHECK, FOUND CORRODED FRAME AT BS 500B. REPAIRED IAW SRM. (M)SDR ASAA02401LLStringer Clip · corrodedDURING C-CHECK, FOUND STRINGER CLIP CORRODED AT BS 787. REPAIRED IAW SRM. (M)SDR ASAA024018DFrame · corrodedPAE - DURING C-CHECK, FOUND CORROSION ON FRAME AT 747 AND WL 148. REPAIRED IAW SRM. (M)SDR ASAA024018CShear Tie · corrodedPAE - DURING C-CHECK, FOUND CORROSION ON SHEAR TIE AT BS 727B LBL 4 - RBL 4 AND WL 148. REPAIRED IAW SRM. (M)SDR ASAA024018BAngle · crackedPAE - DURING C-CHECK, FOUND LEFT SKATE ANGLES FOR RAM AIR PLENUM CRACKED AT FORWARD END. REPAIRED IAW SRM. (M)SDR ASAA024018ATrim Panel · corrodedPAE - DURING C-CHECK, FOUND AFT CARGO BAY CORROSION ON FLOOR TRIM PIECE AT STATION 794, RBL 17 AND WL 157. REPAIRED IAW SRM. (M)SDR ASAA2004BBBSupport · corrodedPAE - DURING C-CHECK, FOUND AFT CARGO BAY FLOOR TO SIDE WALL SUPPORT IS CORRODED AT STATION 727-767, RBL 25, AND WL 158. REPAIRED IAW SRM. (M)SDR ASAA2004AAAStrap · corrodedPAE - DURING C-CHECK, FOUND CORROSION ON STRAP AT BS 794, RBL 20 AND WL 148. REPAIRED IAW SRM. (M)SDR ASAA0240ZZZDoor Frame · corrodedDURING C-CHECK, FOUND AFT CARGO DOOR CUT OUT FORWARD FRAME CLOSE OUT PANEL HAS CORROSION AT BS 794, RBL 38 AND WL 161. REPAIRED IAW SRM. (M)SDR ASAA0240AAAWeb · corrodedPAE - DURING C-CHECK, FOUND CORROSION ON WEB INSIDE AFT CARGO DOOR AT BS 847, RBL 21 AND WL 148. REPAIRED IAW SRM. (M)SDR ASAA024017DStrap · corrodedPAE - DURING C-CHECK, FOUND CORROSION ON STRAP UNDER SUB THRESHOLD FRAME AT BS 840-860. REPAIRED IAW SRM. (M)SDR ASAA0240174Floor Support · corrodedPAE - DURING C-CHECK, FOUND CORROSION ON FLOOR SUPPORT AT BS 727 PLUS 12 TO 867. REPAIRED IAW SRM. (M)SDR ASAA204CCCIntercostal · corrodedPAE - DURING C-CHECK, FOUND CORROSION ON INNERCOSTAL AT BS 787-794. REPAIRED IAW SRM. (M)SDR ASAA0240172Skin · damagedDURING C-CHECK, FOUND DAMAGE UNDER FRAME FLANGE AT BS 847. REPAIRED IAW EA. (M)SDR ASAA0240176Doubler · corrodedDURING C-CHECK, FOUND CORROSION ON FRAME INNER DOUBLER AT BS 794. REPAIRED IAW SRM. (M)SDR ASAA0240BBBStrap · corrodedDURING C-CHECK, FOUND CORROSION ON STRAP UNDER FRAME AT BS 794. REPAIRED IAW EA. (M)SDR ASAA024016GSupport · corrodedPAE - DURING C-CHECK, FOUND CORRSION ON FLOOR TO SIDEWALL SUPPORT AT BS 727F TO 837. REPAIRED IAW SRM. (M)SDR ASAA024016XIntercostal · corrodedPAE - DURING C-CHECK, FOUND CORROSION ON INTERCOSTAL AT BS 860. REPAIRED IAW SRM. (M)SDR ASAA0240163Intercostal · corrodedPAE - DURING C-CHECK, FOUND CORROSION ON INTERCOSTAL AT BS 852. REPAIRED IAW SRM. M)SDR ASAA0240168Shelf · crackedPAE - DURING C-CHECK, FOUND RADAR TRANSCEIVER SHELF IS CRACKED BELOW AFT END OF LEFT MOUNT CHANNEL. REPAIRED IAW SRM. (M)SDR ASAA024016PBeam · corrodedPAE - DURING C-CHECK,FOUND CORROSION ON AFT CARGO DOOR SUB THRESHOLD BEAM AT BS 794-847. REPAIRED IAW SRM. (M)SDR ASAA0240164Support · corrodedPAE - DURING C-CHECK, FOUND CORROSION ON FLOOR TO SIDEWALL SUPPORT AT BS 847-867. REPAIRED IAW SRM. (M)SDR ASAA0240166Channel · crackedPAE - DURING C-CHECK, FOUND RADAR MOUNT SHELF CHANNEL IS CRACKED AT BS 204. REPAIRED IAW SRM. (M)SDR ASAA0240165Intercostal · crackedPAE - DURING C-CHECK, FOUND CRACKED INTERCOSTAL AT BS 787-794. REPAIRED IAW SRM. (M)SDR ASAA024015CIntercostal · crackedPAE - DURING C-CHECK, FOUND CRACKED INTERCOSTAL AT BS 747-767, RBL 20 AND WL 156. REPAIRED IAW SRM. (M)SDR ASAA024017BWeb · corrodedPAE - DURING C-CHECK, FOUND CORROSION ON WEB AT BS 767-794. REPAIRED IAW SRM. (M)SDR ASAA024017AIntercostal · corrodedPAE - DURING C-CHECK, FOUND CORROSION ON INTERCOSTAL AT BS 767-787. REPAIRED IAW SRM. (M)SDR ASAA024016ASupport · corrodedPAE - DURING C-CHECK, FOUND FLOOR TO SIDEWALL SUPPORT IS CORRODED AT BS 727-727F. REPAIRED IAW SRM. (M)SDR ASAA024015RFrame · dentedPAE - DURING C-CHECK, FOUND DENT ON FRAME AT BS 727F, RBL 22 AND WL 158. REPAIRED IAW SRM. (M)SDR ASAA0240157Intercostal · corrodedPAE - DURING C-CHECK, FOUND CORROSION ON INTERCOSTAL AT BS 727A-B, RBL 20 AND WL 156. REPAIRED IAW SRM. (M)SDR ASAA024015FFrame · gougedPAE - DURING C-CHECK, FOUND GOUGE ON FRAME AT BS 807, RBL 4 AND WL 152. REPAIRED IAW SRM. (M)SDR ASAA024015BFrame · corrodedPAE - DURING C-CHECK, FOUND CORROSION ON FRAME AT BS 807, LBL 5 TO RBL 5 AND WL 148. REPAIRED IAW SRM. (M)SDR ASAA024015AFrame · corrodedPAE - DURING C-CHECK, FOUND CORROSION ON FRAME AT BS 727E RBL 8-12 AND WL 148. REPAIRED IAW SRM. (M)SDR ASAA024014TAngle · crackedDURING C-CHECK, FOUND FORWARD ENTRY DOOR LOWER AFT SUPPORT ANGLE CRACKED. REPAIRED IAW SRM. (M)SDR ASAA0240150Skin · chafedPAE - DURING C-CHECK, FOUND LEFT WING INBOARD EXHAUST GATE UPPER SKIN IS CHAFED ON FORWARD OUTBOARD EDGE. REPAIRED IAW SRM. (M)SDR ASAA024015GDoubler · corrodedDURING C-CHECK, FOUND CORROSION AT BS 727D PLUS 2-12, RBL 0 WL 148 ON ANTENNA DOUBLER. REPAIRED IAW SRM. (M)SDR ASAA024014MShear Tie · corrodedDURING C-CHECK, FOUND CORROSION ON SHEAR TIE AT BS 500F BETWEEN STRINGER 26 AND 27 RT. REPAIRED IAW SRM. (M)SDR ASAA0240148Frame · corrodedDURING C-CHECK, FOUND CORROSION ON FRAME AT BS 827, LBL 10 - RBL 4 AND WL 142. REPAIRED IAW SRM. (M)SDR ASAA024014LFrame · corrodedDURING C-CHECK, FOUND CORROSION ON FRAME AT BS 727F, RBL 17 AND WL 148. REPAIRED IAW SRM. (M)SDR ASAA024014KFrame · corrodedDURING C-CHECK, FOUND CORROSION ON FRAME AT BS 727F, RBL 9.5 AND WL 148. REPAIRED IAW SRM. (M)SDR ASAA0240146Shear Tie · corrodedPAE - DURING C-CHECK, FOUND CORROSION ON SHEAR TIE FLANGE AT STATION 727D STRINGER 26-27R. REPAIRED IAW SRM. (M)SDR ASAA024015JSupport · corrodedDURING C-CHECK, FOUND CORROSION ON SIDEWALL SUPPORT AT BS 727G BL 23. REPAIRED IAW SRM. (M)
Back to Boeing 737-4Q8