N507SW, cancelled Jan 29, 2014
Service difficulty reports · 338
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 = 'N507SW' AND deregistration_id = 'N507SW-2014-01-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 = 'N507SW' AND deregistration_id = 'N507SW-2014-01-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 SWAA096786Keelbeam · corrodedDURING SCHEDULED 20Y CHECK, FOUND KEEL BEAM CORRODED AT BS 428B, STR 28R. REPAIRED BEAM PER SRM.SDR SWAA096624Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 787, STR 7R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096614Fitting · corrodedDURING SCHEDULED 20Y CHECK, FOUND LT MLG BEAM LUG FITTING CORRODED. REMOVED AND REPLACED FITTING PER MM.SDR SWAA096613Fitting · corrodedDURING SCHEDULED 20Y CHECK, FOUND RT MLG BEAM LUG FITTING CORRODED. REMOVED AND REPLACED FITTING PER MM.SDR SWAA096603Light · inoperativeDURING SCHEDULED 20Y CHECK, FOUND RT OVERWING EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BULB PER MM.SDR SWAA096601Skin · corrodedDURING SCHEDULED 20Y CHECK, FOUND SKIN CORRODED BETWEEN BS 727A TO BS 727B, BETWEEN RBL 3 TO LBL 3. REPAIRED SKIN PER SRM.SDR SWAA096559Rib · crackedDURING SCHEDULED 20Y CHECK, FOUND LT HORIZONTAL STABILIZER RIB CHORD CRACKED AT STA 149.12. REMOVED AND REPLACED CHORD PER SRM.SDR SWAA096538Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND SKIN CRACKED AT BS 265, STR 10L. REPAIRED SKIN PER ER.SDR SWAA096537Skin · delaminatedDURING SCHEDULED 20Y CHECK, FOUND LT WING I/B FORE FLAP SKIN DELAMINATED. REPAIRED SKIN PER SRM.SDR SWAA096536Flap · delaminatedDURING SCHEDULED 20Y CHECK, FOUND LT WING I/B FORE FLAP DELAMINATED. REPAIRED FORE FLAP PER SRM.SDR SWAA096414Lug · corrodedDURING SCHEDULED 20Y CHECK, FOUND RT MLG BEAM STABILIZER BAR LUG FACES CORRODED. REMOVED AND REPLACED LUG PER MM.SDR SWAA096413Lug · corrodedDURING SCHEDULED 20Y CHECK, FOUND LT MLG BEAM STABILIZER BAR LUG FACES CORRODED. REMOVED AND REPLACED LUG PER MM.SDR SWAA096410Flap · delaminatedDURING SCHEDULED 20Y CHECK, FOUND LT WING I/B FORE FLAP DELAMINATED. REPAIRED FORE FLAP PER SRM.SDR SWAA096388ALug · corrodedDURING SCHEDULED 20Y CHECK, FOUND RT MLG BEAM STABILIZER BAR LUG FACES CORRODED. REMOVED AND REPLACED LUG PER MM.SDR SWAA096387ALug · corrodedDURING SCHEDULED 20Y CHECK, FOUND LT MLG BEAM STABILIZER BAR LUG FACES CORRODED. REMOVED AND REPLACED LUG PER MM.SDR SWAA096384AFlap · delaminatedDURING SCHEDULED 20Y CHECK, FOUND LT WING I/B FORE FLAP DELAMINATED. REPAIRED FORE FLAP PER SRM.SDR SWAA096390Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 947, RBL 23. REPAIRED FRAME PER SRM.SDR SWAA096364AFrame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 947, RBL 23. REPAIRED FRAME PER SRM.SDR SWAA096351Flap · delaminatedDURING SCHEDULED 20Y CHECK, FOUND RT WING I/B FORE FLAP DELAMINATED. REMOVED AND REPLACED FORE FLAP PER MM.SDR SWAA096350Wedge · delaminatedDURING SCHEDULED 20Y CHECK, FOUND RT WING NR 3 SLAT I/B END T/E WEDGE DELAMINATED. REPAIRED WEDGE PER SRM.SDR SWAA096349Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND SKIN CRACKED BETWEEN BS 821 TO BS 823, BETWEEN STR 1R TO STR 2R. REPAIRED SKIN PER SRM.SDR SWAA096348Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 8L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096347Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 9L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096346Shear Tie · corrodedDURING SCHEDULED 20Y CHECK, FOUND SHEAR TIE CORRODED AT BS 482B, STR 28R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA096345Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND SKIN CRACKED AT BS 942, STR 24R. REPAIRED SKIN PER SRM.SDR SWAA096344Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND SKIN CRACKED AT BS 932, STR 23R. REPAIRED SKIN PER SRM.SDR SWAA096306Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 4L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096284Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 807, STR 4L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096283Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 807, STR 9L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096282Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 747, STR 4L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096281Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 7L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096280Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 639, STR 4L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096279Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 7R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096278Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 482, STR 25R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096247Fitting · corrodedDURING SCHEDULED 20Y CHECK, FOUND RT BS 685 FRAME LOWER FITTING CORRODED. REPAIRED FITTING PER EA.SDR SWAA096234Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CRACKED AT BS 400, STR 4L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096233Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 685, STR 6L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096232Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 597, STR 7L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096231Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 597, STR 8L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096230Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 400, STR 4L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096229Frame · corrodedDURING SCHEDULED 20Y CHECK, FOUND FWD CARGO BAY FRAME CORRODED AT BS 482A, BL 0. REPAIRED FRAME PER SRM.SDR SWAA096176Flap · delaminatedDURING SCHEDULED 20Y CHECK, FOUND RT WING I/B FORE FLAP DELAMINATED. REPAIRED FORE FLAP PER SRM.SDR SWAA096175Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 767, STR 10R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096174Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 747, STR 10R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096173Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 5R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096172Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 6R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096171Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 8R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096170Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 578, STR 8R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096169Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 7R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096168Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 8R. REMOVED AND REPLACED CLIP PER SRM.
Back to N507SW, cancelled Jan 29, 2014