Boeing 737-3H4
Service difficulty reports · 52,340
Newest first. 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' WHERE aircraft_model_key = '7373H4' 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 aircraft_model_key = '7373H4' 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 SWAA2014040726867Skin · crackedFUSELAGE SKIN CRACKED AT BS 951+11, STRINGER 17R. REPAIRED SKIN IAW SRM.SDR SWAA2014040326792Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 947.5, STRINGER 25R. R & R STRINGER TIE IAW EA.SDR SWAA2014040126720Frame · crackedFRAME CRACKED AT BS 492.4, STRINGER 24R. R & R FRAME IAW SRM & DWG.SDR SWAA2014040126719Bracket · crackedAFT CARGO BAY BRACKET CRACKED AT BS 807, STRINGER 25R. R & R BRACKET IAW SRM & DWG.SDR SWAA2014040126718Web · crackedWEB CRACKED BETWEEN BS 787 - 807, RBL 17. R & R WEB IAW SRM & DWG.SDR SWAA2014040126705Hook · corrodedRIGHT EMERGENCY EXIT ESCAPE STRAP HOOK CORRODED. R & R HOOK IAW AMM.SDR SWAA2014033126647Keelbeam · corrodedKEEL BEAM CORRODED AT BS 520+2.5, STRINGER 28L. REPAIRED KEEL BEAM IAW SRM.SDR SWAA2014033126646Support Bracket · crackedFORWARD CARGO COMPARTMENT SUPPORT BRACKET CRACKED AT BS 500C, STRINGER 26R. R & R BRACKET IAW SRM & DWG.SDR SWAA2014033126645Keelbeam · corrodedKEEL BEAM CORRODED AT BS 500D+3.5, STRINGER 28L. REPAIRED ON KEEL BEAM IAW SRM.SDR SWAA2014033126644Stringer · corrodedSTRINGER CORRODED AT BS 947.5+2, STRINGER 27L. REPAIRED STRINGER IAW SRM.SDR SWAA2014033126643Web · crackedAFT CARGO COMPARTMENT SUPPORT ANGLE OF WEB CRACKED AT BS 947.5, STRINGER 25R. R & R WEB IAW SRM & DWG.SDR SWAA2014033126642Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 400, STRINGER 26L. R & R ANGLE IAW SRM & DWG.SDR SWAA2014032726555Bulkhead · crackedDOME CAP WEB CRACKED AT BS 1016, STRINGER 7L. REPAIRED DOME CAP WEB IAW SRM.SDR SWAA2014032726554Intercostal · crackedINTERCOSTAL CRACKED AT BS 540, BETWEEN BL 0 TO RBL 24.5. R & R INTERCOSTAL IAW SRM & DWG.SDR SWAA2014032626529Angle · crackedAFT CARGO COMPARTMENT UPPER FLOOR STRUCTURE WEB ANGLE BETWEEN BS 927 TO BS 947.5, BL 0. R & R ANGLE IAW SRM & DWG.SDR SWAA2014032426478Tie Clip · crackedTIE CLIP CRACKED AT BS 787, STRINGER 24R. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014032426477Tie Clip · crackedTIE CLIP CRACKED AT BS 787, STRINGER 20R. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014032426387Channel · crackedMAIN DECK FLOOR STRUCTURE FWD CARGO COMPARTMENT CHANNEL CRACKED AT BS 540, BETWEEN BL 0 TO LBL 24.5. R & R CHANNEL IAW SRM & DWG.SDR SWAA2014032426375Tie Clip · crackedTIE CLIP CRACKED AT BS 727E, STRINGER 20L. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014031726117Skin · crackedSKIN CRACKED BETWEEN BS 383.5 TO 385.2, STRINGER 15R. REPAIRED SKIN IAW EA.SDR SWAA2014031125948Support Fitting · crackedMAIN WW SUPPORT FITTING CRACKED AT BS 727, LBL 4. R & R FITTING IAW SRM & DRAWING.SDR SWAA2014041427049Door Frame · crackedAFT CARGO COMPARTMENT FWD EDGE FRAME LOWER CORNER CRACKED. REPAIRED FRAME IAW EA.SDR SWAA2014041127040Fitting · crackedRIGHT NLG DOOR CTR FITTING CRACKED. R & R FITTING IAW SRM.SDR SWAA2014041127039Skin · crackedFUSELAGE SKIN CRACKED AT STATION 251.6, 10 INCHES BELOW STRINGER 24L. REPAIRED SKIN IAW EA.SDR SWAA2014041026975Skin · crackedFUSELAGE SKIN CRACKED AT BS 251.6, STRINGER 24L. REPAIRED SKIN IAW EA.SDR SWAA2014040726838Skin · crackedFUSELAGE SKIN CRACKED AT BS 328, STRINGER 17R. REPAIRED SKIN IAW EA.SDR SWAA2014040326791Floorbeam · crackedCROSSBEAM LOWER FLANGE CRACKED AT BS 947.5, LBL 55. REPAIRED FLANGE IAW EA.SDR SWAA2014040226764Stiffener · crackedSTIFFENER CRACKED AT BS 727, STRINGER 27L. R & R STIFFENER IAW SRM & DWG.SDR SWAA2014032826600Rib · crackedLEFT HORIZONTAL STAB LE RIB CRACKED AT STATION 133.15. R & R RIB IAW SRM.SDR SWAA2014032626528Skin · delaminatedLEFT WING INBD AFT FLAP LOWER SKIN DELAMINATED. REPAIRED AFT FLAP IAW SRM.SDR SWAA2014032626527Tie Clip · crackedTIE CLIP CRACKED AT BS 727A, STRINGER 25L. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014032426473Plate · crackedLEFT MAIN WW PLATE CRACKED BETWEEN BS 727 TO BS 727A, STRINGER 22L. R & R PLATE IAW SRM.SDR SWAA2014032426386Stop Fitting · crackedDOOR STOP FITTING CRACKED SKIN AT BS 303.9, STRINGER 7L. R & R FITTING IAW SRM.SDR SWAA2014032426374Support Fitting · crackedSUPPORT CLIP CRACKED AT BS 947.5, STRINGER 25L. R & R CLIP IAW SRM & DWG.SDR SWAA2014031926231Reveal · crackedL1 DOOR CUT OUT FWD UPPER CORNER REVEAL CRACKED. R & R REVEAL IAW SRM & DWG.SDR SWAA2014031726116Skin · crackedFUSELAGE SKIN CRACKED AT BS 727B & 4, STRINGER 1. REPAIRED SKIN IAW ER & EA.SDR SWAA2014031025891Plate · crackedLT NACELLE SPLICE PLATE CRACKED AT BS 234, UPPER PYLON FRAME. R & R PLATE IAW SRM.SDR SWAA2014040926947Skin · crackedFUSELAGE SKIN CRACKED AT BS 251.6, STRINGER 24L. REPAIRED SKIN IAW EA.SDR SWAA2014040726837Fitting · crackedRT PYLON AFT STRUT FAIRING T ANGLE FITTING CRACKED. REPAIRED FITTING IAW EA.SDR SWAA2014040326801Angle · crackedLOWER SPLICE ANGLE CRACKED AT BS 360, STRINGER 11L. R & R ANGLE IAW EA.SDR SWAA2014040326790Access Panel · crackedRIGHT WING ACCESS PANEL 5864R CRACKED. REPAIRED ACCESS PANEL IAW EA.SDR SWAA2014040126717Attach Angle · crackedRIGHT HORIZONTAL STABILIZER LOWER ATTACH ANGLE CRACKED ON CENTER SECTION. R & R ANGLE IAW SRM & DWG.SDR SWAA2014032626546Door Frame · crackedAFT CARGO COMPARTMENT DOOR FWD LOWER CORNER FRAME CRACKED. R & R DOOR IAW AMM 52-31-00.SDR SWAA2014032426371Door Frame · crackedAFT CARGO COMPARTMENT DOOR, FWD LOWER CORNER FRAME CRACKED. R & R DOOR IAW AMM 52-31-00.SDR SWAA2014032426364Tee Fitting · crackedT CHORD CRACKED AT BS 540, BETWEEN STRINGER 28L TO STRINGER 22L. R & R T CHORD IAW SRM & DWG.SDR SWAA2014031826191Nut Plate · crackedLEFT WING NUT STRIPS CRACKED AT WBL 198.6, STRINGER 11L. R & R NUT STRIPS IAW SRM.SDR SWAA2014031826190Nut Plate · crackedLEFT WING NUT STRIPS CRACKED BETWEEN WBL 191.0 TO WBL 183.4, BETWEEN STRINGER 11L TO STRINGER 12L. R & R NUT STRIPS IAW SRM & DWG.SDR SWAA2014031726115Frame · crackedFRAME WEB CRACKED AT BS 291.5, STRINGER 16R. REPAIRED WEB IAW ER & EA.SDR SWAA2014031726114Frame · crackedFRAME WEB CRACKED AT BS 291.5, STRINGER 16R. REPAIRED FRAME IAW ER & EA.SDR SWAA2014031125953Plate · crackedRT HORIZONTAL STABILIZER ACCESS PANEL 9226R PLATE CRACKED. R & R PLATE IAW SRM & DRAWING.
Back to Boeing 737-3H4