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 SWAA2014061228977Frame · corrodedFRAME ANGLE CORRODED AT BS 747, BETWEEN STRINGER 26R TO STRINGER 27R. REPAIRED FRAME IAW SRM.SDR SWAA2014061028891Frame · crackedFRAME INNER CHORD CRACKED AT BS 348.2, STRINGER 17L. R & R CHORD IAW SRM & EA.SDR SWAA2014060228584Frame · corrodedFRAME CORRODED AT BS 867, BETWEEN STRINGER 27L TO 27R. REPAIRED FRAME IAW SRM.SDR SWAA2014052128218Fitting · crackedCLIP CRACKED AT BS 348.2, STRINGER 15L. R & R CLIP IAW SRM & DWG.SDR SWAA2014052128217Fitting · crackedINTERNAL ANGLE CLIP CRACKED BETWEEN BS 348.2 TO BS 351.2, STRINGER 16L. R & R CLIP IAW SRM & DWG.SDR SWAA2014051928102Fitting · corrodedCLIP CORRODED AT BS 847, AT STRINGER 26R. R & R CLIP IAW SRM & DWG.SDR SWAA2014051628074Plate · crackedL1 DOOR LOWER SEAL SWEEPER RETAINER PLATE CRACKED. R & R PLATE IAW SRM & DWG.SDR SWAA2014051628064Angle · crackedAFT CARGO COMPARTMENT ANGLE CRACKED AT BS 947.5, BETWEEN STRINGER 24R TO STRINGER 25R. R & R ANGLE IAW SRM & DWG.SDR SWAA2014051427999Tie Clip · crackedTIE CLIP CRACKED AT BS 747, STRINGER 20L. R & R TIE CLIP IAW SRM.SDR SWAA2014051427998Tie Clip · brokenTIE CLIP BROKEN AT BS 787, STRINGER 23R. R & R TIE CLIP IAW SRM.SDR SWAA2014051427982Shear Tie · corrodedSHEAR TIE CORRODED AT BS 520, BETWEEN STRINGER 27L TO STRINGER 28L. R & R SHEAR TIE IAW SRM & DWG.SDR SWAA2014050827792Tie Clip · crackedTIE CLIP CRACKED AT BS 947.5, STRINGER 25R. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014050227590Stringer Splice · damagedSTRINGER SPLICE DAMAGED AT STATION 663, STRINGER 4R. R & R SPLICE IAW SRM.SDR SWAA2014042927507Tie Clip · crackedTIE CLIP CRACKED AT BS 727A, STRINGER 19L. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014042827430Tie Clip · crackedTIE CLIP CRACKED AT BS 747, STRINGER 22L. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014042827429Tie Clip · crackedTIE CLIP CRACKED AT BS 747, STRINGER 21L. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014042827428Tie Clip · crackedTIE CLIP CRACKED AT BS 727E, STRINGER 20L. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014042827427Tie Clip · crackedTIE CLIP CRACKED AT BS 727D, STRINGER 20L. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014042827426Tie Clip · crackedTIE CLIP CRACKED AT BS 727C, STRINGER 20L. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014042827425Tie Clip · crackedTIE CLIP CRACKED AT BS 727B, STRINGER 20L. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014042827424Tie Clip · crackedTIE CLIP CRACKED AT BS 727B, STRINGER 25L. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014042827423Tie Clip · crackedTIE CLIP CRACKED AT BS 727A, STRINGER 20L. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014042227308Lens · brokenFORWARD SERVICE DOOR EMERGENCY EXIT LENS BROKEN. R & R LENS ASSEMBLY IAW MM.SDR SWAA2014061729125Web · corrodedWEB CORRODED AT BS 1016, LBL 2. REPAIRED WEB IAW EA.SDR SWAA2014061729126Frame · corrodedFRAME CORRODED AT BS 847, BETWEEN STRINGER 27R TO 27L. REPAIRED FRAME IAW EA.SDR SWAA2014061629066Support Channel · corrodedSUPPORT CHANNEL CORRODED BETWEEN BS 727C TO 727D BETWEEN STRINGER 27R TO 27L. REPAIRED CHANNEL IAW SI.SDR SWAA2014060628777Door Frame · crackedAFT FRAME OF FWD CARGO DOOR CUT OUT CRACKED AT BS 492, STRINGER 24R. R & R FRAME IAW SRM & DWG.SDR SWAA2014051928101Skin · crackedRIGHT WING EXTERNAL SKIN CRACKED AT STATION 208, INBD SIDE. REPAIRED SKIN IAW EA.SDR SWAA2014051427997Support Angle · crackedSUPPORT ANGLE CRACKED BETWEEN BS 927 TO BS 947.5, BL 0. R & R ANGLE IAW SRM & DWG.SDR SWAA2014051427981Frame · crackedFRAME CRACKED AT BS 947.5, STRINGER 19L. R & R FRAME IAW SRM & DWG.SDR SWAA2014042927506Tie Clip · crackedTIE CLIP CRACKED AT BS 500A, STRINGER 22L. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014042927505Tie Clip · crackedTIE CLIP CRACKED AT BS 460, STRINGER 22L. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014042827422Strap · crackedSTRAP CRACKED BETWEEN BS 312 TO BS 344, RBL 31.6. R & R STRAP IAW SRM.SDR SWAA2014042827421Strap · crackedSTRAP CRACKED BETWEEN BS 312 TO BS 344, LBL 45.6. R & R STRAP IAW SRM.SDR SWAA2014042227299Lens · looseFORWARD ENTRY EMERGENCY EXIT SIGN LENS LOOSE. R & R LENS ASSEMBLY IAW AMM.SDR SWAA2014042127231Light · looseRIGHT EMERGENCY EXIT BULLNOSE LIGHT LOOSE AT ROW 15. R & R LIGHT IAW AMM.SDR SWAA2014041727206Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 380, STRINGER 8L. R & R CLIP IAW DWG.SDR SWAA2014061729124Access Panel · crackedLEFT WING ACCESS PANEL 5764L CRACKED. REPAIRED PANEL IAW EA.SDR SWAA2014061729123Access Panel · crackedNUMBER 2 PYLON RT NACELLE STRUT ACCESS PANEL 5864R CRACKED. REPAIRED PANEL IAW EA.SDR SWAA2014060928849Seat Track · crackedCENTER WING BOX SEAT TRACK CRACKED AT BS 727B, BETWEEN LBL 23.8 TO LBL 25.8. REPAIRED SEAT TRACK IAW EA.SDR SWAA2014052728346Access Panel · crackedVERTICAL STABILIZER ACCESS PANEL 9536 CRACKED. REPAIRED PANEL IAW SRM.SDR SWAA2014050627729Crossbeam · crackedCROSSBEAM E T CHORD CRACKED ON FASTENER HOLE IN LOWER CORNER OF AFT END AFT CARGO COMPARTMENT DOOR. REPAIRED CHORD IAW EA.SDR SWAA2014042127251Stringer Splice · crackedSTRINGER SPLICE CRACKED AT BS 540, STRINGER 14L. R &R SPLICE IAW SRM & DWG.SDR SWAA2014061829171Crossbeam · crackedCRACK ON CROSSBEAM E WEB FWD END & AFT EDGE OF THE AFT CARGO DOOR. REPAIRED T CHORD IAW EO & EA.SDR SWAA2014061829163Skin · crackedR1 DOOR SKIN CRACKED AT BS 328, STRINGER 8R. REPAIRED SKIN IAW EO & EA.SDR SWAA2014061228976Frame · crackedFUSELAGE FRAME CRACKED AT BS 500B, STRINGER 21L. REPAIRED FRAME IAW SRM.SDR SWAA2014060228583Skin · crackedL2 DOOR LOWER CORNER FUSELAGE SKIN CRACKED AT BS 947.5+12, STRINGER 17L. REPAIRED SKIN IAW SRM.SDR SWAA2014051427996Structure · crackedANTENNA BASE CRACKED AT PRESS BULKHEAD FWD FACE BS 178. R & R BASE IAW SRM & DWG.SDR SWAA2014062329334Frame · crackedRIGHT FRAME OTBD CHORD CRACKED AT BS 727, STRINGER 18A, AT FWD LOWER FASTENER HOLE. REPAIRED CHORD IAW EA.SDR SWAA2014062329333Frame · crackedLEFT FRAME OTBD CHORD CRACKED AT BS 727, STRINGER 18A, AT FWD LOWER FASTENER HOLE. REPAIRED CHORD IAW EA.
Back to Boeing 737-3H4