N620SW, cancelled Nov 15, 2018
Service difficulty reports · 407
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 = 'N620SW' AND deregistration_id = 'N620SW-2018-11-15' 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 = 'N620SW' AND deregistration_id = 'N620SW-2018-11-15' 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 SWAA2013050315560Battery Pack · dischargedEXTERNAL FUSELAGE EMERGENCY LIGHT INOP AT FORWARD ENTRY. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA2013050315559Battery Pack · dischargedFORWARD ENTRY LOWER EMERGENCY LIGHT INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA2013021112525Slide · low pressureFOUND AFT SERVICE DOOR EVAC SLIDE PRESSURE TO BE OUT OF GREEN BAND. REMOVED AND REPLACED AFT SERVICE DOOR EVAC SLIDE IAW MT 325-61-06 TAG 607956: P/N OFF/ON:D31354-433 S/N OFF:1376 S/N ON:2447SDR SWAA2012092407924Battery Pack · dischargedRIGHT EMERGENCY EXIT OVERHEAD STOW BINS AISLE LIGHTS INOP BETWEEN ROW 12 TO ROW 23. REMOVED AND REPLACED BATTERY PACK IAW AMM.SDR SWAA2012092407905Fuse · blownRIGHT EMERGENCY EXIT OVERHEAD STOW BINS AISLE LIGHTS INOP BETWEEN ROW 12 TO ROW 23. REMOVED AND REPLACED FUSE IAW AMM.SDR SWAA2012091307572Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 908, STR 4L. REMOVED & REPLACED CLIP IAW SRM & DWG.SDR SWAA2012091307571Stringer · crackedSTRINGER CRACKED BETWEEN BS 360 TO BS 390, STR 2L. REPAIRED STRINGER PER SRM.SDR SWAA2012092407923Stringer · crackedSTRINGER CRACKED BETWEEN BS 727B+10 TO BS 727D+10, STR 3R. REPAIRED STRINGER IAW REO AND EA.SDR SWAA2012092107873Stringer · crackedSTRINGER CRACKED BETWEEN BS 817 TO BS 837, STR 3R. REPAIRED STRINGER IAW EA.SDR SWAA2012092107872Stringer · crackedSTRINGER CRACKED AT BETWEEN BS 727E+10 TO BS 757, STR 3R. REPAIRED STRINGER IAW EA.SDR SWAA2012091307570Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 420, STR 1. REMOVED AND REPLACED CLIP IAW SRM AND BAC DWG.SDR SWAA2012092407922Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 500A+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012092107871Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 837, STR 4R. REPAIRED SKIN IAW EA.SDR SWAA2012092107870Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 727C+19, STR 4R. REPAIRED SKIN IAW EA.SDR SWAA2012092007805Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 500B+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012092007804Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 500C+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012092007803Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 440+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012092007802Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 380+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012092007801Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 500C+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012092007800Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 380+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012092007799Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 500C+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012092007798Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 520+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012091907775Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 360+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPARIED SKIN IAW EA.SDR SWAA2012091907774Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 420+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012091907773Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 480+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012091907772Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 500+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012091907771Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 360+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012091907770Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 500A+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012091707690Stringer · crackedSTRINGER CRACKED BETWEEN BS 727D+10 TO BS 837, STR 5R. REPAIRED STRINGER IAW EA.SDR SWAA2012091707689Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 520+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012091707688Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 480+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012091707687Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 400+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012091707686Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 360+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012091707685Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 500+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012091707684Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 420+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012091707683Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 400+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012091707682Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 520+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012091707681Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 500B+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012091707680Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 380+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012091707679Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 380+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012091707678Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 360+10 UPPER FORWAARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012091407618Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 500+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012091407617Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 420+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012091407616Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 500B+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012091307569Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 500C+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012091207545Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 400+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012091207544Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 500A+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012091207543Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 460+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012091207542Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 500+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012091207541Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 440+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.
Back to N620SW, cancelled Nov 15, 2018