N716SW, cancelled Nov 13, 2024
Service difficulty reports · 274
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 = 'N716SW' AND deregistration_id = 'N716SW-2024-11-13' 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 = 'N716SW' AND deregistration_id = 'N716SW-2024-11-13' 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 SWAA2016051651829Seat Track · corrodedFLOOR TRACK CORRODED BETWEEN BS 927 - 934, LBL 3. R & R FLOOR TRACK IAW SRM & DWG.SDR SWAA2016051651828Intercostal · corrodedINTERCOSTAL CORRODED BETWEEN BS 847 - 855, LBL 7. R & R INTERCOSTAL IAW SRM & DWG.SDR SWAA2016051651827Intercostal · corrodedINTERCOSTAL CORRODED BETWEEN BS 784 - 800, RBL 6. R & R INTERCOSTAL IAW DWG & SRM.SDR SWAA2016050551586Intercostal · corrodedINTERCOSTAL CORRODED, BETWEEN BS 727A - 727A+6, LBL 3. R & R INTERCOSTAL IAW SRM.SDR SWAA2016050551572Fitting · corrodedKEEL BEAM CLIP CORRODED AT BS 727D, STRINGER 27L. R & R CLIP IAW SRM & DWG.SDR SWAA2016042951415Intercostal · corrodedINTERCOSTAL CORRODED, BETWEEN BS 727A - 727A+2, RBL 3. R & R INTERCOSTAL IAW DWG & SRM.SDR SWAA2016042651342Seat Track · crackedFLOOR TRACK CRACKED AT BS 767, RBL 14. R & R FLOOR TRACK IAW SRM.SDR SWAA2016042251239Support · crackedBULKHEAD SUPPORT CRACKED AT BS 727, RBL 4. R & R SUPPORT IAW SRM & DWG.SDR SWAA2016012148232Battery Pack · dischargedLEFT GND EMER EXIT LIGHT INOPERATIVE. R & R BATTERY PACK ASSEMBLY IAW AMM.SDR SWAA2015081742875Bracket · looseR2 DOOR EMER EVAC SLIDE GIRT BAR BRACKET LOOSE. SECURED BRACKET IAW SIP.SDR SWAA2015081142647Cover · looseRIGHT OVERWING EXIT DOOR SIGN COVER LOOSE. SECURED SIGN IAW EA.SDR SWAA2015061640781Cover · unsecureOVERWING EXIT SIGN COVER FELL OFF. REINSTALLED COVER IAW AMM.SDR SWAA2015060340322Slide · out of positionR1 DOOR SLIDE OUT OF ADJUSTMENT. REPOSITIONED SLIDE IAW MM.SDR SWAA2015041538546Light · inoperativeRIGHT OVERWING EMER HATCH LIGHT INOPERATIVE. RELAMPED LIGHT IAW AMM.SDR SWAA2015012235986Battery Pack · failedEMERGENCY LIGHTING BATTERY PACK M1669 FAILED TEST. R & R BATTERY PACK IAW AMM.SDR SWAA2014072830421Light · brokenR1 DOOR EXIT LIGHT BROKEN. R & R LIGHT ASSEMBLY IAW MM.SDR SWAA2014071730073Battery · dischargedRIGHT MID CABIN SERVICE DOOR SLIDE EMER LIGHT SIGN INOPERATIVE. R & R BATTERY IAW MM.SDR SWAA2014071730067Light · inoperativeRIGHT BULLNOSE EMER LIGHT INOPERATIVE AT ROW 18. R & R LIGHT ASSEMBLY IAW MM.SDR SWAA2014061128949Slide · low pressureL2 DOOR EMER EVAC SLIDE PRESS LOW. R & R SLIDE ASSEMBLY IAW MT.SDR SWAA2014060528730Connector · looseRIGHT OVERWING EMER EXIT LOCATOR SIGN CONNECTOR LOOSE. RECONNECTED SIGN IAW WDM & MM.SDR SWAA2014060428673Support Angle · crackedRIGHT LOWER FUSELAGE SUPPORT ANGLE CRACKED AT OTBD OF RT RAM AIR EXHAUST DUCT. R & R ANGLE IAW SRM & DWG.SDR SWAA2014060628796Window Frame · crackedCOCKPIT RT NR 1 WINDOW FRAME CRACKED AT UPPER OTBD CORNER. REPAIRED FRAME IAW EA.SDR SWAA2014060228621Seat Track · crackedMAIN CABIN SEAT TRACK FLANGE CRACKED AT BS 727B, LBL 45.5. REPAIRED FLANGE IAW EA.SDR SWAA2014060628795Frame · crackedFRAME CRACKED AT BS 907, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2014060528729Frame · crackedFRAME CRACKED AT BS 500C, STRINGER 8R. REPAIRED FRAME IAW SRM & EA.SDR SWAA2014060528728Frame · crackedFRAME CRACKED AT BS 480, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2014060428687Frame · crackedFRAME CRACKED AT BS 400, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2014060428686Frame · crackedFRAME CRACKED AT BS 827, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2014060428685Frame · crackedFRAME CRACKED AT BS 500C, STRINGER 8L. REPAIRED FRAME IAW SRM.SDR SWAA2014060428684Frame · crackedFRAME CRACKED AT BS 500A, STRINGER 8L. REPAIRED FRAME IAW SRM.SDR SWAA2014060428683Frame · crackedFRAME CRACKED AT BS 440, STRINGER 8L. REPAIRED FRAME IAW SRM.SDR SWAA2014060428682Frame · crackedFRAME CRACKED AT BS 400, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2014052828393Seal · crackedRIGHT HORIZONTAL STABILIZER LOWER AFT PANEL 343AB INBD AFT SEAL CRACKED. R & R SEAL IAW SRM.SDR SWAA2014052828392Keelbeam · crackedRIGHT KEEL BEAM CRACKED AT BS 663, BETWEEN RBL 8 TO RBL16. REPAIRED KEEL BEAM IAW SRM.SDR SWAA2014060528738Structure · crackedRIGHT CHORD CRACKED AT BS 540, BETWEEN STRINGER 22R TO STRINGER 23R. REPAIRED CHORD IAW EA.SDR SWAA2014060628794Skin · corrodedAFT CARGO DOOR INNER SKIN CORRODED AT FWD LOWER. REPAIRED SKIN IAW SRM & EA.SDR SWAA2014060528723Skin · crackedFUSELAGE SKIN CRACKED BETWEEN BS 364 TO BS 371, BETWEEN STRINGER 17L TO STRINGER 17R. REPAIRED SKIN IAW AMM.SDR SWAA2014060528722Skin · crackedFUSELAGE SKIN CRACKED BETWEEN BS 890 TO BS 900, BETWEEN STRINGER 17L TO STRINGER 17R. REPAIRED SKIN IAW AMM.SDR SWAA2014060228620Intercostal · crackedE & E COMPARTMENT FLOORBEAM INTERCOSTAL CRACKED BETWEEN BS 344 TO BS 360, LBL 11. R & R INTERCOSTAL IAW SRM & DWG.SDR SWAA2014060228616Intercostal · crackedE & E COMP FLOORBEAM INTERCOSTAL CRACKED BETWEEN BS 312 TO BS 328, LBL 45. R & R INTERCOSTAL IAW SRM & DWG.SDR SWAA2014060528737Structure · crackedLEFT CHORD CRACKED AT BS 540, BETWEEN STRINGER 22L TO STRINGER 23L. REPAIRED CHORD IAW EA.SDR SWAA2014052828391Panel · crackedLEFT WW BEHIND HYD PTU VLV WEB PANEL CRACKED ALONG FASTENERS ROW. REPAIRED PANEL IAW SRM.SDR SWAA2014060328648Flap · damagedLEFT WING NR 1 KRUEGER FLAP DAMAGED AT INBD CORNER. R & R KRUEGER FLAP ASSEMBLY IAW AMM.SDR SWAA2014032726570Panel · crackedRIGHT WING LE COVE PANEL CRACKED. R & R PANEL IAW DWG & SRM.SDR SWAA2014033126666Panel · crackedRIGHT LE PANEL CRACKED. R & R PANEL IAW DWG & SRM.SDR SWAA2013120322919Light · inoperativeLT OVERWING EMERGENCY EXIT LIGHT INOPERATIVE. RELAMPED LIGHT IAW AMM.SDR SWAA2013120322918Light · inoperativeRT OVERWING EMERGENCY EXIT LIGHT INOPERATIVE. RELAMPED LIGHT IAW AMM.SDR SWAA2013120322917Sign · inoperativeRT OVERWING AFT EMERGENCY EXIT SIGN INOPERATIVE. RELAMPED SIGN IAW AMM.SDR SWAA2013100120633Plate · crackedLT WING LOWER FIXED TE PANEL AFT OF ENGINE CRACKED WIGGLE PLATE. R & R PLATE SRM.SDR SWAA2013050215444Slide · looseR2 DOOR EMERGENCY EVAC SLIDE LOOSE. SECURED SLIDE IAW MM.
Back to N716SW, cancelled Nov 13, 2024