Boeing 737-3Y0
Service difficulty reports · 3,007
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 = '7373Y0' 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 = '7373Y0' 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 SWAA092164Tab · delaminatedDURING SCHEDULED 22Y CHECK, FOUND RT WING AILERON TAB O/B END DELAMINATED. REPAIRED AILERON PER SRM.SDR SWAA092163Floorbeam · corrodedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM CORRODED AT BS 987, BETWEEN RBL 42 TO RBL 46. REPAIRED BEAM PER ER.SDR SWAA092162Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND SKIN CRACKED BETWEEN BS 277 TO BS 291, STR 10R. REPAIRED SKIN PER SRM.SDR SWAA092161Shear Tie · corrodedDURING SCHEDULED 22Y CHECK, FOUND SHEAR TIE CORRODED AT BS 767, BETWEEN STR 26R TO STR 27R. REPAIRED SHEAR TIE PER SRM.SDR SWAA092160Shear Tie · corrodedDURING SCHEDULED 22Y CHECK, FOUND SHEAR TIE CORRODED AT BS 987, BETWEEN STR 19R TO STR 20R. REPAIRED SHEAR TIE PER SRM.SDR SWAA092159Shear Tie · corrodedDURING SCHEDULED 22Y CHECK, FOUND SHEAR TIE CORRODED AT BS 887, BETWEEN STR 27R TO STR 27L. REPAIRED SHEAR TIE PER SRM.SDR SWAA092158Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 670, RBL 24. REPAIRED BEAM PER ER.SDR SWAA092157Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 727B, LBL 45. REPAIRED BEAM PER ER.SDR SWAA092156Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 520, STR 13R. REPAIRED FRAME PER PAE EA.SDR SWAA092155Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 500C, STR 13R. REPAIRED FRAME PER PAE EA.SDR SWAA092154Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR LOWER HINGE CUTOUT, BS 290, WL 235. REPAIRED SKIN PER ER.SDR SWAA092153Shear Tie · corrodedDURING SCHEDULED 22Y CHECK, FOUND SHEAR TIE CORRODED AT BS 767 BETWEEN STR 27R TO STR 27L. REPAIRED SHEAR TIE PER SRM.SDR SWAA092152Stringer · corrodedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CORRODED BETWEEN BS 819 TO BS 827, STR 26L. REPAIRED STRINGER PER SRM.SDR SWAA092151Shear Tie · corrodedDURING SCHEDULED 22Y CHECK, FOUND SHEAR TIE CORRODED AT BS 787, BETWEEN STR 26L TO STR 27L. REPAIRED SHEAR TIE PER SRM.SDR SWAA092150Shear Tie · corrodedDURING SCHEDULED 22Y CHECK, FOUND SHEAR TIE CORRODED AT BS 787, BETWEEN STR 26R TO STR 27R. REPAIRED SHEAR TIE PER SRM.SDR SWAA092149Bulkhead · crackedDURING SCHEDULED 22Y CHECK, FOUND PRESSURE DOME WEB CRACKED AT BS 1016, STR 6L. REPAIRED WEB PER SRM.SDR SWAA092131Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 867, STR 8L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA091969Wedge · delaminatedDURING SCHEDULED 22Y CHECK, FOUND LT WING TRAILING EDGE O/B FORE FLAP TRAILING EDGE WEDGE DELAMINATED. REPAIRED FORE FLAP PER SRM.SDR SWAA091845Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 787, STR 13L. REPAIRED FRAME PER EA.SDR SWAA091846Slide · out of positionL1 DOOR EMERGENCY EVACUATION SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MT.SDR SWAA091702Stringer · corrodedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CORRODED BETWEEN BS 819 TO BS 827, STR 26L. REPAIRED STRINGER PER SRM.SDR SWAA091701Shear Tie · corrodedDURING SCHEDULED 22Y CHECK, FOUND SHEAR TIE CORRODED AT BS 787, BETWEEN STR 26L TO STR 27L. REPAIRED SHEAR TIE PER SRM.SDR SWAA091700Shear Tie · corrodedDURING SCHEDULED 22Y CHECK, FOUND SHEAR TIE CORRODED AT BS 787, BETWEEN STR 26R TO STR 27R. REPAIRED SHEAR TIE PER SRM.SDR SWAA091672Stringer · corrodedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CORRODED AT BS 360, STR 28R. REPAIRED STRINGER PER SRM.SDR SWAA091659Wedge · delaminatedDURING SCHEDULED 22Y CHECK, FOUND RT WING I/B MIDFLAP T/E WEDGE DELAMINATED. REMOVED AND REPLACED WEDGE PER MM.SDR SWAA091658Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 277, STR 11R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA091657Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 277, STR 10R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA091656Stringer · corrodedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CORRODED BETWEEN BS 360 TO BS 363, STR 28R. REPAIRED STRINGER PER SRM.SDR SWAA091655Shear Tie · corrodedDURING SCHEDULED 22Y CHECK, FOUND SHEAR TIE CORRODED AT BS 360, BETWEEN STR 28L TO STR 28R. REPAIRED SHEAR TIE PER SRM.SDR SWAA091654Shear Tie · corrodedDURING SCHEDULED 22Y CHECK, FOUND SHEAR TIE CORRODED AT BS 847, BETWEEN STR 25L TO STR 26L. REPAIRED SHEAR TIE PER SRM.SDR SWAA091653Shear Tie · corrodedDURING SCHEDULED 22Y CHECK, FOUND SHEAR TIE CORRODED AT BS 767, BETWEEN STR 25L TO STR 26L. REPAIRED SHEAR TIE PER SRM.SDR SWAA091652Shear Tie · corrodedDURING SCHEDULED 22Y CHECK, FOUND SHEAR TIE CORRODED AT BS 887, BETWEEN STR 25L TO STR 26L. REPAIRED SHEAR TIE PER SRM.SDR SWAA091620Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 500D, STR 13R. REPAIRED FRAME PER EA.SDR SWAA091619Stringer · corrodedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CORRODED BETWEEN BS 727C TO BS 747, STR 23L. REPAIRED STRINGER PER SRM.SDR SWAA091618Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND SKIN CRACKED BETWEEN BS 727B TO BS 727C, STR 24L. REPAIRED SKIN PER EA.SDR SWAA091617Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 767, STR 13L. REPAIRED FRAME PER EA.SDR SWAA091616Pressure Panel · crackedDURING SCHEDULED 22Y CHECK, FOUND RT NOSE WHEEL WELL CEILING ACCESS DOOR CUTOUT CRACKED. REPAIRED SKIN PER ACO.SDR SWAA091615Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND LT WING NR 1 SLAT SKIN CRACKED AT O/B END. REPAIRED SLAT PER SRM.SDR SWAA091606Shear Tie · corrodedDURING SCHEDULED 22Y CHECK, FOUND SHEAR TIE CORRODED AT BS 767, BETWEEN STR 26L TO STR 27L. REPAIRED SHEAR TIE PER SRM.SDR SWAA091605Cap · crackedDURING SCHEDULED 22Y CHECK, FOUND AFT BULKHEAD DOME CAP CRACKED AT BS 1016, STR 23R. REPAIRED DOME CAP PER SRM.SDR SWAA091604Cap · crackedDURING SCHEDULED 22Y CHECK, FOUND AFT BULKHEAD DOME CAP CRACKED AT BS 1016, STR 15R. REPAIRED DOME CAP PER SRM.SDR SWAA091496Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 727B, RBL 24. REPAIRED BEAM PER SRM.SDR SWAA091495Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 727B, LBL 24. REPAIRED BEAM PER SRM.SDR SWAA091327Lens · fadedDURING SCHEDULED MV2 CHECK, FOUND L2 DOOR EXIT LIGHT LENS FADED. REMOVED AND REPLACED LENS PER MM.SDR SWAA091322Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 807, STR 8R TO STR 9R. REPAIRED FRAME PER SRM.SDR SWAA091323Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 887, STR 8R TO STR 9R. REPAIRED FRAME PER SRM.SDR SWAA091304Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 8R TO STR 9R. REPAIRED FRAME PER EA.SDR SWAA091287Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8L TO STR 9L. REPAIRED FRAME PER EA.SDR SWAA091286Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8L TO STR 9L. REPAIRED FRAME PER EA.SDR SWAA091285Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8R TO STR 9R. REPAIRED FRAME PER EA.
Back to Boeing 737-3Y0