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 SCNA20161101275Frame · crackedBS 867 FRAME CRACKED AT THE BRACKET ATTACHMENT INBD FASTENER BETWEEN STRINGERS 8 AND 9R. VERIFIED WITH HFEC AND MFEC. REPAIRED THE FRAME.SDR SCNA20161101274Frame · crackedBS 827 FRAME CRACKED AT THE BRACKET ATTACHMENT INBD FASTENER BETWEEN STRINGER 8 AND 9R. VERIFIED WITH HFEC AND MFEC. REPAIRED THE FRAME.SDR SCNA20161101273Frame · crackedBS 787 FRAME CRACKED AT THE BRACKET ATTACHMENT INBD FASTENER BETWEEN STRINGER 8 AND 9R. VERIFIED WITH HFEC AND MFEC. REPAIRED THE FRAME.SDR SCNA20161101272Frame · crackedBS 747 FRAME CRACKED AT THE BRACKET ATTACHMENT INBD FASTENER BETWEEN STRINGERS 8 AND 9R. VERIFIED WITH HFEC AND MFEC. REPAIRED THE FRAME.SDR SCNA20161101271Frame · crackedBS 727D FRAME CRACKED AT THE BRACKET ATTACHMENT INBD FASTENER BETWEEN STRINGERS 8 AND 9R. VERIFIED WITH HFEC AND MFEC. REPAIRED THE FRAME.SDR SCNA20161101270Frame · crackedBS 520 FRAME CRACKED AT THE BRACKET ATTACHMENT INBD FASTENER BETWEEN STRINGERS 8 AND 9R. VERIFIED WITH HFEC AND MFEC. REMOVED THE DAMAGE AND FABRICATED AND INSTALLED REPAIR.SDR SCNA20161101269Frame · crackedBS 500C FRAME CRACKED AT THE BRACKET ATTACHMENT INBD FASTENER BETWEEN STRINGERS 8 AND 9R. VERIFIED WITH HFEC AND MFEC. REPAIRED THE FRAME.SDR SCNA20161101268Frame · crackedBS 500A FRAME CRACKED AT THE BRACKET ATTACHMENT INBD FASTENER BETWEEN STRINGERS 8 AND 9R. VERIFIED WITH HFEC AND MFEC. REPAIRED THE FRAME.SDR SCNA20161101267Frame · crackedBS 480 FRAME CRACKED AT THE BRACKET ATTACHMENT INBD FASTENER BETWEEN STRINGER 8 AND 9R. VERIFIED WITH HFEC AND MFEC. REPAIRED THE FRAME.SDR SCNA20161101266Frame · crackedBS 440 FRAME CRACKED AT THE BRACKET ATTACHMENT INBD FASTENER BETWEEN STRINGER 8 AND 9R. VERIFIED WITH HFEC AND MFEC. REPAIRED THE FRAME.SDR SCNA20161101265Frame · crackedBS 400 FRAME CRACKED AT THE BRACKET ATTACHMENT INBD FASTENER BETWEEN STRINGER 8 AND 9R. VERIFIED WITH HFEC AND MFEC. REPAIRED THE FRAME.SDR SCNA20161101264Frame · crackedBS 360 FRAME CRACKED AT THE BRACKET ATTACHMENT INBD FASTENER BETWEEN STRINGER 8 AND 9R. VERIFIED WITH HFEC AND MFEC. REPAIRED THE FRAME.SDR SCNA20161101263Frame · crackedBS 907 FRAME CRACKED AT BRACKET ATTACHMENT INBD FASTENER BETWEEN STRINGER 8 AND 9L. VERIFIED WITH HFEC AND MFEC. REPAIRED THE FRAME.SDR SCNA20161101262Frame · crackedBS 867 FRAME CRACKED AT BRACKET ATTACHMENT INBD FASTENER BETWEEN STRINGER 8 AND 9L. VERIFIED WITH HFEC AND MFEC. REPAIRED THE FRAME.SDR SCNA20161101261Frame · crackedBS 827 FRAME CRACKED AT BRACKET ATTACHMENT INBD FASTENER BETWEEN STRINGER 8 AND 9L. VERIFIED WITH HFEC AND MFEC. REPAIRED THE FRAME.SDR SCNA20161101260Frame · crackedBS 787 FRAME CRACKED AT BRACKET ATTACHMENT INBD FASTENER BETWEEN STRINGERS 8 AND 9L. VERIFIED WITH HFEC AND MFEC. REPAIRED THE FRAME.SDR SCNA20161101259Frame · crackedBS 747 FRAME CRACKED BETWEEN STRINGER 8 AND 9L. VERIFIED WITH HFEC AND MFEC. REPAIRED THE FRAME.SDR SCNA20161101258Frame · crackedBS 727D FRAME CRACKED BETWEEN STRINGER 8 AND 9L. VERIFIED WITH HFEC AND MFEC. REPAIRED THE FRAME.SDR SCNA20161101257Frame · crackedBS 727B FRAME CRACKED BETWEEN STRINGERS 8 AND 9L. VERIFIED WITH HFEC AND MFEC. REPAIRED THE FRAME.SDR SCNA20161101256Frame · crackedBS 500C FRAME CRACKED BETWEEN STRINGERS 8 AND 9L. VERIFIED WITH HFEC AND MFEC. INSTALLED REPAIR ANGLES.SDR SCNA20161101255Frame · crackedBS 500A FRAME CRACKED BETWEEN STRINGERS 8 AND 9L. VERIFIED WITH HFEC AND MFEC. REPAIRED THE FRAME.SDR SCNA20161101254Frame · crackedAD DRIVEN. STA 480 LT FRAME CRACKED AT AC BRACKET ATTACHMENT IB FASTENER BETWEEN S-8 AND S-9. VERIFIED WITH HFEC AND MFEC. REPAIRED STA 480 LT FRAME BETWEEN S-8 & S-9.SDR SCNA20161101253Frame · crackedAD DRIVEN. STA 400 LT FRAME CRACKED AT AC BRACKET ATTACHMENT IB FASTENER BETWEEN S-8 AND S-9. VERIFIED WITH HFEC AND MFEC. REPAIRED STA 400 LT FRAME BETWEEN S-8 & S-9.SDR SCNA20161101252Frame · crackedAD DRIVEN. STA 360 LT FRAME CRACKED AT AC BRACKET ATTACHMENT IB FASTENER BETWEEN S-8 AND S-9. VERIFIED WITH HFEC AND MFEC. REPAIRED STA 360 LT FRAME BETWEEN S-8 & S-9.SDR SWAA2016110409387Flashlight · looseFORWARD WINDSCREEN FLASHLIGHT BASES LOOSE. SECURED BASE ASSEMBLY PER SOPM.SDR SWAA2016110809516Support Angle · crackedBULKHEAD SUPPORT ANGLE CRACKED AT BS 727. R & R THE SUPPORT ANGLE IAW SRM.SDR SWAA2016120110142Stiffener · crackedLT HORIZONTAL STABILIZER VERT STIFFENER CRACKED AT STA 157.10, 3RD FROM FORWARD AT LOWER END. REPAIRED STIFFENER IAW SRM.SDR SWAA2016120510190Frame · crackedFRAME CRACKED AT BS 907, STR 8R. REPAIRED FRAME PER ER AND EA.SDR SWAA2016120110141Support · corrodedL1 DOOR CUTOUT LOWER CENTER THRESHOLD ZEE CHANNEL SUPPORT CORRODED AT LBL 63. R&R SUPPORT IAW SRM.SDR SWAA2016120110120Frame · crackedFRAME CRACKED AT BS 360, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA2016112910061Frame · crackedFRAME CRACKED AT BS 520, STR 8L. REPAIRED FRAME PER EA.SDR SWAA2016112910060Frame · crackedFRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER EA.SDR SWAA2016112910059Frame · crackedFRAME CRACKED AT BS 500A, STR 8L. REPAIRED FRAME PER EA.SDR SWAA2016112809982Frame · crackedFRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER ER AND EA.SDR SWAA2016112809981Frame · crackedFRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME PER EA.SDR SWAA2016112809980Frame · crackedFRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME PER EA.SDR SWAA2016110809513Support Angle · corrodedR1 DOOR LOWER SUPPORT ANGLE CORRODED AT WL 208, RBL 59. R & R THE SUPPORT ANGLE IAW SRM.SDR SWAA2016110809511Frame · crackedFRAME CRACKED AT BS 500A, STRINGER 8R. REPAIRED THE FRAME IAW EA.SDR SWAA2016110809510Frame · crackedFRAME CRACKED AT BS 440, STRINGER 8L. REPAIRED THE FRAME IAW EA.SDR SWAA2016110809509Frame · crackedFRAME CRACKED AT BS 400, STRINGER 8L. REPAIRED THE FRAME IAW EA.SDR SWAA2016102709145Frame · crackedFRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME PER EA.SDR SWAA2016112910058Frame · crackedSTUB BEAM CRACKED AT BS 295, WL 207. R&R STUB FRAME PER SRM AND AMM.SDR SWAA2016110809517Support Angle · crackedRIGHT MAIN WHEEL WELL KEEL BEAM UPPER WEB SUPPORT ANGLE CRACKED AT BS 726, BETWEEN RBL 4.3 TO LBL 4.3. REPAIRED THE SUPPORT ANGLE IAW SRM.SDR SWAA2016110809515Floor Support · crackedFLOOR SUPPORT CRACKED BETWEEN BS 277 TO 294.5, RBL 1. R & R THE FLOOR SUPPORT IAW SRM.SDR SWAA2016110809508Floor Support · crackedFLOOR SUPPORT CRACKED BETWEEN BS 312 TO 328, RBL 31. R & R THE FLOOR SUPORT IAW SRM.SDR SWAA2016102108950Hook · corrodedLEFT OVERWING EMERGENCY EXIT ESCAPE ROPE HAS A CORRODED HOOK END. R & R HOOK END IAW MM.SDR SWAA2016102108949Hook · corrodedRIGHT OVERWING EMERGENCY EXIT ESCAPE ROPE HAS A CORRODED HOOK END. R & R HOOK END IAW MM.SDR SWAA2016110809507Plate · crackedTHE LEFT WING LOWER TRAILING EDGE WAFFLE PLATE JUST INBOARD OF THE NR 1 PYLON AFT TIP CRACKED R & R THE PLATE IAW SRM.SDR SWAA2016102509079Plate · crackedRT WING LOWER TRAILING EDGE WAFFLE PLATE CRACKED JUST INBOARD OF NR 2 PYLON AFT TIP. R&R WAFFLE PLATE IAW SRM.SDR SWAA2016110709477Support Angle · corrodedSIDEWALL SUPPORT ANGLE CORRODED AT BS 500, BETWEEN STR 18L TO STR 26L. REPAIRED SUPPORT IAW DWG & SRM.
Back to Boeing 737-7Q8