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 SWAA2014012024216Floor Support · crackedLONGITUDINAL FLOOR BEAM WEB CRACKED AT BS 709 LBL 24.8. REPAIRED WEB IAW EA.SDR SWAA2014012024215Floor Support · crackedLONGITUDINAL FLOOR BEAM WEB CRACKED AT BS 708 LBL 24.8. REPAIRED WEB IAW EA.SDR SWAA2014012024214Mechanism · looseLT WING INBD EXHAUST GATE AFT DRIVE CRANK BEARING LOOSE. R & R MECHANISM IAW CMM.SDR SWAA2014011724195Skin · crackedLT WING NR 1 SLAT SKIN CRACKED BETWEEN STATION 333 TO STATION 348. REPAIRED SKIN IAW SRM.SDR SWAA2014011624152Angle · crackedANGLE CRACKED AT BS 727 BETWEEN STRINGER 22L TO STRINGER 25L. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014011624151Floorbeam · corrodedFLOOR BEAM CORRODED AT BS 328 BETWEEN LBL 3 TO RBL 16. REPAIRED BEAM IAW SRM.SDR SWAA2014011624133Skin · crackedLT WING NR 1 SLAT SKIN CRACKED. REPAIRED SKIN IAW SRM.SDR SWAA2014011424109Lens · brokenAFT LAVATORY EMERGENCY EXIT SIGN LENS BROKEN. R & R LENS IAW AMM.SDR SWAA2014011324018Light · crackedNR 1 GALLEY EMERGENCY EXIT LIGHT CRACKED. R & R LIGHT IAW MM.SDR SWAA2014011324017Lens · crackedFWD LAVATORY EMERGENCY EXIT LENS CRACKED. R & R LENS IAW MM.SDR SWAA2014011323999Angle · crackedLT WING ANGLE CRACKED AT WBL 183.40. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014011323998Angle · crackedRT WING AFT PYLON ANGLE CRACKED AT WBL 183.40. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014010923934Forging · crackedRT BS 380+10 WINDOW FORGING UPPER FWD CORNER CRACKED AT HOLE NR 7. R & R FORGING IAW BAC DRAWING.SDR SWAA2014010923925Slat · delaminatedRT WING NR 5 SLAT INBD EDGE DELAMINATED. REPAIRED NR 5 SLAT IAW SRM.SDR SWAA2014010923905Support Angle · crackedRT WING 36 FAIRING FLAP TRACK SUPPORT ANGLE CRACKED. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014010723845Support Angle · crackedLT WING AILERON WIPER WEB SUPPORT ANGLE CRACKED AT RSS 546. R & R ANGLE IAW SRM.SDR SWAA2014010723793Engine · bird ingestionDECLARED EMERGENCY INFLIGHT SHUTDOWN BIRD STRIKE ON NR 2 MOTOR & RT WING SHUT DOWN MOTOR INFLIGHT. R & R NR 2 ENGINE IAW MT.SDR SWAA2014010723808Lens · damagedNR 4 GALLEY EMERGENCY EXIT LENS DAMAGED. R & R LENS IAW AMM.SDR SWAA2014010223720Pressure Deck · crackedMAIN WW PRESSURE DECK CRACKED AT BS 665 RBL 39. REPAIRED DECK IAW SRM.SDR SWAA2014010223719Skin · delaminatedRT WING INBD FORE FLAP UPPER SURFACE DELAMINATED. REPAIRED FORE FLAP IAW SRM.SDR SWAA2013122623636Skin · crackedLT HORIZONTAL STAB LOWER SURFACE SKIN CRACKED AT REAR SPAR. REPAIRED SKIN IAW SRM.SDR SWAA2014012724564Bulkhead · crackedBULKHEAD WEB CRACKED AT BS 1016 STRINGER 18R. REPAIRED WEB IAW EA.SDR SWAA2014012324447Web · crackedLT NLG WW WEB CRACKED AT BS 243.7+2.5 WL 169.1. REPAIRED WEB IAW SRM.SDR SWAA2014012324446Web · crackedLT NLG WW WEB CRACKED AT BS 235.8+4 WL 169.1. REPAIRED WEB IAW SRM.SDR SWAA2014012324445Web · crackedLT NLG WW WEB CRACKED AT BS 235.8+3 WL 169.1. REPAIRED WEB IAW SRM.SDR SWAA2014012324444Doubler · crackedLT NLG WW ALONG THE DOUBLER CRACKED AT BS 258.6 WL 169.1+ 5. REPAIRED DOUBLER IAW SRM.SDR SWAA2014012324443Doubler · crackedRT NLG WW ALONG THE DOUBLER EDGE CRACKED AT BS 258.6 WL 169.1+ 6. REPAIRED DOUBLER IAW EA.SDR SWAA2014012324449Web · crackedLT NLG WW WEB CRACKED AT BS 243.7+4.5 WL 169.1. REPAIRED WEB IAW SRM.SDR SWAA2014012324448Web · crackedLT NLG WW WEB CRACKED AT BS 243.7+3.5 WL 169.1. REPAIRED WEB IAW SRM.SDR SWAA2014012024255Access Panel · crackedLT NACELLE STRUT ACCESS PANEL 5764 CRACKED. REPAIRED PANEL IAW EO & EA.SDR SWAA2014012024254Skin · crackedFUSELAGE SKIN CRACKED AT BS 420+3.750 STRINGER 1. REPAIRED SKIN IAW EO & EA.SDR SWAA2014012024253Skin · crackedFUSELAGE SKIN CRACKED AT BS 420+14 STRINGER 1. REPAIRED SKIN IAW EO & EA.SDR SWAA2014012024252Pressure Panel · crackedMAIN WW PRESS DECK CRACKED AT BS 663.75+1.5 RBL 24.5+13. REPAIRED WEB IAW EA.SDR SWAA2014011724194Skin · crackedLT WING NR 3 SLAT LE SKIN CRACKED. R & R NR 3 SLAT IAW AMM.SDR SWAA2014010823865Handle · crackedL1 EMERGENCY EXIT DOOR UPPER COVER HANDLE CRACKED. R & R HANDLE IAW AMM.SDR SWAA2014010223708Angle · crackedHORIZONTAL STABILIZER ACCESS PANEL 9226R ANGLE CRACKED. R & R ANGLE IAW SRM.SDR SWAA2014010223742Access Panel · crackedLT HORIZONTAL STABILIZER NR 9126 ACCESS PANEL CRACKED. R & R PANEL IAW SRM.SDR SWAA2013122723659Stringer Clip · damagedSTRINGER CLIP DAMAGED AT STATION 639, STRINGER 4R. R & R STRINGER CLIP IAW SRM & BAC DRAWING.SDR SWAA2014012724563Skin · crackedFUSELAGE SKIN CRACKED AT BS 360 STRINGER 3R. REPAIRED SKIN IAW EO & EA.SDR SWAA2014012024316Skin · crackedRT BS 520+10 UPPER FWD WINDOW SKIN CUTOUT CRACKED BETWEEN HOLE 3 TO 7. REPAIRED SKIN IAW EA.SDR SWAA2014012024315Skin · crackedRT BS 500C+10 UPPER FWD WINDOW SKIN CUTOUT CRACKED BETWEEN HOLES 4 TO 7. REPAIRED SKIN IAW EA.SDR SWAA2014012024314Skin · crackedRT BS 420+10 UPPER FWD WINDOW SKIN CUTOUT CRACKED BETWEEN HOLE 2 & 6. REPAIRED SKIN IAW EA.SDR SWAA2014012024284Skin · crackedRT BS 500A+10 UPPER FWD WINDOW SKIN CUTOUT CRACKED BETWEEN HOLE 2 TO HOLE 7. REPAIRED SKIN IAW EA.SDR SWAA2014012024251Structure · crackedCHORD CRACKED AT BS 727 BETWEEN STRINGER 18R TO STRINGER 27R. REPAIRED CHORD IAW EO & EA.SDR SWAA2014012024250Structure · crackedCHORD CRACKED AT BS 727 BETWEEN STRINGER 18L TO STRINGER 27L. REPAIRED CHORD IAW EO & EA.SDR SWAA2014012024249Strap · crackedSTRAP CRACKED AT BS 908 STRINGER 3R. R & R STRAP IAW EA & DRAWING.SDR SWAA2014012024248Skin · crackedFUSELAGE SKIN CRACKED AT BS 420+4 STRINGER 1. REPAIRED SKIN IAW EO & EA.SDR SWAA2014012024220Skin · crackedLT BS 380+10 LOWER AFT WINDOW SKIN CUTOUT CRACKED AT HOLE 6. REPAIRED SKIN IAW EA.SDR SWAA2014012024219Skin · crackedRT BS 400+10 LOWER AFT WINDOW SKIN CUTOUT CRACKED BETWEEN HOLE 3 TO 6. REPAIRED SKIN IAW EA.SDR SWAA2014012024218Skin · crackedRT BS 480+10 UPPER FWD WINDOW SKIN CUTOUT CRACKED BETWEEN HOLE 4 TO 11. REPAIRED SKIN IAW EA.
Back to Boeing 737-3H4