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 SWAA104978Skin · crackedDURING SCHEDULED CV CHECK, FOUND SKIN CRACKED AT BS 770, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA104977Skin · crackedDURING SCHEDULED CV CHECK, FOUND SKIN CRACKED AT BS 770, STR 18R. REPAIRED SKIN PER SRM.SDR SWAA104976Skin · crackedDURING SCHEDULED CV CHECK, FOUND SKIN CRACKED AT BS 729D, STR 19R. REPAIRED SKIN PER SRM.SDR SWAA104921Crease Beam · corrodedDURING SCHEDULED 26Y CHECK, FOUND AFT CARGO CREASE BEAM CORRODED. REPAIRED BEAM PER SRM AND BAC DWG.SDR SWAA104920Skin · crackedDURING SCHEDULED 26Y CHECK, FOUND AFT CARGO CUTOUT FWD LOWER CORNER DOOR SKIN CRACKED. REPAIRED SKIN PER SRM.SDR SWAA104871Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 663, STR 10L. REMOVED AND REPLACED CLIP PER EA AND ER.SDR SWAA104870Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727D, STR 6L. REMOVED AND REPLACED CLIP PER EA AND ER.SDR SWAA104869Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 6L. REMOVED AND REPLACED CLIP PER EA AND ER.SDR SWAA104868Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 5L. REMOVED AND REPLACED CLIP PER EA AND ER.SDR SWAA104867Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 4L. REMOVED AND REPLACED CLIP PER EA AND ER.SDR SWAA104866Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 7L. REMOVED AND REPLACED CLIP PER EA AND ER.SDR SWAA104865Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 3L. REMOVED AND REPLACED CLIP PER EA AND ER.SDR SWAA104864Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 7L. REMOVED AND REPLACED CLIP PER EA AND ER.SDR SWAA104863Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 6L. REMOVED AND REPLACED CLIP PER EA AND ER.SDR SWAA104862Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 3L. REMOVED AND REPLACED CLIP PER EA AND ER.SDR SWAA104861Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 2L. REMOVED AND REPLACED CLIP PER EA AND ER.SDR SWAA104860Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 1L. REMOVED AND REPLACED CLIP PER EA AND ER.SDR SWAA104859Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 15L. REMOVED AND REPLACED CLIP PER EA AND ER.SDR SWAA104858Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 807, STR 5R. REMOVED AND REPLACED CLIP PER EA AND ER.SDR SWAA104857Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 787, STR 9R. REMOVED AND REPLACED CLIP PER EA AND ER.SDR SWAA104856Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 747, STR 6R. REMOVED AND REPLACED CLIP PER EA AND ER.SDR SWAA104855Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727E, STR 8R. REMOVED AND REPLACED STRINGER CLIP PER EA.SDR SWAA104854Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727E, STR 7R. REMOVED AND REPLACED STRINGER CLIP PER EA.SDR SWAA104853Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727E, STR 5R. REMOVED AND REPLACED STRINGER CLIP PER EA.SDR SWAA104852Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727E, STR 3R. REMOVED AND REPLACED STRINGER CLIP PER EA.SDR SWAA104851Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 8R. REMOVED AND REPLACED STRINGER CLIP PER EA.SDR SWAA104850Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 8R. REMOVED AND REPLACED STRINGER CLIP PER EA.SDR SWAA104849Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 7R. REMOVED AND REPLACED STRINGER CLIP PER EA.SDR SWAA104848Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 8R. REMOVED AND REPLACED STRINGER CLIP PER EA.SDR SWAA104847Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 7R. REMOVED AND REPLACED STRINGER CLIP PER EA.SDR SWAA104846Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 6R. REMOVED AND REPLACED STRINGER CLIP PER EA.SDR SWAA104845Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 5R. REMOVED AND REPLACED STRINGER CLIP PER EA.SDR SWAA104844Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 4R. REMOVED AND REPLACED STRINGER CLIP PER EA.SDR SWAA104843Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 2R. REMOVED AND REPLACED STRINGER CLIP PER EA.SDR SWAA104842Shear Tie · crackedDURING SCHEDULED 26Y CHECK, FOUND SHEAR TIE CRACKED AT BS 767, BETWEEN STR 19L TO STR 20L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA104814Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 706, STR 3R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA104813Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 706, STR 2R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA104812Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 685, STR 10R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA104811Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 663, STR 4R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA104810Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 616, STR 5R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA104809Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 597, STR 8R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA104808Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 597, STR 7R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA104807Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 578, STR 8R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA104806Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500C, STR 10R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA104805Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 597, STR 4L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA104804Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 597, STR 7L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA104803Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 597, STR 9L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA104802Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 578, STR 7L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA104801Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500D, STR 7L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA104800Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500A, STR 10L. REMOVED AND REPLACED CLIP PER SRM.
Back to Boeing 737-3Q8