Boeing 737-8Q8
Service difficulty reports · 1,686
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 = '7378Q8' 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 = '7378Q8' 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 SCNA20170201006Window Frame · crackedFLT DECK R1 WINDOW FRAME CRACKED AFT POST AT INBD TOP ATTACH FASTENER HOLE TO NR 2 WINDOW FRAME. REPAIRED THE WINDOW FRAME.SDR SCNA20170201005Window Frame · crackedR1 WINDOW OUTBOARD UPPER CORNER CRACKED, REPAIRED.SDR SCNA20170201004Window Frame · crackedLEFT NR 1 WINDOW OUTBOARD UPPER CORNER CRACKED, REPAIRED.SDR SCNA20170201003Tab · damagedLEFT AILERON TAB HAS EXPOSED COMPOSITE. REMOVED AND REPAIRED THE LEFT AILERON TAB TO FACILITATE THE REPAIR. OPS CHECKED GOOD, NO ADJUSTMENTS WERE REQUIRED.SDR SCNA20170201002Lens · brokenEMERGENCY EXIT LIGHT HOUSING AND LOOK DOWN LIGHT/LENS ABOVE L1 DOOR BROKEN. REMOVED AND REPLACED EMERGENCY EXIT LIGHT HOUSING AND LOOK DOWN LIGHT LENSE ABOVE L1 DOOR. OP CHECKED GOOD.SDR ASMF201702002Actuator · failedAIRCRAFT RETURNED TO GATE DUE TO THE LEFT ENGINE AT START AN CONTROL LIGHT TURNED ILLUMINATED. PERFORMED A BITE TO THE LEFT EEC IAW AMM 73-21-00, SHOWING FAILURE CODE 73-31481. THE LEFT REVERSER SLEEVE POSITION SIGNAL OUT OF RANGE. THE LEFT REVERSER ACTUATOSDR SCNA20161231415Frame · gougedRIGHT SIDE FRAME 951 INNER CHORD FWD SURFACE HAS A GOUGE. RT FRAME 951 MAIN PASSENGER CABIN INNER CHORD FWD SURFACE REPAIRED.SDR SCNA20161231414Crease Beam · corrodedCREASE BEAM WEB BETWEEN FRAMES 927 TO 947 RIGHT SIDE HAS SEVERAL SPOTS OF CORROSION ON THE SURFACE AND IN THE FASTENER HOLES. FABRICATED NEW WEB BETWEEN FRAMES 927 TO 947 IN PASSENGER RT SIDE.SDR SCNA20161231413Seal · wornHORIZONTAL STAB PANEL 343AB, METAL SEALS WORN. REMOVED RT SIDE HORIZONTAL STAB PANEL 343AB METAL SEALS AND INSTALLED NEW SEALS.SDR SCNA20161231411Fastener · damagedVERTICAL STABILIZER LEADING EDGE NEEDS ATTACHING HARDWARE REPLACED. REPLACED DAMAGE OR MISSING HARDWARE ON VERTICAL STABILIZER LEADING EDGE.SDR SCNA20161231410Panel · wornRT WING LEADING EDGE PANEL 621CB HAS WEAR ON CORNERS. REPAIRED RT WING LEADING EDGE PANEL 621CB WEAR ON CORNERS.SDR SCNA20161231409Panel · wornRT WING PANEL 621KB HAS WEAR ON CORNERS. REPAIRED RT WING PANEL 621KB WEAR ON CORNERS.SDR SCNA20161231408Panel · wornRT WING PANEL 621 HB HAS WEAR ON CORNERS. REPAIRED RT WING PANEL 621 HB WEAR ON CORNERS.SDR SCNA20161231407Panel · crackedRT UPPER WING TO BODY PANEL 195CR CRACKED IN LOWER TRAILING EDGE BEND. REPAIRED RT WING TO BODY PANEL 195CR.SDR SCNA20161231406Nut Plate · damagedRIGHT SIDE HORIZ STAB PANEL 343DB HAS A BAD NUT PLATE. REPLACED NUTPLATE RT SIDE HORIZ STAB PNL 343DB.SDR SCNA20161231405Seal · wornRIGHT SIDE HORIZ STAB PANEL 343AB METAL SEAL WORN THROUGH. REMOVED RT SIDE HORIZ STAB PANEL 343AB METAL GAP SEALS AND INSTALLED NEW SEALS.SDR SCNA20161231404Structure · tornRIGHT SIDE HORIZ STAB PANEL 343AB FIN IS TORN. REPLACE FIN ON PANEL 343AB RT SIDE HORIZ STAB.SDR SCNA20161231403Floor Panel · damagedRT FWD WET AREA, R1 DOOR ENTRY FLOOR PANEL P/N 1415810-76 HAS SEVERAL DENTS ON TOP SURFACE AND HAS SCRIBE LINES. REPAIRED RT FWD WET AREA R1 ENTRY FLOOR PANEL P/N 1415810-76.SDR SCNA20161231402Floor Panel · damagedRT FWD WET AREA, FLOOR PANEL P/N 1415810-228 TOP SURFACE DELAM AND MISSING AN INSERT. REPAIRED FWD WET AREA FLOOR PANEL P/N 1415810-228 AND REPLACED MISSING INSERTS.SDR SCNA20161231401Floor Panel · damagedRT FWD WET AREA, FLOOR PANEL P/N 1415810-141 FWD O/B INSERT HOLE DAMAGED AND INSERT MISSING, AND HAS SCRIBE LINES ON TOP SURFACE. REPAIRED RT FWD WET AREA FLOOR PANEL P/N 1415810-141 AND REPLACED MISSING INSERT.SDR SCNA20161231400Floor Panel · damagedRT FWD WET AREA, FLOOR PANEL P/N 1415810-142 TOP SURFACE DELAM. REPAIRED RT FWD WET AREA FLOOR PNL P/N 14115810-142 DELAMINATION. REPLACED ALL PANEL INSERTS.SDR SCNA20161231399Floor Panel · damagedRT FWD WET AREA, FLOOR PANEL P/N 141A5810-160 TOP SURFACE DELAM AND MISSING AN INSERT. REPAIRED RT FWD WET AREA FLOOR PANEL P/N 11A5810-160.SDR SCNA20161231398Floor Panel · damagedRT FWD WET AREA, AFT FLOOR PANEL P/N 1415810-144 SCRIBE MARKS ON TOP SURFACE. REPAIRED RT FWD WET AREA FLOOR PANEL P/N 1415810-144.SDR SCNA20161231397Floor Panel · damagedFWD WET AREA, AFT CENTER FLOOR PANEL P/N 141A5810-147 TOP SURFACE DELAM. REPAIRED FWD WET AREA AFT CENTER FLOOR PANEL TOP SURFACE DELAM.SDR SCNA20161231396Floor Panel · damagedLT FWD WET AREA, FLOOR PANEL P/N 1415810-158 TOP SURFACE DELAM AND POTTING MATERIAL MISSING ALONG THE O/B AND AFT EDGE SECTION. REPAIRED LT FWD WET AREA FLOOR PANEL TOP SURFACE DELAM + MISSING POTTING MATERIAL ALONG OB + AFT EDGE.SDR SCNA20161231395Floor Panel · damagedLT FWD WET AREA, FLOOR PANEL P/N 141A5810-158 TOP SURFACE DELAM AND POTTING MATERIAL MISSING AT FWD EDGE SECTION. REPAIRED LT FWD WET AREA FLOOR PANEL TOP SURFACE DELAM + POTTING MATERIAL AT FWD EDGE.SDR SCNA20161231394Floor Panel · damagedLT FWD WET AREA, L1 DOOR ENTRY FLOOR PANEL P/N 1415810-159 AFT AND I/B CORNER SECTION DELAM AND HAS SEVERAL NUT INSERTS ARE CORRODED. REPAIRED LT FWD WET AREA L1 DOOR ENTRY FLOOR PANEL AFT + 1B CORNER SECTION DELAM + INSERTS REPLACED.SDR SCNA20161231393Floor Panel · damagedLT FWD WET AREA, AFT OF L1 DOOR FLOOR PANEL P/N 1415810-183 FWD O/B CORNER AND TOP SURFACE DELAM. REPAIRED LT FWD WET AREA AFT OF L1 DOOR FLOOR PANEL FORWARD O/B CORNER + TOP SURFACE DELAM.SDR SCNA20161231392Floor Panel · damagedFWD LAV FLOOR PANEL P/N 1415810-56 AFT O/B COMPOSITE IS BROKEN AND AFT EDGE SECTION MISSING POTTING MATERIAL, AN INSERT MISSING AND TOP SURFACE DELAM. REPAIRED FWD LAV FLOOR PANEL P/N 1415810-56 AND REPLACED MISSING INSERT.SDR SCNA20161231391Floorboard · brokenMAIN PASSENGER CABIN FLOORBOARD FWD SIDE BROKEN. REPAIRED THE FLOORBOARD.SDR SCNA20161231390Fitting · corrodedMAIN PASSENGER L1 DOOR FWD GIRT BAR FITTING CORRODED AT BS 312 LBL 64. REMOVED AND REPLACED THE GIRT BAR FITTING .SDR SCNA20161231389Insert · corrodedMAIN PASSENGER CABIN FWD FLOORBOARD HAS MULTIPLE INSERTS CORRODED. REMOVED AND REPLACED THE INSERTS.SDR SCNA20161231388Floorbeam · corrodedMAIN PASSENGER CABIN BS 986 LBL 12 TO LBL 64 FLOORBEAM TEE CORRODED IN MULTIPLE AREAS. REPAIRED THE FLOORBEAM.SDR SCNA20161231387Floorbeam · corrodedMAIN PASSENGER CABIN FLOORBEAM BS 986 CORRODED IN MULTIPLE AREAS BL 0 TO RBL 24. REPAIRED THE FLOORBEAM.SDR SCNA20161231386Structure · corrodedMAIN PASSENGER CABIN BS 947 RBL 59 UNDER AFT OUTBOARD LAV MOUNT CORRODED. REPAIRED MAIN PASSENGER CABIN STA 947 RBL 59.SDR SCNA20161231384Bracket · crackedR2 DOOR LOWER GATE PAN ASSY AFT BRACKET CRACKED. REMOVED AND REPLACED THE GATE BRACKET.SDR SCNA20161231383Bracket · crackedL2 DOOR LOWER GATE PAN ASSY FWD BRACKET CRACKED. REMOVED AND REPLACED THE AFT BRACKET.SDR SCNA20161231382Light · inoperativeLEFT SEAT ROW 7 AND 9 OVERHEAD BIN BULL NOSE'S TWO EMERGENCY LIGHTS ARE INOPERATIVE. REMOVED AND REPLACED EMERGENCY LIGHTS. OPS CHECKED GOOD.SDR SCNA20161228380Power Supply · inoperativeEMERGENCY EXIT LIGHT POWER SUPPLY M1694 AT BS 595, WL 213, LBL 68 IS INOPERATIVE. REPLACED POWER SUPPLY. OPS CHECK PERFORMED. OPS CHECK GOOD.SDR SCNA20161228379Fairing · crackedSTRUT 4 FAIRING NR 1 ENGINE CRACKED. INSTALLED NEW STRUT 4 FAIRING..SDR SCNA20161224378Slat System · malfunctionedNR 3 SLAT STAYED IN TRANSIT AFTER SELECTING FLAPS FIVE. ACP BITE OF FSEU WITH NO FAULTS FOUND. OPERATED FLAPS WITH NO FAULTS. OK FOR SERVICE. PERFORMED LEADING EDGE FLAP AND SLAT POSITION INDICATING SYSTEM TEST. NO FAULTS FOUND. PERFORMED FSEU BITE TEST. NOSDR SCNA20161223377Sensor · misinstalledON CLIMOUT IN HDG MODE AP ENGAGEMENT CAUSED A VIOLENT TURN TO THE RIGHT. DISCONECTED AP AND TRIED CMD A AGAIN WITH SAME RESULT. WE TRIED CMD B WITH SAME RESULT. DISCONECTED AP AND DID NOT ATTEMPT AGAIN. FOUND AILERON SENSOR INTALLED 180 OUT. TRANSFERD AND ACCSDR SCNA20161222376Skin · erodedVERTICAL STABILIZER LEADING EDGE COMPOSITE ERODED ON LOWER LEADING EDGE. EVALUATED, SEALED EXPOSED COMPOSITES AND RESTORED DECORATIVE FINISH ON VERTICAL STAB L/E COMPOSITE LOWER L/E.SDR SCNA20161222375Floorbeam · brokenMAIN PASSENGER CABIN BS 540 BL 0 TO RBL 24 PANEL BREAK FLOOR SUPPORT BROKEN. REMOVED AND REPLACED FLOOR SUPPORT.SDR SCNA20161222374Floorbeam · brokenMAIN PASSENGER CABIN BS 540, BL 0 TO LBL 24 PANEL BREAK FLOOR SUPPORT BROKEN. REMOVED AND REPLACED FLOOR SUPPORT.SDR SCNA20161222373Bulkhead Web · crackedLEFT BS 663 LBL 42 VERTICAL WEB CRACKED. REMOVED THE BULHEAD WEB. LOCATED, TRIMMED, ALL REPAIR PARTS. INSTALLED ALL REPAIR PARTS.SDR SCNA20161222372Seal · crackedRIGHT HORIZONTAL STAB, FORWARD UPPER SLIDING SEAL IS CRACKED. REPLACED FORWARD UPPER SLIDING SEAL ON RH STAB.SDR SCNA20161222371Bulkhead · gougedAFT SIDE OF THE AFT PRESSURE BULKHEAD HAS 4 GOUGES AT RIGHT SIDE WL 218. REPAIRED AFT PRESSURE BULKHEAD AT RT SIDE W.L. 218.SDR SCNA20161222370Angle · corrodedFWD CARGO COMPARTMENT ZEE ANGLE CORRODED FROM BS 500G TO 500I. REMOVED THE ANGLE.SDR SCNA20161222369Angle · corrodedFWD CARGO COMPARTMENT ZEE ANGLE CORRODED FROM BS 500G TO 500I. REPLACED THE ANGLE.
Back to Boeing 737-8Q8