Boeing 737-3Q8
Service difficulty reports · 4,188
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 = '7373Q8' 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 = '7373Q8' 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 SWAA111882Floor Support · corrodedDURING SCHEDULED 26Y CHECK, FOUND CORROSION AFT PIT FLOOR SUPPORT STA 767 +5, RBL 3. REPAIRED PER SRM AND EA.SDR SWAA111881Frame · corrodedDURING SCHEDULED 26Y CHECK, FOUND CORROSION AFT PIT SHEAR TIE BILGE AREA STA 807, LBL 3. REPAIRED PER SRM.SDR SWAA111554Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND FRAME CORRODED AT BS 767, BETWEEN STR 25L TO STR 26L. REPAIRED FRAME PER SRM.SDR SWAA111340Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 380, STR 21L. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA111339Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 400, STR 21R. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA111338Crease Beam · crackedDURING SCHEDULED 24Y CHECK, FOUND CREASE BEAM WEB CRACKED BETWEEN BS 907 TO BS 927, STR 17L. REMOVED AND REPLACED WEB PER SRM AND BAC DWG.SDR SWAA111337Shear Tie · crackedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CRACKED AT BS 500D, STR 13R. REMOVED AND REPLACED SHEAR TIE PER SRM AND BAC DWG.SDR SWAA111315Bulkhead · crackedDURING SCHEDULED 24Y CHECK, FOUND AFT PRESSURE BULKHEAD WEB DOME CRACKED AT BS 1016, STR 15R. REPAIRED DOME PER SRM.SDR SWAA111276Stringer Clip · corrodedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CORRODED AT BS 380, STR 21R. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA111275Stringer Clip · corrodedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CORRODED AT BS 727A, STR 26L. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA111274Stringer Splice · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER SPLICE CRACKED AT BS 500C, STR 9R. REMOVED AND REPLACED SPLICE PER SRM AND BAC DWG.SDR SWAA111273Stringer Clip · corrodedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CORRODED AT BS 500C, STR 9R. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA111272Stringer Clip · corrodedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CORRODED AT BS 500, STR 23L. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA111271Stringer Clip · corrodedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CORRODED AT BS 500D, STR 25L. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA111270Stringer Clip · corrodedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CORRODED AT BS 767, STR 24L. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA111179Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE SHEAR TIE CORRODED AT BS 500, STR 27R TO STR 28R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA111231Slide · out of adjustL1 DOOR SLIDE OUT OF ADJUST. REMOVED AND REPLACED SLIDE PER MT.SDR SWAA2012111909627Skin · crackedR1 DOOR UPPER FWD CORNER AT FASTENER HOLE L=0.250" APPROX RIGHT, UPPER FWD CORNER OF R1 DOOR RIGHT BETWEEN BS 294.5 AND BS 312, BETWEEN STR 6R AND STR 8R ON FUSELAGE SKIN AND BEAR STRAP CRACKED. REPAIRED PER EO AND EA.SDR SWAA110870Flashlight · inoperativeAFT O/B EMERGENCY FLASHLIGHT INOP. REMOVED AND REPLACED FLASHLIGHT PER MM.SDR SWAA110653Connector · disconnectedDURING SCHEDULED 26Y CHECK, FOUND AFT OVERHEAD CENTER EMERGENCY EXIT LIGHT ASSY INOP. CONNECTED CONNECTOR PER WDM.SDR SWAA110652Skin · crackedDURING SCHEDULED 26Y CHECK, FOUND FUSELAGE SKIN CRACKED AT R2 DOOR FWD LOWER CONER CUTOUT. REPAIRED SKIN PER EA.SDR SWAA110651Stringer Splice · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER SPLICE CRACKED AT BS 360, STR 3L. REMOVED AND REPLACED SPLICE PER SRM.SDR SWAA110650Skin · crackedDURING SCHEDULED 26Y CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR FWD LOWER CORNER CUTOUT. REPAIRED SKIN PER SWA EA.SDR SWAA110649Shear Tie · corrodedDURING SCHEDULED 26Y CHECK, FOUND SHEAR TIE CORRODED AT BS 767, LBL 3. REPAIRED SHEAR TIE PER SRM.SDR SWAA110648Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 559, STR 11R. REMOVED AND REPLACED CLIP PER SRM AND EA.SDR SWAA110647Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 597, STR 11R. REMOVED AND REPLACED CLIP PER SRM AND EA.SDR SWAA110646Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 578, STR 11R. REMOVED AND REPLACED CLIP PER SRM AND EA.SDR SWAA110645Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727E, STR 7R. REMOVED AND REPLACED CLIP PER SRM AND EA.SDR SWAA110644Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727D, STR 7R. REMOVED AND REPLACED CLIP PER SRM AND EA.SDR SWAA110643Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727D, STR 6R. REMOVED AND REPLACED CLIP PER SRM AND EA.SDR SWAA110642Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 6R. REMOVED AND REPLACED CLIP PER SRM AND EA.SDR SWAA110641Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 8R. REMOVED AND REPLACED CLIP PER SRM AND EA.SDR SWAA110640Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 2R. REMOVED AND REPLACED CLIP PER SRM AND EA.SDR SWAA110639Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 706, STR 7R. REMOVED AND REPLACED CLIP PER SRM AND EA.SDR SWAA110638Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 706, STR 10R. REMOVED AND REPLACED CLIP PER SRM AND EA.SDR SWAA110637Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 706, STR 4R. REMOVED AND REPLACED CLIP PER SRM AND EA.SDR SWAA110636Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 597, STR 10R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA110635Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 597, STR 9R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA110634Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 597, STR 8R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA110633Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 597, STR 7R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA110632Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 597, STR 6R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA110631Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 420, STR 10R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA110630Shear Tie · corrodedDURING SCHEDULED 26Y CHECK, FOUND SHEAR TIE CORRODED AT BS 480, BETWEEN STR 26L TO STR 27L. REPAIRED SHEAR TIE PER SRM.SDR SWAA110629Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 887, STR 10L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA110628Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 747, STR 10L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA110627Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727E, STR 5L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA110626Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727D, STR 6L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA110625Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 6L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA110624Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 3L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA110623Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 706, STR 7L. REMOVED AND REPLACED CLIP PER SRM.
Back to Boeing 737-3Q8