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 SWAA2014022125419Skin · crackedRT WING NR 7 SLAT SKIN CRACKED AT STATION 322.71. REPAIRED SKIN IAW SRM.SDR SWAA2014022125418Skin · crackedLT WING NR 2 SLAT STATION 322.71 LE SKIN AT ACTUATOR RIB CRACKED. REPAIRED SKIN IAW SRM.SDR SWAA2014022125417Skin · crackedLT WING NR 1 SLAT SKIN STATION 451.97 LE NOSE SKIN AT ACTUATOR RIB CRACKED. REPAIRED SKIN IAW SRM.SDR SCNA20140124003Circuit Breaker · trippedDURING CLIMBOUT, BOTH LT AND RT OVERWING LIGHTS ILLUMINATED. FOUND OVERWING FLIGHT LOCK RT & LT CIRCUIT BREAKERS OPEN. RESET BREAKERS AND TESTED EMERGENCY EXIT DOOR SYSTEM AND TESTS OK.SDR SCNA20140120002Hydraulic System · low pressureENG 1A HYDRAULIC LOW PRESSURE LIGHT ILLUMINATED. TURNED PUMP OFF. HYDRAULIC B LOW PRESS LIGHT ILLUMINATED. TURNED PUMP OFF. QUANTITY INDICATED LOSS AT INITIALLY A SLOW RATE TO 69 PERCENT FOR B SYSTEM, THEN RAPID DECREASE TO 30 PERCENT. QTY RETURNED TO 70 PERCSDR SWAA2014012024340Slide · looseL2 DOOR EMERGENCY EVAC SLIDE LOOSE. SECURED SLIDE IAW TC.SDR SWAA2013121623398Control Cable · corrodedRT WING SPOILER CONTROL CABLE CORRODED. R & R CABLE IAW MM.SDR SWAA2013121623395Battery Pack · failedAFT EMERGENCY EXIT BATTERY PACK FAILED CAPACITY CHECK. R & R BATTERY PACK IAW AMM.SDR SWAA2013121623394Control Cable · corrodedRT WING SPOILER CABLE CORRODED INBD OF PULLEY. R & R CABLE IAW MM.SDR SWAA2013121623393Skin · crackedRT WING NR 8 SLAT SKIN CRACKED AT THE ACTUATOR ATTACH POINT. R & R SLAT ASSEMBLY IAW AMM.SDR SWAA2013121623392Flap Track · looseLT WING INBD AFT FLAP INBD & OTBD FLAP TRACKS LOOSE AT ATTACH POINTS. R & R FLAP TRACKS IAW MM.SDR SWAA2013121623391Pulley · wornLT WING NR 5 SPOILER DOUBLE SPOILER PULLEY WORN INBD OF PYLON AREA. R & R SPOILER PULLEY IAW AMM.SDR SWAA2013121623390Control Cable · corrodedLT WING WSA2-L2 NR 5 SPOILER CABLE CORRODED AT PULLEY INBD OF PYLON AREA. R & R CABLE IAW AMM.SDR SWAA2013111822495Window Frame · crackedRT NR 1 WINDOW FRAME CRACKED AT UPPER OTBD CORNER. R & R FRAME IAW ACO.SDR SWAA2013111822494Window Frame · crackedFLIGHT COMPARTMENT LT NR 1 WINDOW FRAME CRACKED IN FRAME AT OTBD TOP CORNER FRAME TO STRUCTURE ATTACH FASTENER HOLE ON ATTACH FLANGE. R & R FRAME IAW ACO.SDR SWAA2013111822493Window Frame · crackedFLIGHT COMPARTMENT LT 1 WINDOW FRAME CRACKED AT TOP OTBD CORNER OF WINDOW CUTOUT. R & R FRAME PER ACO.SDR SWAA2013111922589Frame · crackedFRAME CRACKED AT STATION 907, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2013111322322Frame · crackedFRAME CRACKED AT STATION 747, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2013111322321Frame · crackedFUSELAGE FRAME CRACKED AT STATION 480, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2013111322319Frame · crackedFRAME CRACKED AT STATION 480, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2013111322335Frame · crackedFRAME CRACKED AT STATION 400, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2013111122184Frame · crackedFRAME CRACKED AT STATION 727D, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2013111122183Frame · crackedFRAME CRACKED AT STATION 827, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2013111122182Frame · crackedFRAME CRACKED AT STATION 787, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2013111122181Frame · crackedFRAME CRACKED AT STATION 727D, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2013111122165Frame · crackedFUSELAGE FRAME CRACKED AT STATION 827, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2013111122164Frame · crackedFUSELAGE FRAME CRACKED AT STATION 787, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2013111122163Frame · crackedFRAME CRACKED AT STATION 727B, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2013111122162Frame · crackedFRAME CRACKED AT STATION 727A, STRINGER 8L. REPAIR FRAME IAW EA.SDR SWAA2013111922591Stringer · crackedSTRINGER CRACKED AT STATION 540, STRINGER 22R. REPAIRED STRINGER IAW EA.SDR SWAA2013111922590Stringer · crackedSTRINGER CRACKED AT STATION 540, STRINGER 22L. REPAIRED STRINGER IAW EA.SDR SWAA2013111922588Rib · crackedRT HORIZONTAL STABILIZER RIB LE LOWER FLANGE CRACKED AT STATION 120.3. REPAIRED RIB IAW EA.SDR SWAA2013111322344Rib · crackedLT HORIZONTAL STABILIZER STATION 92.7, 38.5" AFT OF LE, RIB VERTICAL STIFFENER NEAR LOWER FLANGE CRACKED. REPAIRED RIB IAW SRM.SDR SWAA2013111122180Rib · crackedLT HORIZONTAL STABILIZER AFT OF LE LOWER RIB FLANGE AT VERTICAL STIFFENER CRACKED AT STATION 92.7, 20". REPAIRED RIB IAW EA.SDR SWAA2013111422370Window Frame · crackedRT NR 3 WINDOW FRAME, E-F WINDOW POST CRACKED AT 2ND, 3RD & 4TH HOLES FROM BOTTOM. R & R FRAME IAW SWA EA & DRAWING.SDR SWAA2013111322334Window Frame · crackedLT NR 3 WINDOW FRAME, E-F WINDOW POST CRACKED AT 2ND HOLE FROM BOTTOM. REPAIRED FRAME IAW EA & DRAWING.SDR SWAA2013111322320Frame · crackedFUSELAGE FRAME CRACKED AT STATION 440, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SCNA20130926114Battery Pack · inoperativeAFT LT OVERHEAD BIN EMERGENCY LIGHTS GO OUT IN 10 MINUTES. REPLACED POWER SUPPLY AND BATTERY PACK ABOVE AFT LEFT JUMP SEAT IN CEILING.SDR SCNA20130822111Sign · detachedAFT GALLEY EXIT SIGN ON CEILING CAME LOOSE DURING TAKEOFF. REPLACED LIGHT ASSY.SDR SCNA20130722110Lens · dislodgedAFT EXIT SIGN LENS COVER FELL OFF. INSTALLED AFT OVERHEAD EXIT COVER.SDR SWAA2013061017023Seat Track · crackedSEAT TRACK INBD FLANGE FWD FASTENER HOLE CRACKED AT STA 727B, RBL 45.5. REPAIRED BEAM IAW EA.SDR SWAA2013061017021Seat Track · crackedSEAT TRACK OTBD FLANGE AFT FASTENER HOLE CRACKED AT STA 727B, RBL 45.5. REPAIRED BEAM IAW SWA EA.SDR SWAA2013061017026Sill · corrodedAFT CARGO LOWER DOOR SILL WEB CORRODED AT BS 809. R & R WEB IAW SRM AND DWG.SDR SWAA2013061017025Seat Track · crackedSEAT TRACK INBD FLANGE AFT FASTENER HOLE CRACKED AT STA 727B, LBL 24.75. REPAIRED BEAM IAW EA.SDR SWAA2013061017024Seat Track · crackedSEAT TRACK INBD FLANGE AFT FASTENER HOLE CRACKED AT STA 727B, RBL 45.5. REPAIRED BEAM IAW EA.SDR SWAA2013061017022Seat Track · crackedSEAT TRACK OTBD FLANGE FWD FASTENER HOLE CRACKED AT STA 727B, RBL 45.5. REPAIRED BEAM IAW SWA EA.SDR SWAA2013061017020Seat Track · crackedSEAT TRACK OTBD FLANGE AFT FASTENER HOLE CRACKED AT STA 727B, LBL 45.5. REPAIRED BEAM IAW SWA EA.SDR SWAA2013061017019Flap · delaminatedLEFT WING INBD MID FLAP OTBD UPPER T/E DELAMINATED. REPAIRED MID FLAP IAW EA.SDR SWAA2013060716901Fitting · brokenL2 DOOR EMERGENCY EVAC SLIDE AFT GIRT BAR FITTING BASE PLATE BROKEN. R & R FITTING IAW AMM.SDR SWAA2013050315558Light · looseEEPLS LOOSE AT ROW 8. SECURED EEPLS STRIP PER MM.
Back to Boeing 737-7Q8