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 ASAA024014XSupport · corrodedDURING C-CHECK, FOUND CORROSION ON FLOOR TO SIDEWALL SUPPORT AT FASTENER HOLES AT BS 947.5, LBL 20 - RBL 20 AND 148. REPAIRED IAW SRM. (M)SDR ASAA02401ABFlap Track · wornPAE - DURING C-CHECK, FOUND LEFT OUTBOARD FOR FLAP TRACKS ARE WORN INBOARD TRACK. REPAIRED IAW SRM. (M)SDR ASAA02401AAStructure · chafedPAE - DURING C-CHECK, FOUND WEB OUTBOARD OF RIGHT PYLON IN AFT FLAP WELL IS CHAFED. REPAIRED IAW SRM. (M)SDR ASAA2003BStringer Clip · gougedDURING C-CHECK, FOUND DAMAGE ON STRINGER CLIP AT BS 767, STRINGER 26R AND WL 146. REPAIRED IAW SRM. (M)SDR ASAA02003AAngle · chafedDURING C-CHECK, FOUND NR 2 ENGINE PYLON CUTOUT FOR INBOARD FLAP UPPER ANGLE WORN 20 INCHES FROM FORWARD EDGE OF CUT OUT. REPAIRED IAW SRM. (M)SDR ASAA0240134AFloor Support · corrodedPAE - DURING C-CHECK, FOUND CORROSION ON FLOOR SUPPORT AT BS 860, RBL 8 AND WL 148. REPAIRED IAW SRM. (M)SDR ASAA0240CCCFailsafe · corrodedDURING C-CHECK, FOUND CORROSION ON FAILSAFE AT BS 767 STRINGER 27L-27R AND WL 148. REPAIRED IAW SRM. (M)SDR ASAA0240125Wire · looseSEA - DURING SERVICE CHECK, FOUND EMERGENCY FLOOR TRACK LIGHT INOPERATIVE AT ROW 17. REATTACHED WIRE, OPERATIONAL CHECKED GOOD, RELEASED. (M)SDR ASAA0340114Floor Support · corrodedDURING C-CHECK, FOUND CORROSION ON TOP OF FLOOR SUPPORT BS 773 RBL 13 WL 152. REPAIRED IAW SRM. (M)SDR ASAA0340113Support · corrodedPAE - DURING C-CHECK, FOUND CORROSION ON FLOOR TO SIDEWALL SUPPORT IN AFT CARGO BAY. REPAIRED IAW SRM. (M)SDR ASAA0340112Angle · crackedPAE - DURING C-CHECK, FOUND NR 2 PYLON OUTBOARD ATTACK ANGLE CRACKED. REPAIRED IAW SRM. (M)SDR ASAA0340116Support · corrodedDURING C-CHECK, FOUND CORROSION ON TOP OF FLOOR TO SIDEWALL SUPPORT AT BS 727 TO BS 767. REPAIRED IAW SRM. (M)SDR ASAA0340117Shear Tie · corrodedDURING C-CHECK, FOUND CORROSION AT SHEAR TIE AT BS 787 RBL 18 AND WL 156. REPAIRED IAW SRM. (M)SDR ASAA0340115Angle · corrodedDURING C-CHECK, FOUND CORROSION ON FLOOR TO BULKHEAD SUPPORT ANGLE. REPAIRED IAW SRM. (M)SDR ASAA0340110Web · corrodedDURING C-CHECK, FOUND CORROSION ON DOOR FRAME CLOSE OUT WEB AT BS 847 WL 156 AND RBL 24. REPAIRED IAW SRM. (M)SDR ASAA0340109Beam · corrodedPAE - DURING C-CHECK, FOUND CORROSION ON THRESHOLD BEAM FROM BS 795-846 RBL 21 AND WL 153. REPAIRED IAW SRM. (M)SDR ASAA0340108Web · corrodedDURING C-CHECK, FOUND WEB AT BS 847-867 WL 16 AN RBL 18 HAS CORROSION DAMAGE. REPAIRED IAW SRM. (M)SDR ASAA0340107Strap · corrodedDURING C-CHECK, FOUND CORROSION ON STRAP AT BS 839-859 WL 160 AND RBL 19. REPAIRED IAW SRM. (M)SDR ASAA0340106Strap · corrodedDURING C-CHECK, FOUND CORROSION ON THRESHOLD STRAP AT BS 847-860 RBL 20 AND WL 155. REPAIRED IAW SRM. (M)SDR ASAA0340105Angle · crackedDURING C-CHECK, FOUND CRACKED INBOARD UPPER RIGHT WING TRAILING EDGE PANEL INBOARD SUPPORT ANGLE AFT END. REPAIRED IAW SRM. (M)SDR ASAA0340104Angle · crackedDURING C-CHECK, FOUND RT AC BAY RAM AIR INLET PLENUM ANGLE CRACKED. REPAIRED IAW SRM. (M)SDR ASAA0340102Shear Tie · corrodedDURING C-CHECK, FOUND CORROSION ON SHEAR TIE AT BS 727F RBL 10 AND WL 159. REPAIRED IAW SRM. (M)SDR ASAA0340101Shear Tie · corrodedDURING C-CHECK, FOUND CORROSON ON SHEAR TIE BS 727F LBL 4 AND WL 158. REPAIRED IAW SRM. (M)SDR ASAA0340098Intercostal · corrodedPAE - DURING C-CHECK, FOUND UPPER FLANGE OF INTERCOSTAL AT BS 867-877 WL 156 AND RBL 23 CORRODED. REPAIRED IAW SRM. (M)SDR ASAA0340111Intercostal · corrodedPAE - DURING C-CHECK, FOUND CORROSION ON UPPER FLANGE OF INTERCOSTAL AT BS 847-867 WL 156 AND RBL 22. REPAIRED IAW SRM. (M)SDR ASAA0340103Shear Tie · corrodedPAE - DURING C-CHECK, FOUND CORROSION ON SHEAR TIE AT BS 767 RBL 13 AND WL 160. REPAIRED IAW SRM. (M)SDR ASAA0340100Shear Tie · corrodedPAE - DURING C-CHECK, FOUND CORROSION ON SHEAR TIE BS 727E RBL 11 AND EL 159. REPAIRED IAW SRM. (M)SDR ASAA0340099Shear Tie · corrodedPAE - DURING C-CHECK, FOUND CORROSION ON SHEAR TIE AT BS 727D RBL 1 AND WL 159. REPAIRED IAW SRM. (M)SDR ASAA0340087Keelbeam · corrodedDURING C-CHECK, FOUND CORROSION ON RT KEELBEAM AT BS 500G PLUS 3. REPAIRED IAW SRM. (M)SDR ASAA0340088Floor Support · corrodedDURING C-CHECK, FOUND CORROSION ON TOP FO FLOOR TO SIDEWALL SUPPORT BS 727 LBL 21. REPAIRED IAW SRM. (M)SDR ASAA0340089Support Fitting · corrodedPAE - DURING C-CHECK, FOUND CORROSION ON TOP OF FLOORBEAM TO SIDEWALL SUPPORT AT BS 727E PLUS 8. REPAIRED IAW SRM. (M)SDR ASAA0340085Channel · corrodedDURING C-CHECK, FOUND CORROSION ON NR 3 VHF ANTENNA CHANNEL. REPAIRED IAW SRM. (M)SDR ASAA0340086Cargo Track · corrodedDURING C-CHECK, FOUND CORROSION ON CARGO TIE DOWN FITTING. REPAIRED IAW SRM. (M)SDR ASAA0340091Shear Tie · corrodedDURING C-CHECK, FOUND CORROSION AT BASE OF SHEAR TIE AT BS 727D RBL 8 AND WL 159. REPAIRED IAW SRM. (M)SDR ASAA0340090Support · corrodedDURING C-CHECK, FOUND CORROSION ON TOP OF FLOOR TO SIDEWALL SUPPORT BS 747-767 RBL 21 TO WL 158. REPAIRED IAW SRM. (M)SDR ASAA0340084Floor Support · corrodedDURING C-CHECK, FOUND CORROSION ON TOP OF FLOOR SUPPORT BS 773 RBL 8 WL 152. REPAIRED IAW EA. (M)SDR ASAA0340092Shear Tie · corrodedDURING C-CHECK, FOUND CORROSION AT BASE OF SHEAR TIE BS 827 LBL 2 AND WL 158. REPAIRED IAW SRM. (M)SDR ASAA0340094Shear Tie · corrodedPAE - DURING C-CHECK, FOUND CORROSION AT BASE OF SHEAR TIE AT BS 727B RBL 1 AND WL 159. REPAIRED IAW SRM. (M)SDR ASAA0340097Shear Tie · corrodedDURING C-CHECK, FOUND CORROSION AT BASE OF SHEAR TIE BS 727B RBL 11 AND WL 159. REPAIRED IAW SRM. (M)SDR ASAA0340096Shear Tie · corrodedDURING C-CHECK, FOUND CORROSION AT BASE OF SHEAR TIE AT BS 727D LBL 2 AND WL 159. REPAIRED IAW SRM. (M)SDR ASAA0340095Shear Tie · corrodedPAE - DURING C-CHECK, FOUND CORROSION AT BASE OF SHEAR TIE BS 727C RBL 9 AND WL 159. REPAIRED IAW SRM. (M)SDR ASAA0340093Shear Tie · corrodedDURING C-CHECK, FOUND CORROSION AT BASE OF THE SHEAR TIE AT BS 727B LBL 2 AND WL 159. REPAIRED IAW SRM. (M)SDR ASAA0340083Web · corrodedDURING C-CHECK, FOUND CORROSION ON TOP OF FLOOR TO SIDEWALL WEB AT BS 847 TO 867. REPAIRED IAW SRM. (M)SDR ASAA0340082Floor Support · corrodedDURING C-CHECK, FOUND CORROSION ON FLOOR TO SIDEWALL SUPPORT AT BS 867 TO BS 487 RBL 21 AND WL 152. REPAIRED IAW SRM. (M)SDR ASAA0340081Threshold · corrodedDURING C-CHECK, FOUND CORROSION ON SUB THRESHOLD AT RBL 23 AND WL 155. REPAIRED IAW SRM. (M)SDR ASAA0340080Frame · corrodedDURING C-CHECK, FOUND CORROSION ON FRAME BS 500C RBL 5 AND WL 148. REPAIRED IAW SRM. (M)SDR ASAA0340079Frame · corrodedDURING C-CHECK, FOUND CORROSION ON FRAME BS 500B LBL5 RBL 5 AND WL 148. REPAIRED IAW SRM. (M)SDR ASAA0340070Intercostal · corrodedDURING C-CHECK, FOUND CORROSION ON INTERCOSTAL AT BS 727A-B AND RBL 3 WL 159. REPAIRED IAW SRM. (M)SDR ASAA0340078Frame · corrodedPAE - DURING C-CHECK, FOUND CORROSION ON FRAME AT BS 500D RBL 5 AND WL 148. REPAIRED IAW SRM. (M)SDR ASAA0340077Frame · corrodedPAE - DURING C-CHECK, FOUND CORROSION ON FRAME AT BS 500E LBL 5, RBL 5 AND WL 148. REPAIRED IAW SRM. (M)
Back to Boeing 737-4Q8