N302SW, cancelled Sep 29, 2014
Service difficulty reports · 369
Matched to this aircraft by N-number and event date, checked against the reported serial number, make and model. Newest first.
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 n_number = 'N302SW' AND deregistration_id = 'N302SW-2014-09-29' 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 n_number = 'N302SW' AND deregistration_id = 'N302SW-2014-09-29' 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 SWAA073630Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 787, STR 4L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA073631Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 867, STR 4L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA073632Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 706, STR 4L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA073627Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA073626Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA073625Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA073591Stringer Clip · crackedDURING SCHEDULED RON, FOUND FUSELAGE STR CLIP CRACKED AT BS 727C, STR 4L. REMOVED AND REPLACED STR CLIP PER SRM.SDR SWAA073597Stringer Clip · crackedDURING SCHEDULED RON, FOUND FUSELAGE STR CLIP CRACKED AT BS 727E, STR 9R. REMOVED AND REPLACED STR CLIP PER SRM.SDR SWAA073596Stringer Clip · crackedDURING SCHEDULED RON, FOUND FUSELAGE STR CLIP CRACKED AT BS 520, STR 7R. REMOVED AND REPLACED STR CLIP PER SRM.SDR SWAA073595Stringer Clip · crackedDURING SCHEDULED RON, FOUND FUSELAGE STR CLIP CRACKED AT BS 500D, STR 8R. REMOVED AND REPLACED STR CLIP PER SRM.SDR SWAA073594Stringer Clip · crackedDURING SCHEDULED RON, FOUND FUSELAGE STR CLIP CRACKED AT BS 500C, STR 7R. REMOVED AND REPLACED STR CLIP PER SRM.SDR SWAA073592Stringer Clip · crackedDURING SCHEDULED RON, FOUND FUSELAGE STR CLIP CRACKED AT BS 727C, STR 5L. REMOVED AND REPLACED STR CLIP PER SRM.SDR SWAA073590Stringer Clip · crackedDURING SCHEDULED RON, FOUND FUSELAGE STR CLIP CRACKED AT BS 727B, STR 6L. REMOVED AND REPLACED STR CLIP PER SRM.SDR SWAA073589Stringer Clip · crackedDURING SCHEDULED RON, FOUND FUSELAGE STR CLIP CRACKED AT BS 727A, STR 7L. REMOVED AND REPLACED STR CLIP PER SRM.SDR SWAA073588Stringer Clip · crackedDURING SCHEDULED RON, FOUND FUSELAGE STR CLIP CRACKED AT BS 727A, STR 6L. REMOVED AND REPLACED STR CLIP PER SRM.SDR SWAA073586Stringer Clip · crackedDURING SCHEDULED RON, FOUND FUSELAGE STR CLIP CRACKED AT BS 727A, STR 3L. REMOVED AND REPLACED STR CLIP PER SRM.SDR SWAA073585Stringer Clip · crackedDURING SCHEDULED RON, FOUND FUSELAGE STR CLIP CRACKED AT BS 500, STR 7L. REMOVED AND REPLACED STR CLIP PER SRM.SDR SWAA073584Stringer Clip · crackedDURING SCHEDULED RON, FOUND FUSELAGE STR CLIP CRACKED AT BS 727A, STR 10L. REMOVED AND REPLACED STR CLIP PER SRM.SDR SWAA073583Stringer Clip · crackedDURING SCHEDULED RON, FOUND FUSELAGE STR CLIP CRACKED AT BS 727A, STR 9L. REMOVED AND REPLACED STR CLIP PER SRM.SDR SWAA073587Stringer Clip · crackedDURING SCHEDULED RON, FOUND FUSELAGE STR CLIP CRACKED AT BS 727A, STR 5L. REMOVED AND REPLACED STR CLIP PER SRM.SDR SWAA073593Stringer Clip · crackedDURING SCHEDULED RON, FOUND FUSELAGE STR CLIP CRACKED AT BS 907, STR 4L. REMOVED AND REPLACED STR CLIP PER SRM.SDR SWAA073537Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 597, STR 7R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA073544Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 706, STR 3L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA073543Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 706, STR 2L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA073542Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 685, STR 2L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA073541Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 685, STR 3L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA073540Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 639, STR 3L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA073538Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 597, STR 8R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA073536Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 500D, STR 5R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA073539Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 616, STR 3R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA073504Stringer · damagedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE STRINGER 9L DAMAGED BETWEEN BS 360 TO BS 460. REPAIRED STR PER SRM.SDR SWAA073505Stringer · damagedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE STRINGER 9R DAMAGED BETWEEN BS 500B TO BS 510A. REPAIRED STR PER SRM.SDR SWAA073484Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 685, STR 2R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA073482Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 639, STR 3R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA073483Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 685, STR 3R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA073485Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 706, STR 2R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA073486Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 706, STR 3R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA073487Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 706, STR 10R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA073488Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 9R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA073489Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727E, STR 7R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA073490Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 747, STR 5R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA073477Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA073479Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA073481Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 767, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA073480Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA073476Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA073478Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA073502Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727E, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA073503Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 767, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA073062Torque Tube · wornDURING SCHEDULED HC2 CHECK, FOUND RIGHT WING 90 DEGREE TORQUE TUBE WORN AT NR 6 TRANSMISSION. REMOVED AND REPLACED TORQUE TUBE PER MM.
Back to N302SW, cancelled Sep 29, 2014