Service difficulty reports
1,771,708 reports of malfunctions and defects, newest first. Air carriers must report; 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' 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' 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 SWAA2025100307858Web · crackedCRACK ON WEB TRAILING EDGE LOCATED AREA DEFLECTION CONTROL RIB ORSS270 LT WING. REPLACED WEB ON TRAILING EDGE LOCATED AREA DEFLECTION CONTROL RIB ORSS270 LT WING IAW B737-700 DWG: 115A2512 SHEET 16 REV: -. SRM 51-40-02 AND SRM 51-10-02 ITEM 9.SDR SWAA2025100207704Girt Bar · deterioratedDETERIORATED GIRT BAR HARDWARE AND PLATE ENTRY DOOR AT FWD GALLEY AREA. REPLACED GIRT BAR HARDWARE AND PLATE ENTRY DOOR AT FWD GALLEY AREA IAW AMM 25-66-02-000-801 AND AMM 25-66-02-400-801.SDR SWAA2025100220624Plate · deterioratedDETERIORATED GIRT BAR HARDWARE AND PLATE ENTRY DOOR AT FWD GALLEY AREA. REPLACED GIRT BAR HARDWARE AND PLATE ENTRY DOOR AT FWD GALLEY AREA IAW AMM 25-66-02-000-801 AND AMM 25-66-02-400-801.SDR SWAA2025100207705Girt Bar · deterioratedDETERIORATED GIRT BAR HARDWARE AND PLATE SERVICE DOOR AT FWD GALLEY AREA. REPLACED GIRT BAR HARDWARE AND PLATE SERVICE DOOR AT FWD GALLEY AREA IAW AMM 25-66-02-000-801 AND AMM 25-66-02-400-801.SDR SWAA2025100220625Plate · deterioratedDETERIORATED GIRT BAR HARDWARE AND PLATE SERVICE DOOR AT FWD GALLEY AREA. REPLACED GIRT BAR HARDWARE AND PLATE SERVICE DOOR AT FWD GALLEY AREA IAW AMM 25-66-02-000-801 AND AMM 25-66-02-400-801.SDR SWAA2025092407618Cover · crackedOVERWING ESCAPE, LOWER BEZELS BROKEN & CRACKED AT POSITIONS RF, LF, LA. R & R BEZELS COVERS IAW SIP.SDR IPXA2025091739173Bracket · crackedE&E COMPARTMENT, RIB 10, -Y953, SUPPORT ANGLE WITH EVIDENCE OF CRACK. INSTALLED NEW SUPPORT ANGLE AT Z100 E&E COMPARTMENT, RIB 10, -Y953. IAW SRM 51-75-10. REVIEWEDSDR SIMA20250824003Seal Rest · corrodedSSI 53-21-009 FWD CARGO DOOR CUTOUT LOWER FWD SEAL REST CORRODED. (MAJOR REEPAIR) (LEVEL 2 CORROSION) REMOVED AND REPLACED FWD CARGO DOOR CUTOUT LOWER FWD SEAL REST IAW ERJ 175 AMM 20-10-01 AND ERJ 175 SRM 51-40-08SDR SIMA20250824002Seal Rest · corrodedSSI 53-21-009 FWD CARGO DOOR CUTOUT LOWER CENTER SEAL REST CORRODED (MAJOR REEPAIR) (LEVEL 2 CORROSION) REMOVED AND REPLACED FWD CARGO DOOR CUTOUT LOWER CENTER SEAL REST IAW ERJ 175 SRM 51-40-08SDR IPXA2025091739164Bracket · crackedE&E COMPARTMENT, RIB 10, Y953, SUPPORT ANGLE CRACK. INSTALLED NEW SUPPORT ANGLE AT E&E COMPARTMENT, RIB 10, Y953. IAW A300-600 SRM 51-75-10.SDR SWAA2025091707796Floor Panel · peelingMAIN CABIN FLOOR PANEL 231CF HAS PEELING STRANDS OF FIBER. RECIEVED NEW FLOORBOARD 231CF PN:141A5810-739 BN:666589 IAW AIPC 53-21-00.INSTALLED ON TTG8Q014RRMM & IPC 53-21-51-22BSDR SWAA2025091707798Floor Panel · peelingMAIN CABIN FLOOR PANEL 231FF HAS PEELING STRANDS OF FIBER. NSTALLED ON TTG8Q014RRN4 & IPC 53-21-51-58B.SDR SWAA2025091707799Floor Panel · peelingMAIN CABIN FLOOR PANEL 231EF HAS PEELING STRANDS OF FIBER. INSTALLED ON TTG8Q014RRQ6SDR SWAA2025091707800Floor Panel · peelingMAIN CABIN FLOOR PANEL 231DF HAS PEELING STRANDS OF FIBER. INSTALLED ON TTG8Q014RRQA.SDR SWAA2025091707802Floor Panel · peelingMAIN CABIN FLOOR PANEL 232DF HAS PEELING STRANDS OF FIBER. INSTALLED ON TTG8Q014RRQLSDR SWAA2025091707804Floor Panel · peelingMAIN CABIN FLOOR PANEL 231HF HAS PEELING STRANDS OF FIBER. INSTALLED ON TTG8Q014RRQXSDR SWAA2025091707805Floor Panel · peelingMAIN CABIN FLOOR PANEL 231GF HAS PEELING STRANDS OF FIBER. INSTALLED ON TTG8Q014RRR5SDR SWAA2025091707806Floor Panel · peelingMAIN CABIN FLOOR PANEL 232EF HAS PEELING STRANDS OF FIBER. INSTALLED ON TTG8Q014RRRC.SDR SWAA2025091707809Floor Panel · peelingMAIN CABIN FLOOR PANEL 231LF HAS PEELING STRANDS OF FIBER. INSTALLED ON TTG8Q014RRS6.SDR SWAA2025091707812Floor Panel · peelingMAIN CABIN FLOOR PANEL 232HF HAS PEELING STRANDS OF FIBER. INSTALLED ON TTG8Q014RRSS.SDR SWAA2025091707814Floor Panel · peelingMAIN CABIN FLOOR PANEL 231PF HAS PEELING STRANDS OF FIBER. INSTALLED ON TTG8Q014RRTC.SDR SWAA2025091707815Floor Panel · peelingMAIN CABIN FLOOR PANEL 231NF HAS PEELING STRANDS OF FIBER. INSTALLED ON TTG8Q014RRTH.SDR SWAA2025091707819Floor Panel · peelingMAIN CABIN FLOOR PANEL 231RF HAS PEELING STRANDS OF FIBER. INSTALLED ON TTG8Q014RRTX.SDR SWAA2025091707821Floor Panel · pulledMAIN CABIN FLOOR PANEL 232MF HAS PEELING STRANDS OF FIBER.. INSTALLED ON TTG8Q014RRU4.SDR SWAA2025091707822Floor Panel · peelingMAIN CABIN FLOOR PANEL 232SF HAS PEELING STRANDS OF FIBER. INSTALLED ON TTG8Q014RSQ8.SDR SWAA2025091707823Floor Panel · peelingMAIN CABIN FLOOR PANEL 242AF HAS PEELING STRANDS OF FIBER. INSTALLED ON TTG8Q014RSQL.SDR SWAA2025091707824Floor Panel · peelingMAIN CABIN FLOOR PANEL 241HF HAS PEELING STRANDS OF FIBER. INSTALLED ON TTG8Q014RSRP.SDR SWAA2025091707825Floor Panel · peelingMAIN CABIN FLOOR PANEL 242HF HAS PEELING STRANDS OF FIBER. INSTALLED ON TTG8Q014RSS5.SDR SWAA2025091707826Floor Panel · peelingMAIN CABIN FLOOR PANEL 232NF HAS PEELING STRANDS OF FIBER. INNSTALLED ON TTG8Q014RSPQ.SDR SWAA2025091707828Floor Panel · peelingMAIN CABIN FLOOR PANEL 231YF HAS PEELING STRANDS OF FIBER. INSTALLED ON TTG8Q014RSX1.SDR SWAA2025091707829Floor Panel · peelingMAIN CABIN FLOOR PANEL 231XF HAS PEELING STRANDS OF FIBER. INSTALLED ON TTG8Q014RSQ3.SDR SWAA2025091707830Floor Panel · peelingMAIN CABIN FLOOR PANEL 232RF HAS PEELING STRANDS OF FIBER. INSTALLED ON TTG8Q014RSQ6.SDR SWAA2025091707831Floor Panel · peelingMAIN CABIN FLOOR PANEL 241BF HAS PEELING STRANDS OF FIBER. INSTALLED ON TTG8Q014RS42.SDR SWAA2025091707832Floor Panel · peelingMAIN CABIN FLOOR PANEL 241AF HAS PEELING STRANDS OF FIBER. INSTALLED ON TTG8Q014RSQG.SDR SWAA2025091707833Floor Panel · peelingMAIN CABIN FLOOR PANEL 241FF HAS PEELING STRANDS OF FIBER. INSTALLED ON TTG8Q014RSQR.SDR SWAA2025091707834Floor Panel · peelingMAIN CABIN FLOOR PANEL 241EF HAS PEELING STRANDS OF FIBER. INSTALLED ON TTG8Q014RSQR.SDR SWAA2025091707835Floor Panel · peelingMAIN CABIN FLOOR PANEL 241DF HAS PEELING STRANDS OF FIBER. INSTALLED ON TTG8Q014RSR5.SDR SWAA2025091707837Floor Panel · peelingMAIN CABIN FLOOR PANEL 242DF HAS PEELING STRANDS OF FIBER. INSTALLED ON TTG8Q014RSRE.SDR SWAA2025091707840Floor Panel · peelingMAIN CABIN FLOOR PANEL 242EF HAS PEELING STRANDS OF FIBER. INSTALLED ON TTG8Q014RSRV.SDR SWAA2025091707844Floor Panel · peelingMAIN CABIN FLOOR PANEL 242GF HAS PEELING STRANDS OF FIBER. INSTALLED ON TTG8Q014RS52.SDR SWAA2025091707845Floor Panel · peelingMAIN CABIN FLOOR PANEL 241NF HAS PEELING STRANDS OF FIBER. INSTALLED ON TTG8Q014RSS8.SDR SWAA2025091707850Floor Panel · peelingMAIN CABIN FLOOR PANEL 241RF HAS PEELING STRANDS OF FIBER. INSTALLED ON TTG8Q014RSSS.SDR SWAA2025091707853Floor Panel · peelingMAIN CABIN FLOOR PANEL 242PF HAS PEELING STRANDS OF FIBER. INSTALLED ON TTG8Q014RSTC.SDR SWAA2025091707820Floor Panel · peelingMAIN CABIN FLOOR PANEL 231AF HAS PEELING STRANDS OF FIBER. INSTALLED ON TTG8Q014RS0Q.SDR SWAA2025091707797Floor Panel · peelingMAIN CABIN FLOOR PANEL 231BF HAS PEELING STRANDS OF FIBER. INSTALLED ON TTG8Q014RRMZ.SDR SWAA2025091707801Floor Panel · peelingMAIN CABIN FLOOR PANEL 232CF HAS PEELING STRANDS OF FIBER. INSTALLED ON TTG8Q014RRQG.SDR SWAA2025091707810Floor Panel · peelingMAIN CABIN FLOOR PANEL 231KF HAS PEELING STRANDS OF FIBER. INSTALLED ON TTG8Q014RRSF.SDR SWAA2025091707811Floor Panel · peelingMAIN CABIN FLOOR PANEL 232GF HAS PEELING STRANDS OF FIBER. INSTALLED ON TTG8Q014RRSN.SDR SWAA2025091707813Floor Panel · peelingMAIN CABIN FLOOR PANEL 232JF HAS PEELING STRANDS OF FIBER. INSTALLED ON TTG8Q014RRT2.SDR SWAA2025091707816Floor Panel · peelingMAIN CABIN FLOOR PANEL 232KF HAS PEELING STRANDS OF FIBER. INSTALLED ON TTG8Q014RRTL.