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 SWAA097129Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 20L TO STR 21L. REPAIRED FRAME PER SRM AND ER.SDR SWAA097128Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500B, STR 20R TO STR 21R. REPAIRED FRAME PER SRM AND ER.SDR SWAA097127Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 663.75, STR 2R. REPAIRED FRAME PER SRM AND ER.SDR SWAA097126Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500B, STR 20R TO STR 21R. REPAIRED FRAME PER SRM AND ER.SDR USAA2009110993066Frame · crackedCLT - MAJOR REPAIR - Q1 CHECK - CRACKED FRAME AT BS 727D, S8R - S9R. REPAIRED FRAME AT BS 727D, S8R - S9R IAW TYPICAL REPAIR 53-10-20E.SDR SWAA097088Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500D, STR 15L. REPAIRED FRAME PER SRM.SDR SWAA097087Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500B, BETWEEN STR 15R & STR 16R. REPAIRED FRAME PER SRM.SDR SWAA097085Frame · corrodedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 227, BL 0. REPAIRED FRAME PER ER.SDR USAA2009110693053Frame · crackedPIT - MAJOR REPAIR - SEAT MODIFICATION - CRACKED FRAME AT BS 440, S24R. REPAIRED FRAME AT BS 440, S24R IAW EA 113834.SDR SWAA097060Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 500D, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER SRM.SDR SWAA097058Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 500D, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER SRM.SDR SWAA097057Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 500C, BETWEEN STR 20R TO STR 21R. REMOVED AND REPLACED FRAME PER SRM.SDR USAA2009113093263Frame · crackedCLT - Q1 - MAJOR REPAIR - CRACK ON FUSELAGE FRAME AT BS 500B BETWEEN S19R TO S20R. REPAIRED FUSELAGE FRAME AT BS 500B BETWEEN S19R TO S20R IAW B737 SRM 53-00-07 REPAIR 13.SDR USAA2009112393192Frame · crackedCLT - Q1 - MAJOR REPAIR - CRACK ON FUSELAGE FRAME AT BS 380 BETWEEN S20L TO S22L. REPAIRED FUSELAGE FRAME AT BS 380 BETWEEN S20L TO S22L IAW TYPICAL REPAIR 53-60-07.SDR USAA2009111393100Frame · crackedCLT - Q1 - MAJOR REPAIR - CRACK ON FUSELAGE FRAME BS 380 BETWEEN S20L & S22L. REPAIRED FUSELAGE FRAME BS 380 BETWEEN S20L & S22L IAW TYPICAL REPAIR 53-60-07.SDR GLBA20091104JFrame · bentDURING ROUTINE SCHEDULED MAINTENANCE A FRAME WAS FOUND BENT AT F.S. 451 BETWEEN STRINGER 6R & 7R. DAMAGE FOUND UNDER PREVIOUS REPAIR TO FUSELAGE SKIN. MAINTENANCE REPLACED THE DAMAGED FRAME AND PERFORMED THE REQUIRED II INSPECTIONS AT F.S. 451 BETWEEN STRINGERSDR USAA2009110993065Frame · crackedCLT - MAJOR REPAIR - Q1 CHECK - CRACKED FRAME AT BS 727B, S8L - S9L. REPAIRED FRAME AT BS 727B, S8L - S9L IAW TYPICAL REPAIR 53-10-20E.SDR SWAA097028Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FWD CARGO BAY FRAME CRACKED AT BS 500B, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER SRM.SDR SWAA097027Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FWD CARGO BAY FRAME CRACKED AT BS 520, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER SRM.SDR SWAA097026Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FWD CARGO BAY FRAME CRACKED AT BS 500D, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER SRM.SDR SWAA097025Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FWD CARGO BAY FRAME CRACKED AT BS 500C, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER SRM.SDR SWAA097024Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FWD CARGO BAY FRAME CRACKED AT BS 500B, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER SRM.SDR CALA2009110500676Frame · crackedB737-53-3-0739 CABIN FRAME CRACKED AT STA 400 BETWEEN STRINGER 8 AND 9 RIGHT (PSU RAIL). REPAIRED CABIN FRAME AT STA 400 BETWEEN STRINGER 8 AND 9 RIGHT REF EC/RA: 5310-05038.SDR CALA2009110500675Frame · crackedB737-53-3-0739 CABIN FRAME CRACKED AT STA 480 BETWEEN STRINGER 8 AND 9 RIGHT (PSU RAIL). REPAIRED CABIN FRAME AT STA 480 BETWEEN STRINGER 8 AND 9 RIGHT PER EC/RA: 5310-05038.SDR CALA2009110500674Frame · crackedB737-53-3-0739 CABIN FRAME AT STA 400 BETWEEN STRINGER 8 AND 9 LEFT (PSU RAIL) CRACKED. REPAIRED CABIN FRAME AT STA 400 BETWEEN STRINGER 8 AND 9 LEFT REF ECRA 5310-05038.SDR CALA2009110500673Frame · crackedB737-53-3-0739 CABIN FRAME CRACKED AT STA 440 BETWEEN STRINGER 8 AND 9 RIGHT (PSU RAIL) . REPAIRED CABIN FRAME AT STA 440 BETWEEN STRINGER 8 AND 9 RIGHT REF EC/RA: 5310-05038.SDR SWAA097004Frame · corrodedDURING SCHEDULED SPV CHECK, FOUND FRAME CORRODED AT BS 500D, STR 27R. REPAIRED FRAME PER SRM.SDR SWAA097002Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 500A, BETWEEN STR 28R TO STR 28L. REPAIRED FRAME PER SRM.SDR SWAA096983Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 440, BETWEEN STR 8R TO STR 9R. REPAIRED FRAME PER SRM.SDR SWAA096982Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 400, BETWEEN STR 8R TO STR 9R. REPAIRED FRAME PER SRM.SDR SWAA096981Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 400, BETWEEN STR 8L TO STR 9L. REPAIRED FRAME PER SRM.SDR SWAA096980Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 867, BETWEEN STR 8R TO STR 9R. REPAIRED FRAME PER SRM.SDR SWAA096979Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 727D, BETWEEN STR 8L TO STR 9L. REPAIRED FRAME PER SRM.SDR SWAA096974Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 500D, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER SRM.SDR COMA2009110550204Frame · crackedFOUND CRACK AT RT SIDE FS 640.00 STR 9 CUTOUT. REMOVED DAMAGE AND INSTALLED REPAIR DOUBLER IAW REO 601R-53-61-557.SDR FDEA200911043819Frame · dentedAFT CARGO COMPARTMENT FRAME DENTED AT STA 1500 AT S-25R. DENTED FRAME AT STA 1500 OF AFT CARGO COMPARTMENT REPAIRED IAW SRM 53-00-07, REPAIR 5, FIG. 201 DETAIL I, REV. 98. REPAIR IS CLASSIFIED AS MAJOR IAW GMM 6-2-100.SDR FDEA200911043818Frame · dentedAFT CARGO COMPARTMENT FRAME DENTED AT STA 1560, AT S-26R. DENTED FRAME AT STA 1560 REPAIRED IAW SRM 53-00-07 REPAIR 5, FIG. 201, DETAIL II, REV. 98. REPAIR IS CLASSIFIED AS MAJOR IAW GMM 6-2-100.SDR FDEA200911043817Frame · dentedAFT CARGO COMPARTMENT FRAME DENTED AT STA 1540, BETWEEN S-26L AND S-27L. DENTED FRAME IN AFT CARGO COMPARTMENT AT STA 1540 REPAIRED IAW SRM 53-00-07, REPAIR 5, DETAIL I, FIG. 201. REPAIR IS CLASSIFIED AS MAJOR IAW GMM 6-2-100 CRITERIA.SDR FDEA200911043816Frame · dentedAFT CARGO COMPARTMENT FRAME DENTED/CREASED AT STA 1520, BETWEEN S-25L AND S-26L. DENTED FRAME IN AFT CARGO COMPARTMENT AT STA 1520 REPAIRED IAW SRM 53-00-07, REPAIR 5, FIG 201, DETAIL III, REV. 98. REPAIR IS CLASSIFIED AS MAJOR IAW GMM 6-2-100 CRITERIA.SDR FDEA200911043815Frame · dentedAFT CARGO COMPARTMENT FRAME DENTED AT STA 1500 BETWEEN S-25L AND S-26L. DENTED AFT CAGRO COMPARTMENT FRAME AT STA 1500 REPAIRED IAW SRM 53-00-07 REPAIR 5, FIG 201, DETAIL III, REV. 98. REPAIR IS CLASSIFIED AS MAJOR IAW GMM 6-2-100 CRITERIA.SDR FDEA200911043814Frame · dentedAFT CARGO COMPARTMENT FRAME DENTED/CREASED AT STA 1460, BETWEEN S-25L AND S-26L. DENTED FRAME AT STA 1460 REPAIRED IAW SRM 53-00-07 REPAIR 5, FIG. 201, DETAIL III, REV. 98. REPAIR IS CLASSIFIED AS MAJOR IAW GMM 6-2-100 CRITERIA.SDR FDEA200911043813Frame · dentedAFT CARGO COMPARTMENT FRAME DENTED/CREASED AT STA 1440, S-25L TO S-26L. DENTED FRAME AT STA 1440 REPAIRED IAW SRM 53-00-07 REPAIR 5, DETAIL I, FIG 201, REV 98. REPAIR IS CLASSIFIED AS MAJOR IAW GMM 6-2-100 CRITERIA.SDR FDEA200911043812Frame · dentedAFT CARGO COMPARTMENT FRAME AT STA 1380, DENTED/CREASED AT S-26L. DENTED FRAME AT STA 1380 REPAIRED IAW SRM 53-00-07 REPAIR 5 DETAIL I FIG 201, REV 98. REPAIR IS CLASSIFIED AS MAJOR IAW GMM 6-2-100 CRITERIA.SDR FDEA200911043811Frame · dentedAFT CARGO COMPARTMENT FRAME AT STA 1340, DENTED/CREASED FROM S-25L TO S-26L. DENTED FRAME AT STA 1340 REPAIRED IAW SRM 53-00-07 REPAIR 5 DETAIL III FIG 201, REV 98. REPAIR IS CLASSIFIED AS MAJOR IAW GMM 6-2-100 CRITERIA.SDR FDEA200911043810Frame · dentedAFT CARGO COMPARTMENT FRAME DENTED/CREASED AT STA 1340, BETWEEN S-26R AND S-27R. DENTED FRAME AT STA 1340 REPAIRED IAW SRM 53-00-07 REPAIR 5 FIG 201 DETAIL I REV 98. REPAIR IS CLASSIFIED AS MAJOR IAW GMM 6-2-100 CRITERIA.SDR CA091104001Frame · cracked(CAN) WHILE CARRYING OUT THE KEELBEAM INSP, A SOOTY SUBSTANCE WAS OBSERVED IN THE AREA OF THE BEND OF THE LWR FRAME AT FUSELAGE STA 240.5 STR 32P AND 32S. AVIONICS RACKS WERE REMOVED FROM ABOVE THE LOCATION TO AFFORD A BETTER EXAMINATION. AS SEEN IN THE ATTASDR USAA2009110493032Frame · crackedCLT - MAJOR REPAIR - Q1 CHECK - CRACKED FRAME AT BS 727E, S8L - S9L. REPAIRED FRAME AT BS 727E, S8L - S9L IAW TYPICAL REPAIR 51-10-20E.SDR USAA2009110493031Frame · crackedCLT - MAJOR REPAIR - Q1 CHECK - CRACKED FRAME AT BS 727B, S8R - S9R. REPAIRED FRAME AT BS 727B, S8R - S9R IAW TYPICAL REPAIR 51-10-20E.SDR USAA2009110493030Frame · crackedCLT - MAJOR REPAIR - Q1 CHECK - CRACKED FRAME AT BS 867, S8L - S9L. REPAIRED FRAME AT BS 867, S8L - S9L IAW TYPICAL REPAIR 51-10-20E.SDR USAA2009110493029Frame · crackedCLT - MAJOR REPAIR - Q1 CHECK - CRACKED FRAME AT BS 787, S8L - S9L. REPAIRED FRAME AT BS 787, S8L - S9L IAW TYPICAL REPAIR 51-10-20E.
Back to JASC 5311