JASC 5311
Service difficulty reports · 61,554
Reports filed under 5311 · Fuselage Main, Frame, 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 = '5311' 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 = '5311' 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 KCSA081104Frame · dentedFUSELAGE FRAME IS DENTED AT STA 1860, STR 11R.SDR 08FDEA00568Frame · crackedFWD CARGO PIT, FRAME EXTENSION AT BS 520 IS CRACKED IN UPPER RADIUS, ABOVE STRINGER 22L ON FWD SIDE OF FRAME, MARKED END OF CRACK WITH BLACK DOT, (CIRCLED) GENERATED FROM U/C 53F0020. REMOVED CRACKED FRAME EXTENSION. VERIFIED MATERIAL FOR FABRICATION OF NESDR 08FDEA00559Frame · chafedFOUND SEVERAL CHAFING MARKS ON INNER FLANGE OF FRAME C28, P 13-22 LT. REPAIR PERFORMED BY BLEND OUT THE AREAS AND NDT FOR CRACK FREE IAW RAS/DABRE/7008942/2008 ISS A, APPROVED BY EA 6-5314-115244.SDR 08FDEA00558Frame · chafedFOUND SEVERAL CHAFING MARKS ON INNER FLANGE OF FRAME C28, P 9-12 LT. REPAIR PERFORMED BY BLEND OUT THE AREAS AND NDT FOR CRACK FREE IAW RAS/DABRE/7008942/2008 ISS A, APPROVED BY EA 6-5314-115244.SDR TRAX200800303Frame · corrodedFUSELAGE FRAME AT FS 349.0 HAS CORROSION AT BL 0. REMOVED CORROSION, DAMAGE FOUND WITHIN LIMITS IAW SRM 51-21-06.SDR TRAX200800301Frame · corrodedAAR - FUSELAGE FRAME AT FS 333.0 HAS CORROSION BL 0 TO LBL 9.
SDR SWAA080986Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA080985Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727B, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA080984Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME PER SWA EA.SDR KCSA081100Frame · corrodedFUSELAGE FRAME UPPER CHORD CORRODED AT BS 2220, RBL 58, ABOVE STR-40R.SDR NWAA081396310Frame · crackedDURING "M" CHECK, FOUND CRACK IN FRAME WEB AT BS 2664 LT WL 310. REPAIRED PER EA 63-211713.SDR UPS08851792Frame · crackedINSPECTION TYPE:C2 A/C COMPARTMENT STA 55 L24L FRAME IS CRACKED AT DUCT ATTACH ROD CLIP. REPAIRED A/C COMPARTMENT FRAME AND SHEAR TIE AT STA 55 AND L24L IAW SRM 53-02-00 FIG 002, SRM 53-02-00 FIG 2B, SRM 51-9-0 FIG 068A.SDR MALA080025Frame · corrodedDURING HEAVY CHECK REPAIRED FRAME AT STA 294.0 BETWEEN BL 0.0 AND BL 18.3 IAW EO NR S53108.SDR SWAA080962Frame · corrodedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 847, STR 26L. REPAIRED FRAME PER SRM.SDR SWAA080963Frame · corrodedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 787, STR 27L. REPAIRED FRAME PER SRM.SDR HALA0800336Frame · corrodedLEVEL 1 CORROSION, ON RADOME INTERNAL FORMER RING. REPAIR IN WORK.SDR HALA0800345Frame · corrodedLEVEL 1 CORROSION, FWD CARGO PIT STA 465, ON FRAME AROUND FASTENERS, L 29R. REPAIR IN WORK.SDR GLBA20061070Frame · cracked02/18/08, FRAME CRACKED AT STR 9R CUTOUT. CRACK APPROX .500 IN LENGTH AT FS 177.35. MAINT REPAIRED FRAME CRACK AT STR RELIEF HOLE AT FS 177.35 AND STR 9R IAW SRM 51-70. REPAIR APPROX 5 INCH X 2.5 INCH 2024 T-3 .071. RII INSP C/W IAW TASKCARD 8.2.1.SDR SWAA080940Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA080946Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727B, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA080947Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA080948Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA080949Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA080950Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727D, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA080951Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA080952Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727D, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA080934Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 767, STR 13L. REPAIRED FRAME PER SRM.SDR DLM90080240Frame · crackedRIGHT MLG BAY FORWARD FRAME CRACKED APPROXIMATELY FS 1019 RBL 56.5. REMOVED AND REPLACED RIGHT MLG BAY FORWARD FRAME, IAW MD90 SRM 51-30-02, 51-30-05 AND 51-10-03.SDR 08FDEA00514Frame · crackedFWD CARGO PIT, FRAME EXTENSION AT BS 600 IS CRACKED IN UPPER RADIUS, ABOVE STR 22L ON FWD SIDE OF FRAME. MARKED END OF CRACK WITH BLACK DOT CIRCLE. GENERATED FROM W/C 53F0020. FABRICATED FRAME EXTENSION REF DWG 53FX1350. HEAT TREATED TO T-6 CONDITION ON 81SDR DLM90080230Frame · crackedAFT OF LEFT HYDRAULIC SERVICE BOX SUPPORT IS CRACKED. REMOVED AND REPLACED OUTBOARD FRAME, IAW MD90 SRM 51-30-02 AND 51-30-05.SDR DLM90080229Frame · chafedLEFT MAIN LANDING GEAR BAY FORWARD FRAME CHAFED FS 1003 LBL36. REMOVED AND REPLACED INBOARD FORWARD FRAME, IAW MD90 SRM 51-30-02 AND 51-30-05.SDR SWAA080892Frame · corrodedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 847, STR 27L. REPAIRED FRAME PER FRAME PER SRM.SDR SWAA080874Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 807, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA080873Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8R. REPAIRED FRAME PER SWA EA.SDR TRAX200800278Frame · corrodedFS 349 FRAME IS CORRODED AT BL 0.SDR TRAX200800277Frame · corrodedFS 319 FRAME IS CORRODED AT BL 0.SDR TRAX200800275Frame · corrodedFS 333 FRAME IS CORRODED AT BL 0.SDR SWAA080863Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 294.5, STR 7R. REPAIRED FRAME PER SWA EA.SDR SWAA080864Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 482, STR 8R AND STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA080865Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 482A, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA080868Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA080867Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA080866Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 559, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWIA200819254Frame · corrodedSIGNS OF CORROSION FOUND ON FRAME 21. REPAIRED IAW IC2008-120/01433, AND IAW 51-40-02.
SDR COMA0860138Doubler · crackedRIGHT FS 640.00 FRAME DOUBLER IS CRACKED BETWEEN STR 9 AND STR 12. REMOVED FRAME DOUBLER P/N 601-36001-30 AND INSTALLED SERVICEABLE FRAME DOUBLER P/N 601-36001-30S IAW CRJ SRM 51-00-00 AND SR99-5140-0001.SDR 08FDEA00461Frame · damagedMAIN DECK, FRAME DOUBLER AT RIGHT STA 1701 LONGERON 12 FOUND WITH DENT. REPAIRED AS PER SRM 53-30-00 FIGURE 1 VOLUME I. REPETITIVE INSPECTION REQUIRED, INITIAL INSPECTION AT 14,500 CYCLES AND REPETITIVE INSPECTIONS AT 9,500 CYCLES AS PER SRM 53-30-00 FIGURE 1SDR KCSA081081Frame · crackedFUSELAGE FRAME IS CRACKED (.25") AT STA 1800 BETWEEN STR 10R & 11R.SDR SWIA200819604Frame · crackedLEFT SIDE OF STA 621 MOST OUTBOARD FLOOR FRAME IS CRACKED, FOUND AT C-CHECK. COMPLIED WITH REPAIRS PER CRJ200 REO 601R 53-61-117 REV C DATED 2004-AUG-25.SDR CALA0800156Frame · crackedFRAME CRACKED AT STA 440 BETWEEN STRINGER 8 AND 9L. REPAIRED PER ECRA 5310-04717.SDR CALA0800155Frame · crackedFRAME CRACKED AT STA 440 BETWEEN 8 & 9R. REPAIRED PER SRM 5210-04717.
Back to JASC 5311