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 SWAA2016110209312Skin · corrodedNR 2 ADF ANTENNA FOUND FUSELAGE SKIN CORRODED BETWEEN BS 727+12 TO BS 727B, BETWEEN STR 1 TO STR 2R. REPAIRED SKIN IAW ER & EA.SDR SWAA2016110209311Floor Support · crackedLONGITUDINAL FLOORBEAM FLANGE CRACKED AT BS 727B, RBL 24.75. REPAIRED FLANGE IAW SRM.SDR SWAA2016091607887Floorbeam · crackedFLOORBEAM FLANGE CRACKED AT BS 727B, RBL 45.5. REPAIRED THE FLOORBEAM FLANGE IAW SRM.SDR SCNA20160827109Battery Pack · inoperativeLEFT AFT EMERGENCY LIGHT BATTERY PACK NOT CHARGING. R & R THE BATTERY PACK AND CHARGER. FUNCTION CHECKED GOOD.SDR SCNA20160827108Lamp · inoperativeROW 22DEF EMERENCY LIGHT INOPERATIVE. REPLACED THE LAMP.SDR SCNA20160827107Charger · no testLEFT EMERGENCY LIGHT BATTERY PACK FAILED CAPACITY CHECK. REMOVED AND REPLACED THE BATTERY PACK AND CHARGER. FUNCTIONAL CHECK GOOD.SDR SCNA20160827106Battery Pack · no testRIGHT OVERWING WINDOW EMERGENCY LIGHT BATTERY PACK FAILED CAPACITIANCE CHECK. R & R BATTERY PACK. OPS CHECKED GOOD.SDR SCNA20160827105Charger · no testLEFT FWD EMERGENCY BATTERY PACK FAILED CAPACITY CHECK. REMOVED AND REPLACED THE BATTERY PACK AND CHARGER. FUNCTIONAL CHECKED GOOD.SDR SCNA20160827104Battery Pack · no testRIGHT AFT EMERGENCY LIGHT BATTERY PACK FAILED CAPACITIANCE CHECK. R & R THE BATTERY PACK. OPS TESTED GOOD.SDR SWAA2016100408447Support Angle · corrodedAFT CARGO BAY LOWER BULKHEAD SUPPORT ANGLE CORRODED AT BS 947, BETWEEN LBL 10 TO RBL 21. R & R THE ANGLE IAW SRM & DWG.SDR SWAA2016100308405Cargo Track · crackedAFT CARGO BAY CARGO TRACK CRACKED BETWEEN BS 727E TO 747, RBL 13.5. R & R THE CARGO TRACK IAW SRM.SDR SWAA2016091907967Fitting · crackedFITTING CRACKED AT BS 948, STRINGER 26L. R & R THE FITTING IAW SRM.SDR SWAA2016091607886Angle · crackedAFT CARGO BAY BOTTOM ATTACH ANGLE FOR BULKHEAD SUPPORT ANGLE CRACKED AT BS 865, LBL 10. R & R ANGLE IAW SRM.SDR SWAA2016091607885Web · corrodedAFT CARGO BAY ON THRESHOLD WEB CORRODED BETWEEN BS 794 TO 847, BETWEEN RBL 20 TO 28. R & R THE WEB IAW SRM.SDR SWAA2016091607884Support · corrodedAFT CARGO BAY ON FLOOR TO SIDEWALL SUPPORT PLATE CORRODED BETWEEN BS 847 & 867, RBL 21. R & R THE SUPPORT IAW SRM.SDR SWAA2016110409386Skin · crackedSKIN CRACKED AT BS 540, STR 22L. REPAIRED SKIN PER ER & EA.SDR SWAA2016110209309Frame · crackedFRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME PER EA.SDR SWAA2016101808898Support · crackedFAIRING SUPPORT STRUCTURE CRACKED AT BS 727, RBL 10.5. R&R STRUCTURE IAW SRM.SDR SWAA2016101808897Frame · crackedFRAME CRACKED AT BS 787, STR 8R. REPAIRED FRAME IAW EA.SDR SWAA2016101808896Frame · crackedFRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA2016101808895Frame · crackedFRAME CRACKED AT BS 360, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA2016100308404Frame · crackedFRAME CRACKED AT BS 907, STRINGER 8R. REPAIRED FRAME PER ER AND EA.SDR SWAA2016091907966Frame · crackedFRAME CRACKED AT BS 440, STRINGER 8R. REPAIRED TEH FRAME IAW EA.SDR SWAA2016091607883Frame · crackedFRAME CRACKED AT BS 827, STRINGER 8L. REPAIRED THE FRAME IAW EA.SDR SWAA2016091607882Frame · crackedFRAME CRACKED AT BS 500C, STRINGER 8L. REPAIRED THE FRAME IAW EA.SDR SWAA2016091255671Frame · crackedFRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME IAW EA.SDR SWAA2016091255670Frame · crackedFRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME IAW EA.SDR SWAA2016091255669Frame · crackedFRAME CRACKED AT BS 787, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA2016090955644Frame · crackedFRAME CRACKED AT BS 360, STR 8R. REPAIRED FRAME IAW EA.SDR SWAA2016090655548Frame · crackedFRAME CRACKED AT BS 440, STRINGER 8L. REPAIRED THE FRAME IAW EA.SDR SWAA2016090655523Frame · crackedFRAME CRACKED AT BS 480, STRINGER 8R. REPAIRED THE FRAME IAW EA.SDR SWAA2016090655522Frame · crackedFRAME CRACKED AT BS 400, STRINGER 8L. REPAIRED THE FRAME IAW EA.SDR SWAA2016090655520Frame · crackedFRAME CRACKED AT BS 400, STRINGER 8R. REPAIRED THE FRAME IAW EA.SDR SWAA2016090655519Frame · crackedFRAME CRACKED AT BS 500A, STRINGER 8L. REPAIRED THE FRAME IAW EA.SDR SWAA2016090655518Frame · crackedFRAME CRACKED AT BS 480, STRINGER 8L. REPAIRED THE FRAME IAW EA.SDR SWAA2016101808893Crease Beam · corrodedCREASE BEAM WEB CORRODED BETWEEN BS 540 TO BS 559, STR 17R. REPAIRED WEB IAW ER AND EA.SDR SWAA2016100308399Tee Fitting · corrodedL2 DOOR CUTOUT AFT FRAME TEE FITTING CORRODED AT BS 992.8, STRINGER 13L. R & R TEE FITTING IAW SRM AND DWG.SDR SWAA2016090655521Floor Support · crackedFLOOR SUPPORT UPPER FLANGE CRACKED BETWEEN BS 380 TO 400, RBL 9. R & R THE FLOOR SUPPORT IAW DWG & SRM.SDR SWAA2016090655517Stringer Clip · crackedSTRINGER CLIP 8R CRACKED AT BS 360. R & R THE STRINGER CLIP IAW SRM AND DWG.SDR SWAA2016101808892Support Angle · corrodedFORWARD CARGO BAY ON LOWER CURVED BULKHEAD SUPPORT ANGLE CORRODED AT BS 500D, BETWEEN STR 24R TO STR 26R. R&R ANGLE PER SRM.SDR SWAA2016101808891Plate · corrodedFORWARD CARGO BAY ON FLOOR TO SIDE WALL SUPPORT PLATE CORRODED BETWEEN BS 396 TO BS 500D, LBL 23. R&R PLATE IAW SRM.SDR SWAA2016100308398Support Angle · corrodedFORWARD CARGO BAY ON LOWER BULKHEAD SUPPORT ANGLE CORRODED AT BS. 500D, BETWEEN LBL 24 TO RBL 24. / R&R ANGLE PER DWG AND SRM.SDR SWAA2016092608179Attach Angle · crackedFORWARD CARGO BAY FLOOR SUPPORT ATTACH ANGLE CRACKED AT BS 500C, STRINGER 26R. R & R THE ATTACH ANGLE IAW SRM.SDR SWAA2016092608178Shield · corrodedFORWARD CARGO BAY ON FLOOR TO SIDE WALL SUPPORT PLATE SHIELD CORRODED BETWEEN BS 492 TO 500A, RBL 23. R & R SHIELD IAW SRM.SDR SWAA2016091907965Angle · crackedINTERCOSTAL ANGLE CRACKED AT BS 500C, STRINGER 26L. R & R THE ANGLE IAW SRM.SDR SWAA2016091607881Support · corrodedFORWARD CARGO BAY ON FLOOR TO SIDE WALL SUPPORT CORRODED BETWEEN BS 420 & 440, RBL 23. R & R THE SUPPORT IAW SRM.SDR SWAA2016091607880Support · corrodedFORWARD CARGO BAY ON FLOOR TO SIDE WALL SUPPORT PLATE CORRODED BETWEEN BS 396 & 420, RBL 23. R & R THE SUPPORT IAW SRM.SDR SWAA2016101808890Fitting · corrodedR2 DOOR SURROUNDING STRUCTURE FITTING CORRODED AT BS 986+7, STR 13R. R&R FITTING PER SRM & DWG.SDR SWAA2016101308746Fitting · corrodedR2 DOOR FITTING CORRODED AT BS 986+7, STRINGER 15R. R&R FITTING PER SRM.SDR SWAA2016100308397Fitting · corrodedR2 DOOR FRAME SUPPORT WEB FITTING CORRODED AT BS 986+7, STRINGER 12R. R & R THE FITTING IAW SRM & DWG.
Back to Boeing 737-7Q8