N824AS, cancelled Nov 13, 2017
Service difficulty reports · 226
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 = 'N824AS' AND deregistration_id = 'N824AS-2017-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 = 'N824AS' AND deregistration_id = 'N824AS-2017-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 TRAX200701750Door · stuckF/A AND GROUND PERSONNEL HAD DIFFICULTY OPENING BOARDING DOOR.SDR TRAX200701458Door · stiffFLIGHT ATTENDANT REPORTS, PAX DOOR DIFFICULT OPEN FROM INSIDE.SDR TRAX200701457Door · stickingPAX DOOR DIFFICULT TO OPEN FROM INSIDE.SDR TRAX200701244Door · bindingMAIN CABIN DOOR WILL NOT OPEN. FLT 4728 DEL 70 MINS.SDR TRAX200701189Door · bindingMAIN PASSENGER DOOR IS VERY HARD TO OPEN. T-HANDLE FEELS LIKE IT POPS OUT BUT THE HANDLE CANNOT BE TURNED FROM OUTSIDE OR THE LEVER HANDLE RAISED INSIDE THE AIRCRAFT.SDR TRAX200701144Handle · bindingF/A REPORTS PAX DOOR DIFFICULT TO OPEN. HANDLE FEELS AS IF IT'S BINDING TOWARDS TOP OF TRAVEL LIMIT.SDR TRAX200700987Door · bindingAIRSTAIR DOOR VERY HARD TO OPEN.SDR TRAX200700832Unknown · bindingF/A REPORTS, PAX DOOR IS HARD TO OPEN.SDR TRAX200700805Door · stiffFA REPORTS CABIN ENTRANCE DOOR DIFFICULT TO OPEN.SDR TRAX200700546Flap System · failedFLAPS FAIL AT ZERO OUT OF 20,000 FT, WITHOUT TOUCHING FLAPS AT ALL. LANDING IN SBN NO PROBLEM, VERY SOFT LANDING. EMERGENCY EQUIPMENT ON STANDBY AS A PRECAUTION.SDR TRAX200700545Flap System · warning lightLEVEL AT 3,000' IN PATTERN AT MDT AT 200 KNOTS, RECEIVED FLAPS FAIL MSG AT 0 DEG, FOLLOWED QRH AND LANDED IN MDT. "FLAP HANDLE WAS NOT MOVED OUT OF 0 DEG OR TOUCHED". EMERGENCY EQUIPMENT ON STANDBY AS A PRECAUTION.SDR TRAX200700450Flap · failedFLAPS FAIL AT ZERO. EMERGENCY DECLARED.SDR TRAX200700449Flap · failedA -FLAPS FAIL- MSG ON APPR, A/S 155 KTS. LEFT FLAP INDICATED 39 DEG, RIGHT FLAPS INDICATED 38 DEG. EMERGENCY DECLARED.SDR TRAX200700123Flap · malfunctionedFLAPS FAILED MSG FLAPS FAILED AT 0 WHEN FLAPS SELECT TO 8, LANDED WITH ZERO FLAPS. AS A PRECAUTION EMERGENCY EQUIP ON STANDBY.SDR TRAX200700112Flap · failedON APPROACH IN ROC, SELECTED FLAPS 8 AND FLAPS FAIL CAUTION MSG, FLAPS FAILED AT ZERO. C/W QRH AND DECLARED EMERGENCY, TOUCH DOWN SPEED AT BUF WAS 172 KNOTS, DIVERTED TO BUF. FLT 4249 CX ON 1/20/07.SDR TRAX200700111Flap · malfunctionedFLAP FAIL ON ARRIVAL. EMERGENCY DECLARED.SDR TRAX200700013Trim System · disconnectedSTAB/MACH TRIM DISCONNECTED ON APPROACH. EMERGENCY DECLARED. FLT 4873 DEL 37 MINS.SDR TRAX200600740Apu · odorDURING DESCENT WITH APU OPERATING THE APU DOOR WENT TO INHIBIT CLOSED. THEN THERE WAS A SPIKE IN EGT WELL INTO THE RED WITH A STRONG BURNING SMELL.SDR TRAX200600737Step · brokenLOWER AIRSTAIR STEP BROKEN.SDR TRAX200600565Door · malfunctionedFA REPORTS MAIN CABIN DOOR IS DIFFICULT TO OPEN.SDR TRAX200600416Light · inoperativeEMERGENCY LIGHTS NOT WORKING AT PANEL JUST FWD OF SERVICE DOOR, AT LOWER F/A STATION, AND FWD FLOOR STRIP IN CABIN.SDR TRAX200600329Floor Support · corrodedCORROSION ON LT FLOOR LANDING AT FS 559+16 (MARKED)SDR TRAX200600316Plate · corrodedPAX DOOR AFT CABLE ANCHOR FITTING BASE PLATE CORRODED (MARKED). REMOVED AND REPLACED AFT ASD ANCHOR FITTING BASE PLATE IAW M/M 53. (CLOSED)SDR TRAX200600326Bracket · crackedINTERCOSTAL AFT BRACKET CRACKED AT FS 484.00 AND LBL36 REMOVED AND REPLACE FS 484 LBL36 OTBD CLIP ALL WORK PER CRJ200, SRM51-42-12 JOB COMPLETED RI17912 (CLOSED)SDR TRAX200600324Floorbeam · crackedFLOORBEAM SUPORT BRACKET IB OF RBL 9 CRACKED AT FS 461. REMOVED SUPPORT FITTING AT OTBD. SIDE OF RBL 9.0 AT STA. 461, DRILLED UP NEW FITTING AND STARTED INSTALLING FASTNERS, REMOVED ACCESS PANEL THRU PRESS. FLOOR FOR ACCESS OF AFT END HORZ. FASTNERS REF. SRSDR TRAX200600322Structure · corrodedCORROSION AROUND CAMLOCK RECPTACLES IN FLT COMPT FS 260 JUST AFT AND BELOW CENTER PEDESTAL. BLENDED CORROSION FOUND IN FLT COMP FS 260 BELOW CENTER PEDESTAL. FOUND WITHIN LIMITS NEEDS ALODINE PRIME AND PAINT. CORROSION BLENDED IAW CRJ 200 SRM 51-21-06 DK 702SDR TRAX200600325Structure · corrodedCORROSION FOUND BETWEEN AT FS409+128 TO FS 559.00 AND LBL36 AND TO FLOOR STR.17L ( FLOOR WEATHER STRIPPING IS REQUIRED TO BE REMOVED AND CLEANED AREA TO INSPECT FURTHER POSSIBLE CORRODED AREAS)SDR TRAX200600323Frame · crackedFS 280 FRAME CRACKED AT LBL 11.0 AROUND ALT EXTENSION CABLE PULLEY BRACKET (MARKED).SDR TRAX200600321Structure · corrodedCORROSION AROUND CAMLOCK RECEPTACLES AT FS 280 BETWEEN LBL 9 AND RBL 9 (MARKED). DRILLED OUT FASTENERS AND REMOVED CORRODED ANGE AT FS280,PICKED UP EXISTING FASTENER HOLES IN NEW ANGLE, ALODINED AND INSTALLED ANGEL WET WITH SEALANT AND SOLID RIVETS PER THE CRSDR TRAX200600320Clip · crackedFS 280 CLIP CRACKED AT RBL 9.0 (INBD) (MARKED) REMOVED AND REPLACED CRACKED CLIP AT FS280 RBL 9.0 INBOARD IAW SRM 51-40-11. (CLOSED)SDR TRAX200600319Clip · crackedFS 280 CLIP CRACKED AT LBL 9.0 (IB) (MARKED). REMOVED AND REPLACED CLIP AT FS280 LBL 9.0 IAW SRM51-40-11. (CLOSED)SDR TRAX200600318Floor Support · corrodedRT SIDE PRESSURE FLOOR LANDING HAS CORROSION FROM FS 439 TO FS 544 (MARKED)SDR TRAX200600317Sill · corrodedCARGO FLOOR PANEL AT FS 559+64 TO 621.00 CORROSION ON SILL STR 17R AROUND NUT PLATES NUT PLATE HOLES. REMOVED CORROSION AROUND NUTPLATES PER CRJ 200 SRM 51-21-06 BAT 23167 C/W REO 601R-53-00-167. REMOVED CORROSION AROUND NUTPLATES PER CRJ 200 SRM 51-2SDR TRAX200600106Placard · peelingPAX DOOR EXIT PLACARD PEELING.SDR ASO2006F00005Power Supply · malfunctionedDURING GROUND INSPECTIONS, THE AIRCRAFT`S EMERGENCY LIGHTS REMAINED ON WITH THE SWITCH IN THE OFF POSITION. MAINTENANCE REMOVED AND REPLACED THE BATTERY INVERTER AND THE BATTERY CHARGER. OPERATIONAL CHECKS GOOD. AIRCRAFT OK FOR SERVICE. (K)SDR ASO2006F00004Charger · malfunctionedDURING GROUND INSPECTION, THE AIRCRAFT’S EMERGENCY LIGHTS REMAINED ON WITH THE SWITCH IN THE OFF POSITION. MAINTENANCE REMOVED AND REPLACED THE BATTERY INVERTER AND THE BATTERY CHARGER. OPERATIONAL CHECKS GOOD. AIRCRAFT OK FOR SERVICE. (K)SDR ASOA06245Inverter · malfunctionedDURING GROUND INSPECTIONS, THE AIRCRAFT`S EMERGENCY LIGHTS REMAINED ON WITH THE SWITCH IN THE OFF POSITION. MAINTENANCE REMOVED AND REPLACED THE BATTERY INVERTER AND THE BATTERY CHARGER. OPERTIONAL CHECKS GOOD. AIRCRAFT OK FOR SERVICE. (K)SDR ASOA05469Step · brokenDURNG A GROUND INSPECTION, THE PASSENGER DOOR BOTTOM STEP RETRACTING HINGE LINKAGE WAS FOUND BROKEN. MAINTENANCE REMOVED AND REPLACED THE BOTTOM STEP ON THE PASSENGER DOOR. OPS CHECK GOOD. AIRCRAFT OK FOR SERVICE. (K)SDR ASOA05329Door · malfunctionedDURING A GROUND INSPECTION, THE FLIGHT ATTENDANT REPORTED THE PASSENGER DOOR STIFF TO OPEN AND CLOSE. MAINT OPERATED THE PASSENGER DOOR WITH NO DEFECTS NOTED. AIRCRAFT OK FOR SERVICE. (K)SDR ASOA05273Cable · unsecureFLT 4610 - DURING A GROUND INSPECTION IN ATL, THE PASSENGER DOOR WAS FOUND DIFFICULT TO OPEN. MAINTENANCE FOUND THE PASSENGER DOOR HANDRAIL PIN CABLE UNSECURED CAUSING IT TO STICK BETWEEN THE PASSENGER DOOR AND AIRFRAME. MAINTENANCE RESECURED THE PASSENGER DSDR ASOA05210Doubler · crackedDURING AN A-CHECK IN BTR, THE FS 640 DOUBLER AT STRINGER 10, FRAME FS 640 AND THE SKIN BUTT JOINT STRAP LEFT FS 640, STRINGER 8-13 WERE FOUND TO BE CRACKED BEYOND LIMITS. MAINTENANCE IS REMOVING AND REPLACING THE FS 640 DOUBLER AT STRINGER 10 AND THE FS 640 FSDR ASOA05109Battery Pack · dischargedFLT 4842 - DURING A GROUND INSPECTION IN ATL, THE FORWARD EMERGENCY LIGHTS WERE FOUND ILLUMINATING WITH THE EMERGENCY LIGHTS SWITCH IN THE OFF POSITION. MAINTENANCE REMOVED AND REPLACED THE NR 1 EMERGENCY LIGHTS BATTERY PACK. OPERATIONAL CHECKS GOOD. AIRCRASDR ASOA05101Light · malfunctionedFLT 4158 - AFTER POWERING DOWN THE AIRCRAFT IN ATL, THE CREW REPORTED THAT THE EMERGENCY LIGHT REMAINED ON. THE CREW RESET THE CIRCUIT BREAKER TO THE EMERGENCY LIGHTS AND THE LIGHTS EXTINGUISHED. OPERATIONAL CHECKS GOOD. AIRCRAFT OK FOR SERVICE. (M)SDR ASOA04908Scavenge Pump · cokedDURING CLIMB-OUT, AT APPROXIMATELY 31,800 FT, THE CREW RECEIVED AN ENGINE OIL PRESSURE MASTER WARNING AND AURAL. THE QRH WAS COMPLIED WITH AND THE CREW SHUTDOWN THE LT ENGINE. AN EMERGENCY WAS DECLARED AND THE AIRCRAFT DIVERTED, LANDING SAFELY. MAINTENANCE SDR ASOA04836Doubler · crackedDURING A C-CHECK, THE RT DOUBLER AT FS 640 WAS FOUND TO BE CRACKED BEYOND LIMITS. MAINTENANCE IS REMOVING AND REPLACING THE RT DOUBLER AT FS 640.SDR ASOA04834Stringer Clip · crackedDURING A C-CHECK, THE OB CLIPS AT FS 625, STRINGER 15R WAS FOUND TO BE CRACKED BEYOND LIMITS. MAINTENANCE IS REMOVING AND REPLACING THE OB CLIP AT FS 625, STRINGER 15R IAW SRM 51-42-00.SDR ASOA04827Clip · crackedDURING A C-CHECK, THE IB AND OB CLIPS AT FS 484, RBL 27 AND RBL 36 WERE FOUND TO BE CRACKED BEYOND LIMITS. MAINTENANCE IS REMOVING AND REPLACING THE IB CLIP AT FS 484, RBL 27 AND REPAIRING THE OB CLIP AT FS 484, RBL 36 IAW EO600-53-0098.SDR ASOA04826Clip · crackedDURING A C-CHECK, THE IB AND OB CLIPS AT FS 484, LBL 27 AND LBL 36 WERE FOUND TO BE CRACKED BEYOND LIMITS. MAINTENANCE IS REMOVING AND REPLACING THE IB CLIP AT FS 484, LBL 36 IAW EO 600-53-0098.SDR ASOA04812Floor Support · crackedDURING C-CHECK, THE LT AND RT FLOOR SUPPORT ANGLES AT FS 621 WERE FOUND TO BE CRACKED BEYOND LIMITS. MAINTENANCE IS REPAIRING THE LT AND RT FLOOR SUPPORT ANGLES AT FS 621 IAW EO600-53-0105.SDR ASOA04841Sign · crackedDURING A C-CHECK, THE ENTRY WAY EMERGENCY EXIT LIGHT, JUST FORWARD OF THE PASSENGER DOOR, WAS FOUND TO HAVE THE COVERED CRACKED. MAINTENANCE REMOVED AND REPLACED THE CRACKED EMERGENCY EXIT LIGHT ASSEMBLY. OPERATIONAL CHECKS GOOD.
Back to N824AS, cancelled Nov 13, 2017