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 2025FA0000614Seat Track · corrodedLONGITUDINAL BEAM CORRODED AT FR 77 TO 80/82, TOP SURFACE AT FR 77 (-Y1137.1)SDR HALA2025090200613Seat Track · corrodedSEAT TRACK CORRODED AT FR 33.SDR HALA2025090200612Seat Track · corrodedSEAT TRACK CORRODED AT BETWEEN FR 36-37.SDR HALA2025090200611Seat Track · corrodedSEAT TRACK CORRODED AT FR 36.SDR HALA2025090200610Seat Track · corrodedSEAT TRACK CORRODED AT FR 33-37.SDR HALA2025090200609Seat Track · corrodedN399HA SEAT TRACK CORRODED AT FR 34-35 AND FR 37.1 (AFM 402)SDR HALA2025090200608Seat Track · corrodedSEAT TRACK CORRODED AT FR 33-34, FR 36-37.SDR HALA2025090200607Seat Track · corrodedSEAT TRACK CORRODED AT BW FR34-35.SDR HALA2025090200606Seat Track · corrodedSEAT TRACK CORRODED AT FR 33.SDR HALA2025090200605Seat Track · corrodedSEAT TRACK CORRODED AT FR 33, FR 35-37.SDR NACA2025090100001Boot · damagedLEFT COOLING PACK PLENUM BOOT IS DAMAGED. REMOVED AND REPLACED LH COOLING PACK PLENUM BOOT IAW AMM 21-51-07-004-001 AND 21-51-07-404-09 LEAK CK GOOD.SDR SWI2025F01554Slat Track · damagedRH WING SLAT TRACK 3-2 SIDE ROLLER INBD AND OUTBD FWD DAMAGE. (C-CHECK RO 11/22/2025)INSTALLED NEW/SERVICEABLE RH WING SLAT TRACT 3-2 (I/B FWD, I/B AFT, O/B FWD AND O/B AFT) SIDE ROLLERS PER CRJ700 AMM 27-81-44-400-803-A01SDR SWI2025F01553Slat Track · damagedRH WING SLAT TRACK 2-2 SIDE ROLLER INBD AND OUTBD AFT DAMAGE. (C-CHECK RO 11/22/2025)REMOVED AND INSTALLED INBD AND OUTBD AFT SIDE ROLLERS FOR THE R/H WING 2-2 SLAT TRACK . REF CRJ700 AMM 27-81-44-400-802-A01SDR SWI2025F01552Slat Track · damagedRH WING SLAT TRACK 1-2 SIDE ROLLER OUTBD AFT DAMAGE (C-CHECK RO 11/22/2025)REMOVED AND INSTALLED NEW OUTBD AND REPLACED THE INBD AFT SIDE ROLLERS FOR THE R/H WING 1-2 SLAT TRACK. REF CRJ700 AMM 27-81-44-400-801-A01SDR SWI2025F01551Roller · failed inspLH SLAT TRACK 3-2 IB FWD, IB AFT, OB FWD, OB AFT SIDE ROLLERS FAILED INSPECTION. (S/N 00798) (C-CHECK RO 11/22/2025)REMOVED AND INSTALLED 4 EA. NEW LH SLAT TRACK 3-2 IB FWD, IB AFT, OB FWD, OB AFT SIDE ROLLERS AS FOLLOWS. REF CRJ-700 AMM 27-81-44-400-803-A01SDR SWI2025F01550Roller · failed inspLH SLAT TRACK 2-2 IB FWD, IB AFT, OB FWD, OB AFT SIDE ROLLERS FAILED INSPECTION. (S/N 00797) (C-CHECK RO 11/22/2025)REMOVED AND INSTALLED NEW 4EA SLAT-TRACK SIDE ROLLERS AT THE L/H 2-2 SLAT TRACK, WITH 4EA SERVICEABLE SIDE ROLLERS REF CRJ700 AMM 27-81-44-400-SDR SWIA202511240901Roller · failed inspLEFT SLAT TRACK 1-2 INBD AFT AND OTBD AFT SIDE ROLLERS FAILED INSPECTION. REMOVED AND INSTALLED TWO NEW SLAT TRACKS 1-2 INBD AFT AND OTBD AFT SIDE ROLLERS. AMM 27-81-44-400-801-A01SDR AALA202511243806Fork · noneAIRCRAFT IN BASE MAINTENANCE: DUE TO THE MAJOR REPAIR BEING ACCOMPLISHED ON THE AFT AVIONIC COMPARTMENT RACK 80VU LEFT HAND LATERAL FITTING PER EA 367833, THE RIGHT-HAND LATERAL FORK END FITTING BETWEEN FR 23 AND FR 24 AT -Y1293 NEEDS TO BE REPLACED PER THE INSDR AALA202511242763Fitting · noneAIRCRAFT IN BASE MAINTENANCE: DUE TO THE MAJOR REPAIR BEING ACCOMPLISHED ON THE AFT AVIONIC COMPARTMENT RACK 80VU LEFT HAND LATERAL FITTING PER EA 367833, THE RIGHT-HAND LATERAL FITTING BETWEEN FR 23 AND FR 24 AT -Y1293 NEEDS TO BE REPLACED PER THE INSTRUCTIONSDR AALA202511243415Fork · noneAIRCRAFT IN BASE MAINTENANCE: DUE TO THE MAJOR REPAIR BEING ACCOMPLISHED ON THE AFT AVIONIC COMPARTMENT RACK 80VU LEFT HAND LATERAL FITTING PER EA 367833, THE LEFT-HAND LATERAL FORK END FITTING BETWEEN FR 23 AND FR 24 AT +Y1293 NEEDS TO BE REPLACED PER THE INSSDR AALA202511241200Fitting · wornAIRCRAFT IN BASE MAINTENANCE: AFT AVIONIC COMPARTMENT RACK 80VU LEFT HAND LATERAL FITTING WORN BETWEEN FR 23 AND FR 24 AT +Y1293. REPLACED LATERAL FITTING PER EA 367833.SDR AALA202511104654Beam · crackedAIRCRAFT IN BASE MAINTENANCE: SEGMENT BEAM MUST BE REPLACED BY EO 5210Y228-001. MAINTENANCE ACCOMPLISHED MODIFY OVERWING EMERGENCY EXIT DOOR 844 ON RH SIDE OF PASSENGER CABIN IN ACCORDANCE WITH MANUAL TALLY 110, EO 5210Y228-001.SDR AALA202511106975Beam · crackedAIRCRAFT IN BASE MAINTENANCE: SEGMENT BEAM MUST BE REPLACED BY EO 5210Y228-001. MAINTENANCE ACCOMPLISHED MODIFY OVERWING EMERGENCY EXIT DOOR 844 ON RH SIDE OF PASSENGER CABIN IN ACCORDANCE WITH MANUAL TALLY 110, EO 5210Y228-001.SDR AALA202511107941Beam · damagedAIRCRAFT IN BASE MAINTENANCE: SEGMENT MUST BE REPLACED BY EO 5210Y228-001. MAINTENANCE ACCOMPLISHED MODIFY OVERWING EMERGENCY EXIT DOOR 833 ON LH SIDE OF PASSENGER CABIN IN ACCORDANCE WITH MANUAL TALLY 109, EO 5210Y228-001.SDR AALA202511102080Beam · crackedAIRCRAFT IN BASE MAINTENANCE: SEGMENT BEAM MUST BE REPLACED BY EO 5210Y228-001. MAINTENANCE ACCOMPLISHED MODIFY OVERWING EMERGENCY EXIT DOOR 833 ON LH SIDE OF PASSENGER CABIN IN ACCORDANCE WITH MANUAL TALLY 109, EO 5210Y228-001.SDR AALA202511104126Beam · crackedAIRCRAFT IN BASE MAINTENANCE: SEGMENT BEAM MUST BE REPLACED BY EO 5210Y228-001. MAINTENANCE ACCOMPLISHED MODIFY OVERWING EMERGENCY EXIT DOOR 834 ON LH SIDE OF PASSENGER CABIN IN ACCORDANCE WITH MANUAL TALLY 107, EO 5210Y228-001.SDR AALA202511108915Beam · crackedAIRCRAFT IN BASE MAINTENANCE: SEGMENT BEAM MUST BE REPLACED BY EO 5210Y228-001. MAINTENANCE ACCOMPLISHED MODIFY OVERWING EMERGENCY EXIT DOOR 834 ON LH SIDE OF PASSENGER CABIN IN ACCORDANCE WITH MANUAL TALLY 107, EO 5210Y228-001.SDR AALA202511109520Beam · crackedAIRCRAFT IN BASE MAINTENANCE: SEGMENT BEAM MUST BE REPLACED BY EO 5210Y228-001. MAINTENANCE ACCOMPLISHED MODIFY OVERWING EMERGENCY EXIT DOOR 843 ON RH SIDE OF PASSENGER CABIN IN ACCORDANCE WITH MANUAL TALLY 108, EO 5210Y228-001SDR AALA202511106241Beam · crackedAIRCRAFT IN BASE MAINTENANCE: SEGMENT BEAM MUST BE REPLACED BY EO 5210Y228-001. MAINTENANCE ACCOMPLISHED MODIFY OVERWING EMERGENCY EXIT DOOR 843 ON RH SIDE OF PASSENGER CABIN IN ACCORDANCE WITH MANUAL TALLY 108, EO 5210Y228-001.SDR AALA202510309718Profile · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN EMERGENCY EXIT DOOR 844 RIGHT HAND LOAD TRANSMITTING PROFILE AFT SEGMENT. REPLACED AFT SEGMENT PER EO 5210Y228.SDR AALA202510303210Profile · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN EMERGENCY EXIT DOOR 833 LEFT HAND LOAD TRANSMITTING PROFILE AFT SEGMENT. REPLACED AFT SEGMENT PER EO 5210Y228.SDR AALA202510305614Profile · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN EMERGENCY EXIT DOOR 843 RIGHT HAND LOAD TRANSMITTING PROFILE AFT SEGMENT. REPLACED AFT SEGMENT PER EO 5210Y228.SDR AALA202510303819Profile · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN EMERGENCY EXIT DOOR 834 LEFT HAND LOAD TRANSMITTING PROFILE AFT SEGMENT. REPLACED AFT SEGMENT PER EO 5210Y228.SDR SWIA20251002901Rib · damagedRH WING LE RIB AT WS 86.45 HAS DAMAGE AROUND LIGHTENING HOLE. (FILED CLOSED)COMPLIED WITH REO 601R-57-41-1202 DATED: 2025-09-04 REV: --TEMPORARY REPAIR TO RH WING FIXED L/E WS 86.45 RIB LIGHTENING HOLE DAMAGE. ALL NDT'S COMPLIED WITH AND NO DEFECTS NOTED AT TSDR AALA202509302247Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ELEVATOR HINGE ARM END FITTING #1 ON L/H THS. MAINTENANCE REPLACED ELEVATOR HINGE-ARM END FITTING #1 ON LT THS IAW AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.SDR AALA202509233499Window · scratchedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY EXIT DOOR 834 WINDOW INNER AND OUTER PANE SCRATCHED. REPLACED WINDOW ASSEMBLY PER AMM 56-31-15.SDR IPXA2025091863260Wedge · damagedNR 2 SLAT I/B T/E WEDGE LWR SURFACE HAS GOUGE DOT 55-012 REPAIR RH WING #2 SLAT P/N: A57864200173, S/N: FH1636, IAW A300-600F SRM 57-43-11 PARAGRAPH 4.B AND FIGURE 202, APPLICABLE REPAIR PER SRM. REMOVED DAMAGED SKIN AND FABRICATED REPLACEMENT PARTS IAW-A300-SSDR AALA202509185276Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #5 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202509184967Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #4 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202509180064Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #3 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202509187239Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #6 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR IPXA2025091662656Frame · crackedNR 2 ENGINE PANEL 485AL O/B SIDE #1 STRINGER CRACKED. INSTALLED PART STRINGER #2 ENGINE PANEL 485AL O/B SIDE #1 IAW A300-600 SRM 51-40-21SDR IPXA2025091662750Frame · crackedNR 1 ENGINE PPANEL 475AL I/B SIDE #7 STRINGER FROM FRONT CRACKED DT 1/042 INSTALLED FRAME #7 AT 475AL USING FASTNERS IAW SRM-51-40-21SDR IPXA2025091662589Frame · crackedNR 2 ENGINE PANEL 485AL HAS CRACK ON I/B SIDE #7 FRAME FROM FRONT. INSTALLED FRAME #7 AT 485AL USING FASTENERS IAW A300-600-SRM-51-40-21SDR AALA202509172709Hinge Arm · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR NR 1 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202509176420Hinge Arm · excess playAIRCRAFT IN BASE MAINTENANCE: LEFT HAND HORIZONTAL STABILIZER ELEVATOR NR 4 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202509178765Hinge Arm · excess playAIRCRAFT IN BASE MAINTENANCE: LEFT HAND HORIZONTAL STABILIZER ELEVATOR NR 6 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202509177972Hinge Arm · excess playAIRCRAFT IN BASE MAINTENANCE: LEFT HAND HORIZONTAL STABILIZER ELEVATOR NR 3 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202509178284Hinge Arm · excess playAIRCRAFT IN BASE MAINTENANCE: LEFT HAND HORIZONTAL STABILIZER ELEVATOR NR 2 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202509177252Hinge Arm · excess playAIRCRAFT IN BASE MAINTENANCE: LEFT HAND HORIZONTAL STABILIZER ELEVATOR NR 5 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.