JASC 5310
Service difficulty reports · 38,573
Reports filed under 5310 · Fuselage Main, Structure, newest first.
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 jasc_code = '5310' 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 jasc_code = '5310' 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 QXEA0001319Clip · crackedPDX- CRACKED CLIP AT FRAME 12405 AND STRINGER 29. REPAIRED IAW FOKKER SRM 53-02-13 FIGURE 2.SDR QXEA0001298Clip · crackedPDX- CRACKED CLIP AT AFT CABIN FRAME 12405 AND STRINGER 46. REPAIRED IAW FOKKER SRM 53-02-13 FIGURE 2.SDR QXEA0001223Clip · crackedPDX- CRACKED CLIP AT AFT CABIN FRAME 13815A AND STRINGER 28. REPAIRED IAW FOKKER SRM 53-02-13 FIGURE 2.SDR QXEA0001217Clip · crackedPDX- CRACKED CLIP AT AFT CABIN FRAME 13815A AND STRINGER 46. REPAIRED IAW FOKKER SRM 53-02-13 FIGURE 2.SDR QXEA0001216Clip · crackedPDX- CRACKED CLIP AT AFT CABIN FRAME 13815A AND STRINGER 47. REPAIRED IAW FOKKER SRM 53-02-13 FIGURE 2.SDR QXEA0001215Clip · crackedPDX- CRACKED CLIP AT AFT CABIN FRAME 13815A AND STRINGER 47R. REPAIRED IAW FOKKER SRM 53-02-13 FIGURE 2.SDR QXEA0001214Clip · crackedPDX- CRACKED CLIP AT AFT CABIN FRAME 13815A AND STRINGER 58. REPAIRED IAW FOKKER SRM 53-02-13 FIGURE 2.SDR QXEA0001213Clip · crackedPDX- CRACKED CLIP AT AFT CABIN FRAME 13815A AND STRINGER 35. REPAIRED IAW FOKKER SRM 53-02-13 FIGURE 2.SDR CA000714034Cargo Hook · twisted(CAN) THE PILOT CAME BACK FROM WORK AND REPORTED HE COULD NOT LATCH LOAD ON CARGO HOOK. A VISUAL INSP ON CARGO HOOK EMERG RELEASE CABLE SHOWED THERE WAS TOO MUCH STRAIN ON CABLE THAT CAUSED MECHANICAL RELEASE TO MOVE THE INTERNAL HOOK MECHANISM FROM LATCHED SDR QXEA0001375Clip · crackedPDX- CRACKED CLIP AT FRAME 12875 AND STRINGER 30. REPAIRED IAW FOKKER SRM 53-02-13 FIGURE 2.SDR QXEA0001302Clip · crackedPDX- CRACKED CLIP AT AFT CABIN FRAME 14755 AND STRINGER 57. REPAIRED IAW FOKKER SRM 53-02-13 FIGURE 2.SDR QXEA0001294Clip · crackedPDX- CRACKED CLIP AT AFT CABIN FRAME 12405 AND STRINGER 33R. REPAIRED IAW FOKKER SRM 53-02-13 FIGURE 2.SDR QXEA0001293Clip · crackedPDX- CRACKED CLIP AT AFT CABIN FRAME 12405 AND STRINGER 32. REPAIRED IAW FOKKER SRM 53-02-13 FIGURE 2.SDR QXEA0001292Clip · crackedPDX- CRACKED CLIP AT AFT CABIN FRAME 12405 AND STRINGER 30. REPAIRED IAW FOKKER SRM 53-02-13 FIGURE 2.SDR QXEA0001236Clip · crackedPDX- CRACKED CLIP AT AFT CABIN FRAME 14755 AND STRINGER 16A. REPAIRED IAW FOKKER SRM 53-02-13 FIGURE 2 AND 51-31-01.SDR QXEA0001235Clip · crackedPDX- CRACKED CLIP AT AFT CABIN FRAME 14755 AND STRINGER 18. REPAIRED IAW FOKKER SRM 51-1-04, 53-02-13 FIGURE 2 AND 51-31-01.SDR QXEA0001234Clip · crackedPDX- CRACKED CLIP AT AFT CABIN FRAME 14755 AND STRINGER 26. REPAIRED IAW FOKKER SRM 53-02-13 FIGURE 2 AND 51-31-01.SDR QXEA0001233Clip · crackedPDX- CRACKED CLIP AT AFT CABIN FRAME 14755 AND STRINGER 20. REPAIRED IAW FOKKER SRM 53-02-13 FIGURE 2 AND 51-31-01.SDR QXEA0001232Clip · crackedPDX- CRACKED CLIP AT AFT CABIN FRAME 14755 AND STRINGER 28. REPAIRED IAW FOKKER SRM 51-10-04, 53-02-13 FIGURE 2 AND 51-31-01.SDR QXEA0001231Clip · crackedPDX- CRACKED CLIP AT AFT CABIN FRAME 14755 AND STRINGER 49. REPAIRED IAW FOKKER SRM 53-02-13 FIGURE 2, AND 51-31-01.SDR QXEA0001230Clip · crackedPDX- CRACKED CLIP AT AFT CABIN FRAME 13815B AND STRINGER 30. REPAIRED IAW FOKKER SRM 53-02-13 FIGURE 2 PAGE 4.SDR QXEA0001229Clip · crackedPDX- CRACKED CLIP AT AFT CABIN FRAME 13815B AND STRINGER 44. REPAIRED IAW FOKKER SRM 53-02-13 FIGURE 2 PAGE 4.SDR QXEA0001228Clip · crackedPDX- CRACKED CLIP AT AFT CABIN FRAME 13815B AND STRINGER 19. REPAIRED IAW FOKKER SRM 53-02-13 FIGURE 2 PAGE 4.SDR QXEA0001227Clip · crackedPDX- CRACKED CLIP AT AFT CABIN FRAME 13815B AND STRINGER 57. REPAIRED IAW FOKKER SRM 53-02-13 FIGURE 2 PAGE 4.SDR QXEA0001226Clip · crackedPDX- CRACKED CLIP AT AFT CABIN FRAME 13815B AND STRINGER 18. REPAIRED IAW FOKKER SRM 53-02-13 FIGURE 2 PAGE 4.SDR QXEA0001225Clip · crackedPDX- CRACKED CLIP AT AFT CABIN FRAME 13815B AND STRINGER 17. REPAIRED IAW FOKKER SRM 53-02-13 FIGURE 2 PAGE 4.SDR QXEA0001224Clip · crackedPDX- CRACKED CLIP AT AFT CABIN FRAME 13815A AND STRINGER 18. REPAIRED IAW FOKKER SRM 53-02-13 FIGURE 2.SDR QXEA0001222Clip · crackedPDX- CRACKED CLIP AT AFT CABIN FRAME 13815A AND STRINGER 29. REPAIRED IAW FOKKER SRM 53-02-13 FIGURE 2.SDR QXEA0001221Clip · crackedPDX- CRACKED CLIP AT AFT CABIN FRAME 13815A AND STRINGER 30. REPAIRED IAW FOKKER SRM 53-02-13 FIGURE 2.SDR QXEA0001220Clip · crackedPDX- CRACKED CLIP AT AFT CABIN FRAME 13815A AND STRINGER 43. REPAIRED IAW FOKKER SRM 53-02-13 FIGURE 2.SDR QXEA0001219Clip · crackedPDX- CRACKED CLIP AT AFT CABIN FRAME 13815A AND STRINGER 44. REPAIRED IAW FOKKER SRM 53-02-13 FIGURE 2.SDR QXEA0001218Clip · crackedPDX- CRACKED CLIP AT AFT CABIN FRAME 13815A AND STRINGER 45. REPAIRED IAW FOKKER SRM 53-02-13 FIGURE 2.SDR QXEA0001212Clip · crackedPDX- CRACKED CLIP AT AFT CABIN FRAME 13815 AND STRINGER 21. REPAIRED IAW FOKKER SRM 53-02-13 FIGURE 2.SDR QXEA0001211Clip · crackedPDX- CRACKED CLIP AT AFT CABIN FRAME 13815 AND STRINGER 40. REPAIRED IAW FOKKER SRM 53-02-13 FIGURE 2.SDR QXEA0001210Clip · crackedPDX- CRACKED CLIP AT AFT CABIN FRAME 13815 AND STRINGER 43. REPAIRED IAW FOKKER SRM 53-02-13 FIGURE 2.SDR QXEA0001209Clip · crackedPDX- CRACKED CLIP AT AFT CABIN FRAME 13815 AND STRINGER 57. REPAIRED IAW FOKKER SRM 53-02-13 FIGURE 2.SDR QXEA0001208Clip · crackedPDX- CRACKED CLIP AT AFT CABIN FRAME 13815 AND STRINGER 36. REPAIRED IAW FOKKER SRM 53-02-13 FIGURE 2.SDR QXEA0001207Clip · crackedPDX- CRACKED CLIP AT AFT CABIN FRAME 13815 AND STRINGER 35. REPAIRED IAW FOKKER SRM 53-02-13 FIGURE 2.SDR QXEA0001206Clip · crackedPDX- CRACKED CLIP AT AFT CABIN FRAME 13815 AND STRINGER 33R. REPAIRED IAW FOKKER SRM 53-02-13 FIGURE 2.SDR QXEA0001205Clip · crackedPDX- CRACKED CLIP AT AFT CABIN FRAME 13815 AND STRINGER 32. REPAIRED IAW FOKKER SRM 53-02-13 FIGURE 2.SDR QXEA0001204Clip · crackedPDX- CRACKED CLIP AT AFT CABIN FRAME 13815 AND STRINGER 14. REPAIRED IAW FOKKER SRM 53-02-13 FIGURE 2.SDR QXEA0001203Clip · crackedPDX- CRACKED CLIP AT AFT CABIN FRAME 13815 AND STRINGER 18. REPAIRED IAW FOKKER SRM 53-02-13 FIGURE 2.SDR QXEA0001202Clip · crackedPDX- CRACKED CLIP AT AFT CABIN FRAME 13815 AND STRINGER 17. REPAIRED IAW FOKKER SRM 53-02-13 FIGURE 2.SDR QXEA0001201Clip · crackedPDX- CRACKED CLIP AT AFT CABIN FRAME 12875 AND STRINGER 29. REPAIRED IAW FOKKER SRM 53-02-13 FIGURE 2.SDR QXEA0001200Clip · crackedPDX- CRACKED CLIP AT AFT CABIN FRAME 12875 AND STRINGER 21. REPAIRED IAW FOKKER SRM 53-02-13 FIGURE 2 AND 51-31-01.SDR QXEA0001198Clip · crackedPDX- CRACKED CLIP AT AFT CABIN FRAME 12405 AND STRINGER 38. REPAIRED IAW FOKKER SRM 53-02-13 FIGURE 2.SDR QXEA0001197Clip · crackedPDX- CRACKED CLIP AT AFT CABIN FRAME 12875 AND STRINGER 32. REPAIRED IAW FOKKER SRM 53-02-13 FIGURE 2.SDR QXEA0001196Clip · crackedPDX- CRACKED CLIP AT AFT CABIN FRAME 12405 AND STRINGER 38. REPAIRED IAW FOKKER SRM 53-02-12 FIGURE 2.SDR QXEA0001300Clip · crackedPDX- CRACKED CLIP AT AFT CABIN FRAME 12405 AND STRINGER 43. REPAIRED IAW FOKKER SRM 53-02-13 FIGURE 2.SDR QXEA0001299Clip · crackedPDX- CRACKED CLIP AT AFT CABIN FRAME 12405 AND STRINGER 44. REPAIRED IAW FOKKER SRM 53-02-13 FIGURE 2.
Back to JASC 5310