N9621A, cancelled Mar 2, 2020
Service difficulty reports · 144
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 = 'N9621A' AND deregistration_id = 'N9621A-2020-03-02' 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 = 'N9621A' AND deregistration_id = 'N9621A-2020-03-02' 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 AALA201905219012Cable · detachedAIRCRAFT WAS NOT GROUNDED: R1 DOOR SLIDE, GIRT BAR, SAFETY CABLE WAS NOT ATTACHED. MAINTENANCE REATTACHED LANYARD PER MM 25-62-00.SDR AALA2019040102Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: L1 DOOR EMERGENCY FLASHLIGHT INOPERABLE. MAINTENANCE REPLACED FLASHLIGHT PER STANDARD PRACTICES AND PERORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA2019032219001Seal · dirtyFOUND AN AIR LEAK IN THE AFT GALLEY DOOR AFTER TAKE OFF. AIR LEAK SUBSIDES AFTER AIRPLANE PRESSURIZED WITH MANUAL PRESSURIZATION. MAINTENANCE CLEANED THE SEAL AND ACCOMPLISHED LEAK CHECK AND FOUND WITHIN LIMITS IAW AMM 21-00-00.SDR AALA201902051002Cusp Web · corrodedCORROSION FOUND ON THE CUSP WEB BETWEEN BS 787 AND 788. REPAIRED THE CUSP WEB IAW SRM 53-05-00.SDR AALA20190129001Pan · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED WINDOW RING PAN BETWEEN BS 1078 AND BS 1079 AT S11L. REPAIRED WINDOW RING PAN PER 53-10-00-25SDR AALA201901299012Pan · crackedAIRCRAFT IN BASE MAINTENANCE: WINDOW RING PAN CRACKED BETWEEN BS 1078 AND BS 1079 AT S14R. REPAIRED WINDOW RING PAN PER 53-10-00-25.SDR AALA20190128011Pan · crackedAIRCRAFT IN BASE MAINTENANCE: WINDOW RING PAN CRACKED BETWEEN BS 844 AND BS 845 AT S14L. REPAIRED WINDOW RING PAN PER 53-10-00-25.SDR AALA20190128009Pan · crackedAIRCRAFT IN BASE MAINTENANCE: WINDOW RING PAN CRACKED BETWEEN BS 806 AND BS 807 AT S14L. REPAIRED WINDOW RING PAN PER 53-10-00-25.SDR AALA20190128008Pan · crackedAIRCRAFT IN BASE MAINTENANCE: WINDOW RING PAN CRACKED BETWEEN BS 1021 AND BS 1022 AT S11R. REPAIRED WINDOW RING PAN PER 53-10-00-25.SDR AALA20190128007Pan · crackedAIRCRAFT IN BASE MAINTENANCE: WINDOW RING PAN CRACKED BETWEEN BS 1059 AND BS 1060 AT S11R. REPAIRED WINDOW RING PAN PER 53-10-00-25.SDR AALA20190128006Pan · crackedAIRCRAFT IN BASE MAINTENANCE: WINDOW RING PAN CRACKED BETWEEN BS 1097 AND BS 1098 AT S11R. REPAIRED WINDOW RING PAN PER 53-10-00-25.SDR AALA20190128005Pan · crackedAIRCRAFT IN BASE MAINTENANCE: WINDOW RING PAN CRACKED BETWEEN BS 945 AND BS 946 AT S11L. REPAIRED WINDOW RING PAN PER 53-10-00-25.SDR AALA20190128004Pan · crackedAIRCRAFT IN BASE MAINTENANCE: WINDOW RING PAN CRACKED BETWEEN BS 1021 AND BS 1022 AT S11L. REPAIRED WINDOW RING PAN PER 53-10-00-25.SDR AALA20190128003Pan · crackedAIRCRAFT IN BASE MAINTENANCE: WINDOW RING PAN CRACKED BETWEEN BS 947 AND BS 948 AT S11R. REPAIRED WINDOW RING PAN PER 53-10-00-25.SDR AALA201901285009Pan · crackedWINDOW RING PAN WAS CRACKED AT BS 1041, LONGERON 11L. REPAIRED THE WINDOW RING PAN IAW RD 53-10-00-25.SDR AALA201901285007Pan · crackedWINDOW RING PAN CRACKED AT BS 846 AND LONGERON 11R. REPAIRED WINDOW RING PAN IAW RD 53-10-00-25.SDR AALA201901285006Pan · crackedWINDOW RING PAN CRACKED AT BS 808, LONGERON 11R. REPAIRED WINDOW RING PAN IAW RD 53-10-00-25.SDR AALA201901285003Longeron · crackedCRACKED LONGERON 20L AT BS 1003. REPAIRED THE LONGERON IAW SRM 53-02-00-001.SDR AALA201806299009Gcu · failedAIRCRAFT WAS GROUNDED. AFTER STARTING APU INFLIGHT 5 MINUTES IN, THE APU GENERATOR TRIPPED OFFLINE. COUPLED WITH THE LEFT GENERATOR FAILURE IN MIC# 34440469 - WE DECLARED EMERGENCY AND LANDED IN AUS. LANDED WITHOUT INCIDENT, FLIGHT CHANGED EQUIPMENT AND CONTINSDR AALA201806299005Gcu · failedAIRCRAFT WAS GROUNDED. ON TAKE OFF FROM SAT NR 1 ENGINE GENERATOR DROPPED OFFLINE. CHECKLIST RAN AND RESET ATTEMPTED BUT UNSUCCESSFUL. EMERGENCY DECLARED AND AC DIVERTED TO AUS. LANDED WITHOUT INCIDENT, FLIGHT CHANGED EQUIPMENT AND CONTINUED. REPLACED LEFT ENSDR AALA20180628017Generator · failedAIRCRAFT WAS GROUNDED. ON TAKE OFF FROM SAT NR 1 ENGINE GENERATOR DROPPED OFFLINE. CHECKLIST RAN AND RESET ATTEMPTED BUT UNSUCCESSFUL. EMERGENCY DECLARED AND AC DIVERTED TO AUS. LANDED WITHOUT INCIDENT, FLIGHT CHANGED EQUIPMENT AND CONTINUED. REPLACED LEFT ENSDR AALA201805179011Battery Pack · inoperativeAIRCRAFT WAS NOT GROUNDED. EMERGENCY LIGHTS NEAR SEATS 28 THROUGH 30, AND AFT GALLEY REMAIN ILLUMINATED AFTER POWER IS REMOVED FROM AIRCRAFT. OPERATIONS TEST OF EMERGENCY LIGHTS SHOWS ROWS 8, 13, 20 AND 28 OVERHEAD AISLE LIGHTS INOPERATIVE. REPLACED BATTERY PASDR AALA201805179010Battery Pack · inoperativeEMERGENCY LIGHTS NEAR SEATS 28 THROUGH 30, AND AFT GALLEY REMAIN ILLUMINATED AFTER POWER IS REMOVED FROM AIRCRAFT. OPERATIONS TEST OF EMERGENCY LIGHTS SHOWS ROWS 8, 13, 20 AND 28 OVERHEAD AISLE LIGHTS INOPERATIVE. REPLACED BATTERY PACKS IAW AMM 33-55-00.SDR AALA201805179009Battery Pack · inoperativeEMERGENCY LIGHTS NEAR SEATS 28 THROUGH 30, AND AFT GALLEY REMAIN ILLUMINATED AFTER POWER IS REMOVED FROM AIRCRAFT. OPERATIONS TEST OF EMERGENCY LIGHTS SHOWS ROWS 8, 13, 20 AND 28 OVERHEAD AISLE LIGHTS INOPERATIVE. REPLACED BATTERY PACKS IAW AMM 33-55-00.SDR AALA201805179003Battery Pack · inoperativeEMERGENCY LIGHTS NEAR SEATS 28 THROUGH 30, AND AFT GALLEY REMAIN ILLUMINATED AFTER POWER IS REMOVED FROM AIRCRAFT. OPS TESTED THE EMERGENCY LIGHTS SHOWS ROWS 8, 13, 20 AND 28 OVERHEAD AISLE LIGHTS INOPERATIVE. REPLACED THE BATTERY PACKS IAW AMM 33-55-00.SDR AALA201804239043Window · delaminatedFIRST OFFICER`S WINDOW R1 DELAMINATED AND OBSCURES VISION. REMOVED AND REPLACED THE R1 WINDOW IAW AMM 56-10-02-201. LEAK AND OPS CHECKED OK.SDR AALA201804239042Windshield · delaminatedCAPTAIN`S L1 WINDOW DELAMINATED AND OBSCURES VISION. REPLACED THE L1 WINDOW IAW AMM 56-10-02 LK. AIRCRAFT WAS GROUNDED.SDR AALA2018042009033Switch · faultedENROUTE TO CLE, LEFT ENGINE OUTLET AND RISE WENT TO FULL SCALE HIGH. DISCONNECTED THE CONSTANT SPEED DRIVE. NR 1 GENERATOR FAILURE AND APU WOULD NOT START. EMERGENCY WAS DECLARED, FLIGHT DIVERTED AND LANDED WITHOUT INCIDENT. MAINTENANCE REPLACED CENTRIFUGAL SDR AALA201804199032Generator · failedENROUTE, LEFT ENGINE OUTLET AND RISE WENT TO FULL SCALE HIGH-DISCONNECTED CONSTANT SPEED DRIVE. NR 1 GENERATOR FAILURE AND APU WOULD NOT START. EMERGENCY WAS DECLARED, FLIGHT DIVERTED AND LANDED WITHOUT INCIDENT. MAINTENANCE REPLACED CENTRIFUGAL SWITCH ON APUSDR AALA201804199031Oil Cooler · faultedENROUTE, LEFT ENGINE OUTLET AND RISE WENT TO FULL SCALE HIGH. DISCONNECTED CONSTANT SPEED DRIVE. NR 1 GENERATOR FAILURE AND APU WOULD NOT START. EMERGENCY WAS DECLARED, FLIGHT DIVERTED AND LANDED WITHOUT INCIDENT. MAINTENANCE REPLACED THE CENTRIFUGAL SWITCHSDR AALA201804139001Strap · brokenFLASHLIGHT IN THE AFT CABIN BY L4 DOOR WILL NOT STAY MOUNTED. STRAP IS BROKEN. REPLACED THE AFT FLASHLIGHT HOLDER AND LIGHT ASSEMBLY IAW AMM 25-60-00.SDR AALA201802229028Slide · defectiveR1 DOOR SLIDE GIRT FLAP IS NOT FOLDED CORRECTLY. REPLACED R1 DOOR SLIDE IAW MCM 25-94-20.SDR AALA201802029029Gust Lock · bentFORWARD ENTRY DOOR GUST LOCK FOUND BENT, AND WILL NOT LOCK INTO SLOT. HITS FUSELAGE. REPLACED GUST LOCK IAW AMM 52-11-00.SDR AALA201712059060Slide · defectiveAIRCRAFT NOT GROUNDED. REAR GALLEY SERVICE DOOR ESCAPE SLIDE DIFFICULT TO ARM. THERE IS RESISTANCE BETWEEN GIRT BAR AND SLIDE ACTUATION LANYARD. LANYARD IS NOT FULLY STOWED. REPLACED L2 SERVICE DOOR SLIDE PER AMM 25-62-00.SDR AALA201712059052Sliding Window · out of adjustAIRCRAFT WAS GROUNDED. FIRST OFFICER'S SLIDING WINDOW IS DIFFICULT TO LOCK AND UNLOCK WHEN OPEN. ADJUSTED CLEARVIEW WINDOW PER AMM 56-10-03 AND PERFORMED LUBRICATION PER AMM 12-21-03. OPERATIONAL CHECK GOOD.SDR AALA201708229025Channel · crackedCRACK IN MAIN LANDING GEAR DOOR FRAME IN LEFT WHEEL WELL FORWARD PORTION OF WHALE BONE, EXTENDING UNDER A HYDRAULIC SERVICE LINE BRACKET. REPAIRED THE FORWARD CHANNEL IAW EA 272680A. AIRCRAFT WAS GROUNDED.SDR AALA20170213005Skin · crackedAIRCRAFT WAS GROUNDED. DURING PRE-TAXI WALK AROUND, MAINTENANCE NOTICED A 2 INCH CRACK ON THE LEFT AFT TAIL SECTION SKIN FUSELAGE STATION 1474 JUST LEFT OF AFT AIRSTAIRS. REPAIRED IAW SRM 53-01-00-001 AND AARD 53-30-00-4. OPERATIONAL CHECK GOOD.SDR AALA20170113009Cable · detachedL2 DOOR EMERGENCY EVACUATION SLIDE CABLE IS DETACHED. REMOVED AND REPLACED SLIDE IAW AMM 25-94-17. OPERATIONAL CHECKED GOOD. AIRCRAFT WAS GROUNDED.SDR AALA20170106020Slide · detachedAIRCRAFT NOT GROUNDED. R1 EMERGENCY EVACUATION SLIDE PACK IS DETACHED. REINSTALLED SLIDE PACK IAW AMM 25-62-00. OPERATIONAL CHECK GOOD.SDR AALA20161205012Battery · dischargedAIRCRAFT NOT GROUNDED. CEILING EMERGENCY EXIT LIGHTS AT ROWS 27 THROUGH 30 ARE INOPERATIVE. REMOVED AND REPLACED BATTERY ASSEMBLY B5-107 IAW AMM 33-53-00. OPERATIONAL CHECK GOOD.SDR AALA20161205011Battery · dischargedAIRCRAFT NOT GROUNDED. CEILING EMERGENCY EXIT LIGHTS AT ROWS 18 THROUGH 21 ARE INOPERATIVE. REMOVED AND REPLACED BATTERY ASSEMBLY B5-104 IAW AMM 33-53-00. OPERATIONAL CHECK GOOD.SDR AALA20161205013Battery · dischargedAIRCRAFT GROUNDED. FIRST CLASS CEILING EMERGENCY EXIT LIGHTS AT ROWS 3 THROUGH 6 STAY ON AFTER POWER DOWN SWITCH WAS IN OFF POSITION. REMOVED AND REPLACED BATTERY ASSEMBLY B5-100 IAW AMM 33-53-00. OPERATIONAL CHECK GOOD.SDR AALA20161129009Lanyard · detachedAIRCRAFT NOT GROUNDED. R1 DOOR EVACUATION SLIDE GIRT BAR LANYARD IS DETACHED. SECURED LANYARD AS REQUIRED. OPERATIONAL CHECK GOOD.SDR AALA20161115018Lanyard · looseAIRCRAFT NOT GROUNDED. R1 DOOR EMERGENCY EVACUATION SLIDE LANYARD LOOSE. REINSTALLED SLIDE LANYARD IAW AMM 25-62-00. OPERATIONAL CHECK GOOD.SDR AALA20160627004Battery · dischargedAIRCRAFT WAS NOT GROUNDED. EMERGENCY LIGHTS IN FORWARD ENTRANCE AREA ARE INOPERATIVE. R & R THE FORWARD EMERGENCY BATTERY ASSY IAW AMM 33-53-00. OPS CHECK GOOD.SDR AALA20160627003Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED. AFT EMERGENCY ESCAPE PATH LIGHTING IS INOPERATIVE. EMERGENCY PATH MARKING SYS FAILS DUAL FEED TEST IN AFT PORTION OF CABIN. R & R POWER SUPPLY AND BATTERY PACK AT FUSELAGE STA 1260 IAW AMM 33-60-98. OPS CHECK GOOD, ALSO, AALA2016SDR AALA20160627002Power Supply · inoperativeAIRCRAFT WAS NOT GROUNDED. AFT EMERGENCY ESCAPE PATH LIGHTING IS INOPERATIVE. EMERGENCY PATH MARKING SYS FAILS DUAL FEED TEST IN AFT PORTION OF CABIN. R & R POWER SUPPLY AND BATTERY PACK AT FUSELAGE STA 1260 IAW AMM 33-60-98. OPS CHECK GOOD. ALSO AALA2016SDR AALA201704079016Pump · inoperativeDURING CLIMB, THE CENTER TANK AFT BOOST PUMP BECAME INOPERATIVE. EMERGENCY WAS DECLARED. LANDING UNEVENTFUL. REMOVED AND REPLACED THE CENTER TANK FORWARD FUEL BOOST PUMP AND AFT FUEL BOOST PUMP IAW AMM 28-20-07-201. OPERATIONAL CHECKED GOOD.SDR AALA20160516014Pump · inoperativeDURING CLIMB THE CTR TANK AFT BOOST PUMP BECAME INOPERATIVE. EMERGENCY WAS DECLARED, LANDING UNEVENTFUL. REMOVED AND REPLACED THE CENTER TANK FORWARD FUEL BOOST PUMP AND AFT FUEL BOOST PUMP IAW AMM 28-20-07-201. OPERATIONAL CHECKED GOOD.SDR AALA20160423003Battery · dischargedAIRCRAFT WAS NOT GNDED. OVERHEAD EMER LIGHT IN FIRST CLASS ARE INOPERATIVE. R & R EMER BATTERY ASSEMBLY IAW AMM 33-53-00.
Back to N9621A, cancelled Mar 2, 2020