N741AS, cancelled May 1, 2007
Service difficulty reports · 319
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 = 'N741AS' AND deregistration_id = 'N741AS-2007-05-01' 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 = 'N741AS' AND deregistration_id = 'N741AS-2007-05-01' 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 ASAA0210076Receiver · inoperativeSEA - DURING MAINTENANCE CHECK, FOUND EMERGENCY FLOOR TRACK LIGHTS AT ROW 18 WOULD NOT EXTINGUISH. REMOVED AND REPLACED REMOTE ASSEMBLY RECEIVER THEN LIGHTS OPERATED NORMAL. (M)SDR ASAA0210057Battery · inoperativeSEA - DURING MAINTENANCE CHECK, FOUND EMERGENCY FLOOR TRACK LIGHTS IN THE AFT PORTION OF THE PASSENGER CABIN INOPERATIVE. REMOVED AND REPLACED REMOTE ASSEMBLY BATTERY (P/N 86210144) AND RECEIVER (P/N 883200312) THEN LIGHTS OPERATED NORMAL. (M)SDR ASAA0210056Battery · dischargedANC - DURING MAINTENANCE CHECK, FOUND EMERGENCY FLOOR TRACK LIGHTS AT ROWS 19 AND 20 INOPERATIVE. REMOVED AND REPLACED REMOTE ASSEMBLY BATTERY THEN LIGHTS OPERATED NORMAL. (M)SDR 2002F00327Battery Pack · dischargedANC - DURING MAINTENANCE CHECK, FOUND EMERGENCY EXIT IDENTIFIER ON SMOKE BARRIER INOPERATIVE. REMOVED AND REPLACED REMOTE ASSEMBLY BATTERY PACK AND EXIT IDENTIFIER ASSEMBLY, THEN EXIT IDENTIFIER OPERATED NORMALLY. (M)SDR ASAA0210048Battery Pack · dischargedANC - DURING MAINTENANCE CHECK, FOUND EMERGENCY EXIT IDENTIFIER ON SMOKE BARRIER INOPERATIVE. REMOVED AND REPLACED REMOTE ASSEMBLY BATTERY PACK AND EXIT IDENTIFIER ASSEMBLY, THEN EXIT IDENTIFIER OPERATED NORMALLY. (M)SDR 2002F00034Battery Pack · dischargedSEA - EMERGENCY EXIT LIGHT RECEIVER NOT INDICATING AT SEAT PALLET G-9. REMOVED AND REPLACED EMERGENCY EXIT LIGHT RECEIVER (P/N 883200312) AND BATTERY PACK (P/N 8821004), THEN OPS CHECKED GOOD. REF ASAA0110639. (M)SDR ASAA0110639Receiver · inoperativeSEA - EMERGENCY EXIT LIGHT RECEIVER NOT INDICATING AT SEAT PALLET G-9. REMOVED AND REPLACED EMERGENCY EXIT LIGHT RECEIVER (P/N 883200312) AND BATTERY PACK (P/N 8821004), THEN OPS CHECKED GOOD. (M)SDR ASAA0140622Tie Clip · corrodedPAE - DURING C-CHECK, FOUND CORROSION ON STRINGER TIE AT STATION 532 AND STRINGER 26R. REMOVED AND REPLACED STRINGER TIE IAW SRM. (M)SDR ASAA0140623Skin · corrodedPAE - DURING C-CHECK, FOUND FORWARD CARGO DOOR INNER SKIN LOWER EDGE 26 IN FROM EDGE OF DOOR IS CORRODED. REPAIRED IAW SRM. (M)SDR ASAA0140624Stringer · damagedPAE - DURING C-CHECK, FOUND DAMAGED STRINGER 12L AT STATION 1037.5. REPAIRED PER SRM. (M)SDR ASAA0140626Shear Tie · corrodedPAE - DURING C-CHECK, FOUND CORROSION ON SHEAR TIE AT STATION 520 AND STRINGER 27L TO 28L. REPAIR IAW SRM. (M)SDR ASAA0140611Skin · dentedPAE - DURING C-CHECK, FOUND DENT ON EXTERNAL SKIN AT BS 1037.5 AND STRINGER 9L AND 21. REPAIRED SKIN IAW DOUBLER. (M)SDR ASAA0140606Stringer Clip · corrodedPAE - DURING C-CHECK, FOUND CORROSION ON STRINGER TIE AT STATION 533 AND STRINGER 27L. REPAIRED IAW SRM. (M)SDR ASAA0140599Door Frame · corrodedPAE - DURING C-CHECK, FOUND CORROSION ON FORWARD SURFACE AFT FRAME OF AFT CARGO DOOR CUT OUT AT STRINGER 25R TO 23R. REPAIRED DAMAGED FRAME BY INSTALLING DOUBLER PER ENGINEERING REPAIR. (M)SDR ASAA0140607Stringer Clip · corrodedPAE - DURING C-CHECK, FOUND CORROSION ON STRINGER TIE AT STATION 533 AND STRINGER 27R. REPLACED STRINGER CLIP IAW SRM. (M)SDR ASAA0140608Stringer Clip · crackedPAE - DURING C-CHECK, FOUND CRACKED STRINGER CLIP AT BS 440 AND STRINGER 24L. REPLACED STRINGER CLIP PER SRM. (M)SDR ASAA0140609Stringer Clip · corrodedPAE - DURING C-CHECK, FOUND CORROSION ON STRINGER 35L CLIP AT BS 827 IN AFT CARGO BAY. REPLACED CLIP IAW SRM. (M)SDR ASAA0140610Stringer Clip · crackedPAE - DURING C-CHECK, FOUND CRACKED STRINGER CLIP AT STATION 440 AND STRINGER 24L. REPLACED STRINGER CLIP PER SRM. (M)SDR ASAA0140612Frame · dentedPAE - DURING C-CHECK, FOUND FRAME DENT AT BS 400 AND STRINGER 24L. REPAIRED PER SRM. (M)SDR ASAA0140613Sill · corrodedPAE - DURING C-CHECK, FOUND CORROSION ON LEFT OVERWING EXIT SILL. REPLACED SILL IAW SRM. (M)SDR ASAA0140614Frame · dentedPAE - DURING C-CHECK, FOUND FRAME DENTED AT STRINGER 25R AND BS 727A. REPAIRED IAW SRM. (M)SDR ASAA0140615Web · damagedPAE - DURING C-CHECK, FOUND SHEAR BEAM WEB TEMPORARY REPAIR AT STATION 727 LBL 65 AND WL 190. REPLACED SHEAR BEAM WEB IAW SRM. (M)SDR ASAA0140616Shear Tie · corrodedPAE - DURING C-CHECK, FOUND CORROSION ON SHEAR TIE AT STATION 520 BETWEEN STRINGER 26L AND 27L. REPAIRED SHEAR TIE IAW SRM. (M)SDR ASAA0140617Frame · dentedPAE - DURING C-CHECK, FOUND FRAME DENT AT STATION 420 AND STRINGER 24L. REPAIRED FRAME IAW SRM. (M)SDR ASAA0140618Door Frame · corrodedPAE - DURING C-CHECK, FOUND CORROSION AT FORWARD CARGO DOOR END FRAME 15 INCHES TO 34 INCHES FROM FORWARD EDGE. REPLACED IAW SRM. (M)SDR ASAA0140619Angle · crackedPAE - DURING C-CHECK, FOUND FORWARD CARGO DOOR LOWER FRAME WEB OUTER SKIN ANGLE AT LOWER FORWARD DOOR STAY FITTING CRACKED. REPLACES WEB IAW EA. (M)SDR ASAA0140620Stringer Clip · corrodedPAE - DURING C-CHECK, FOUND CORROSION ON STRINGER CLIP AT BS 986.5 AND STRINGER 27R. REPLACED CLIP AND STRINGER IAW SRM. (M)SDR ASAA0140600Frame · dentedPAE - DURING C-CHECK, FOUND FRAME DENT AT STATION 500 BETWEEN STRINGER 24R AND STRINGER 25R. REPAIRED IAW SRM. (M)SDR ASAA0140601Frame · dentedPAE - DURING C-CHECK, FOUND FRAME DENT AT BS 500A BETWEEN STRINGER 24R AND 25R. REPAIRED IAW ENGINEERING REPAIR. (M)SDR ASAA0140602Frame · dentedPAE - DURING C-CHECK, FOUND FRAME DENT AT BS 500A BETWEEN STRINGER 24L AND 25L. REPAIRED IAW ENGINEERING REPAIR. (M)SDR ASAA0140603Stringer · corrodedPAE - DURING C-CHECK, FOUND CORROSION ON STRINGER 26R AND STATION 419. REPAIRED PER SRM. (M)SDR ASAA0140604Shear Tie · corrodedPAE -DURING C-CHECK FOUND CORROSION ON SHEAR TIE STATION 520 BETWEEN STRINGER 26L AND 27L. REPAIRED IAW SRM. (M)SDR ASAA0140605Stringer · corrodedPAE - DURING C-CHECK, FOUND CORROSION ON STRINGER 27R AT STATION 531. REPAIRED IAW SRM. (M)SDR ASAA0140621Threshold · corrodedPAE - DURING C-CHECK, FOUND CORROSION ON MAIN CARGO DOOR THRESHOLD WEB AT STATION 400-497. REMOVED AND REPLACED DAMAGED SECTION OF WEB PER SRM AND ENGINEERING REPAIR. (M)SDR ASAA0110595Tie · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND STRINGER TIE AT BODY STATION 727A, STRINGER 27L CORRODED. REPAIRED PER SRM. (M)SDR ASAA0110594Stringer · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND STRINGER 27R AT BODY STATION 531-533, CORRODED. REPAIRED PER SRM. (M)SDR ASAA0110576Receiver · inoperativeANC - DURING SCHEDULED MAINTENANCE CHECK, FOUND FLOOR TRACK LIGHTING AT SEAT PALLET 9 INOPERATIVE. REMOVED AND REPLACED REMOTE ASSEMBLY RECEIVER THEN LIGHTS TESTED NORMAL. (M)SDR ASAA0110572Guide · out of adjANC - DURING MAINTENANCE CHECK, FOUND L1 DOOR DIFFICULT TO CLOSE. ADJUSTED GUIDE ARM AND DOOR OPERATED NORMALLY. (M)SDR 2001F00668Receiver · defectiveANC - DURING MAINTENANCE CHECK, FOUND EMERGENCY EXIT LIGHTS AT ROW 11 WERE SLOW TO RESPOND AND WOULD NOT EXTINGUISH. REMOVED AND REPLACED BATTERY PACK P/N 8821004, AND REMOTE ASSEMBLY RECEIVER P/N 883200312, THEN LIGHTS TESTED NORMAL. REF ASAA0110571 (M)SDR ASAA0110571Battery Pack · dischargedANC - DURING MAINTENANCE CHECK, FOUND EMERGENCY EXIT LIGHTS AT ROW 11 WERE SLOW TO RESPOND AND WOULD NOT EXTINGUISH. REMOVED AND REPLACED BATTERY PACK P/N 8821004, AND REMOTE ASSEMBLY RECEIVER P/N 883200312, THEN LIGHTS TESTED NORMAL. (M)SDR 2001F00250Battery · dischargedSEA - DURING MAINTENANCE CHECK, FOUND EMERGENCY EXIT LIGHTS ON SEAT PALLET 10-3 AND SMOKE BARRIER WOULD NOT TEST. REMOVED AND REPLACED BATTERY PACK AND REMOTE ASSEMBLY BATTERY, THEN LIGHTS TESTED NORMAL. (M)SDR ASAA0110365Battery Pack · dischargedSEA - DURING MAINTENANCE CHECK, FOUND EMERGENCY EXIT LIGHTS ON SEAT PALLET 10-3 AND SMOKE BARRIER WOULD NOT TEST. REMOVED AND REPLACED BATTERY PACK AND REMOTE ASSEMBLY BATTERY, THEN LIGHTS TESTED NORMAL. (M)SDR ASAA0110219Battery · dischargedSEA - DURING MAINTENANCE CHECK, FOUND EMERGENCY TRACK LIGHTS AND EXIT LIGHTS ON THE SMOKE BARRIER WOULD NOT TEST AFTER AIRCRAFT RECONFIGURATION. REMOVED AND REPLACED REMOTE ASSEMBLY BATTERIES ON THE SMOKE BARRIER AND THE AFT MOST SEAT PALLET, THEN LIGHTS OPERSDR ASA2001F00000Battery · dischargedSEA - DURING MAINTENANCE CHECK, FOUND EMERGENCY TRACK LIGHTS INOPERATIVE ON SEAT PALLET 9-4, ROW 16. REMOVED AND REPLACED REMOTE ASSEMBLY BATTERY AND RECEIVER, THEN LIGHTS TESTED NORMAL. REF ASAA0110208. (M)SDR ASAA0110208Receiver · inoperativeSEA - DURING MAINTENANCE CHECK, FOUND EMERGENCY TRACK LIGHTS INOPERATIVE ON SEAT PALLET 9-4, ROW 16. REMOVED AND REPLACED REMOTE ASSEMBLY BATTERY AND RECEIVER, THEN LIGHTS TESTED NORMAL. (M)SDR ASAA0110120Control Handle · dirtyANC - AFTER DEPARTURE FROM ANC ON FLIGHT 45, THE LEFT MAIN GEAR FELL BACK DOWN BUT RETRACTED WHEN GEAR LEVER CYCLED BACK UP. FOUND GEAR HANDLE SHAFT DIRTY AND GUMMED UP. WHEN PULLED OUT IT WOULD NOT DROP INTO DETENTS. CLEANED HANDLE SHAFT AND LUBED, HANDLE SDR ASAA0110095Battery · dischargedSEA - DURING MAINTENANCE CHECK, FOUND AFT EMERGENCY EXIT IDENTIFIER INOPERATIVE. REMOVED AND REPLACED REMOTE ASSEMBLY BATTERY AND SIGN WORKED NORMALLY. (M)SDR 20010329SG003Battery · dischargedSEA - DURING MAINTENANCE CHECK, FOUND EMERGENCY EXIT LIGHT ON SMOKE BARRIER WILL NOT TEST. REPLACED BATTERY AND RECEIVER, LIGHT OPERATED NORMAL. (M)SDR ASAA0110048Receiver · inoperativeSEA - DURING MAINTENANCE CHECK, FOUND EMERGENCY EXIT LIGHT ON SMOKE BARRIER WILL NOT TEST. REPLACED BATTERY AND RECEIVER, LIGHT OPERATED NORMAL. (M)SDR ASAA0110030Battery · dischargedSEA - DURING MAINTENANCE CHECK, FOUND SMOKE BARRIER EMERGENCY EXIT LIGHT FAILS TEST. REPLACED SMOKE BARRIER EMERGENCY EXIT BATTERY, LIGHTS THEN TESTED NORMAL. (M)
Back to N741AS, cancelled May 1, 2007