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 SWAA2014082531168Tie Clip · crackedTIE CLIP CRACKED AT BS 360, STRINGER 9L. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014082531150Tie Clip · crackedTIE CLIP CRACKED AT BS 380 STRINGER 21L. R &R TIE CLIP IAW SRM & DWG.SDR SWAA2014082531149Tie Clip · crackedTIE CLIP CRACKED AT BS 380 STRINGER 22L. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014082531167Tie Clip · crackedTIE CLIP CRACKED AT BS 360 STRINGER 8L. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014082531166Tie Clip · crackedTIE CLIP CRACKED AT BS 360, STRINGER 5L. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014082131062Metering Valve · faultyUPON LANDING FIRST OFFICERS BRAKE PEDALS PUSHED ALL THE WAY TO THE FLOOR. ON TAXI IN RECHECKED FIRST OFFICER'S BRAKES LT SIDE HELD, RT SIDE TO THE FLOOR WITH A SHUDDER KICK BACK. R & R RT BRAKES ALTERNATE METERING VLV IAW MM.SDR SWAA2014081930978Skin · crackedRIGHT WING LOWER SKIN CRACKED EMANATING FROM UNDER THE PYLON MID SPAR LUG OTBD OF PYLON. REPAIRED SKIN CRACK IAW EA.SDR SWAA2014081930977Door · crackedLEFT MAIN GEAR STRUT DOOR CRACKED AT AFT EDGE. R & R DOOR IAW MM.SDR SWAA2014081930969Lens · looseL1 DOOR EMER EXIT SIGN COVER LENS LOOSE. R & R LENS IAW AMM.SDR SWAA2014111934313Skin · crackedFUSELAGE CROWN SKIN CRACKED AT BS 727C+7, STRINGER 2L. REPAIRED SKIN IAW EA.SDR SWAA2014111934298Skin · crackedFUSELAGE CROWN SKIN CRACKED AT BS 807, STRINGER 1L. REPAIR SKIN IAW EA.SDR SWAA2014111934297Skin · crackedFUSELAGE CROWN SKIN CRACKED AT BS 801, STRINGER 1L. REPAIR SKIN IAW EA.SDR SWAA2014110333651Skin · crackedFUSELAGE CROWN SKIN CRACKED AT BS 847 STRINGER 1L. REPAIRED SKIN IAW ER.SDR SWAA2014102933425Skin · crackedFUSELAGE CROWN SKIN CRACKED AT BS 727A + 12 STRINGER 2L. REPAIRED SKIN IAW ER.SDR SWAA2014090931740Rib · crackedLEFT WING UPPER CHORD INSPAR RIB WEB CRACKED AT WBL 198.60 STRINGER 5 AT REAR SPAR LT FUEL TANK. REPAIRED CHORD IAW EA.SDR SWAA2014090931727Stiffener · corrodedAFT PRESS BULKHEAD Z STIFFENER CORRODED AT BS 1016, BL 0. REPAIRED Z STIFFENER IAW EA.SDR SWAA2014090931726Bulkhead · corrodedAFT PRESS BULKHEAD WEB CORRODED AT BS 1016 RBL 5. REPAIRED WEB IAW EA NO.SDR SWAA2014090431588Angle · crackedCLIP ANGLE CRACKED AT BS 348.2 STRINGER 15L. R & R ANGLE IAW SRM & DWG.SDR SWAA2014090431587Frame · crackedFRAME INNER CHORD CRACKED AT BS 348.2 STRINGER 17L. R & R CHORD IAW EA.SDR SWAA2014090331557Tie Clip · crackedTIE CLIP CRACKED AT BS 380 STRINGER 28L. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014090231551Shear Tie · corrodedSHEAR TIE CORRODED AT BS 344 STRINGER 26R. R & R SHEAR TIE IAW SRM & DWG.SDR SWAA2014090231545Stringer Splice · corrodedSTRINGER SPLICE CORRODED AT BS 360 STRINGER 28L. R & R SPLICE IAW SRM & DWG.SDR SWAA2014082931441Skin · crackedL2 DOOR FWD LOWER STUB FRAME LOWER FASTENER HOLE CUT OUT CRACKED. REPAIRED CUT OUT IAW EA.SDR SWAA2014082931430Tie Clip · crackedTIE CLIP CRACKED AT BS 727B STRINGER 24R. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014082931429Tie Clip · crackedTIE CLIP CRACKED AT BS 727B STRINGER 24L. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014082931420Skin · crackedSKIN CRACKED AT BS 807 STRINGER 2L. REPAIRED SKIN IAW SRM.SDR SWAA2014082931419Skin · crackedSKIN CRACKED AT BS 807 STRINGER 2R. REPAIRED SKIN IAW SRM.SDR SWAA2014082931418Skin · crackedSKIN CRACKED AT BS 827 STRINGER 2R. REPAIRED SKIN IAW SRM.SDR SWAA2014082931417Skin · crackedSKIN CRACKED AT BS 801 STRINGER 2R. REPAIRED SKIN IAW SRM.SDR SWAA2014082931416Skin · crackedSKIN CRACKED AT BS 787 STRINGER 2R. REPAIRED SKIN IAW SRM.SDR SWAA2014082831390Angle · crackedAFT CARGO COMPARTMENT ANGLE CRACKED AT BS 727A BETWEEN STRINGER 25L TO 26L. R & R ANGLE IAW SRM & DWG.SDR SWAA2014082831386Stringer Splice · crackedSTRINGER SPLICE CHANNEL CRACKED AT BS 360 STRINGER 7L. R & R CHANNEL IAW SRM & DWG.SDR SWAA2014082731299Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 294.5 STRINGER 23L. R & R SUPPORT IAW SRM & DWG.SDR SWAA2014082731298Angle · crackedANGLE CRACKED AT BS 328+9 STRINGER 21L. R & R ANGLE IAW SRM & DWG.SDR SWAA2014082731297Angle · crackedANGLE CRACKED AT BS 328 STRINGER 21L. R & R ANGLE IAW SRM & DWG.SDR SWAA2014082731296Angle · crackedANGLE CRACKED AT BS 312+9 STRINGER 21L. R & R ANGLE IAW SRM & DWG.SDR SWAA2014082731295Angle · crackedANGLE CRACKED AT BS 312 STRINGER 21L. R & R ANGLE IAW SRM & DWG.SDR SWAA2014082731291Bear Strap · crackedBEAR STRAP CRACKED AT BS 956 LOWER FWD CORNER OF AFT SERVICE DOOR CUT OUT. REPAIRED BEAR STRAP IAW SRM.SDR SWAA2014082731288Skin · crackedFUSELAGE SKIN CRACKED AT BS 440 STRINGER 16R. REPAIRED SKIN IAW EA.SDR SWAA2014082631223Tie Clip · crackedTIE CLIP CRACKED AT BS 727B STRINGER 20L. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014082631222Tie Clip · crackedTIE CLIP CRACKED AT BS 727A STRINGER 19L. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014082631219Stringer Splice · corrodedSTRINGER SPLICE CORRODED AT BS 360 STRINGER 27L. R & R SPLICE IAW SRM & DWG.SDR SWAA2014082531201Wire · brokenFORWARD LAVATORY L1 DOOR EMER LIGHT ASSEMBLY WIRE BROKEN. REPAIRED LIGHT ASSEMBLY IAW MM.SDR SWAA2014082531142Skin · crackedFUSELAGE CROWN SKIN CRACKED AT BS 727B+13, STRINGER 2L. REPAIRED SKIN IAW SRM.SDR SWAA2014082131066Angle · crackedANGLE CRACKED ON PLATE NR 2 TRANSMISSION. R & R ANGLE IAW SRM & DWG.SDR SWAA2014082131065Angle · crackedANGLE CRACKED ON PLATE NR 1 TRANSMISSION. R & R ANGLE IAW SRM & DWG.SDR SWAA2014081931004Tie Clip · crackedTIE CLIP CRACKED AT BS 380 STRINGER 21L. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014081530908Power Supply · inoperativeFORWARD TWO LT BULLNOSE EMER LIGHTS INOPERATIVE. R & R POWER SUPPLY IAW AMM.SDR SWAA2014081530892Skin · crackedSKIN CRACKED AT BS 847 STRINGER 1L. REPAIRED SKIN IAW EA.SDR SWAA2014081530891Skin · crackedSKIN CRACKED AT BS 847 STRINGER 1L. REPAIRED SKIN IAW EA.
Back to Boeing 737-3H4