N823AS, cancelled Nov 13, 2017
Service difficulty reports · 217
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 = 'N823AS' AND deregistration_id = 'N823AS-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 = 'N823AS' AND deregistration_id = 'N823AS-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 ASOA04225Support Beam · crackedDURING AN A-CHECK IN MCN, THE CENTER ENGINE SUPPORT BEAM AT BL 0 ON THE TOP SKIN AT THE FIRE LOOP ATTACH BRACKET WAS FOUND CRACKED BEYOND LIMITS. MAINTENANCE IS REPAIRING THE CENTER ENGINE SUPPORT BEAM AT BL 0 ON THE TOP SKIN AT THE FIRE LOOP ATTACH BRACKET ISDR ASOA03655Tube · crackedDURING CRUISE FROM ATL-YUL, AT APPROXIMATELY 29,000 FT THE CREW RECEIVED A HYDRAULIC NR 1 LOW PRESSURE AMBER CAUTION MESSAGE, WITH A PRESSURE DROP FROM 1500 PSI TO ZERO AND A QUANTITY READING OF ZERO. THE CREW COMPLIED WITH QRH PROCEDURES AND THE AIRCRAFT DIVSDR ASOA03555Lamp · burned outDURING A GROUND INSPECTION IN DFW, THE EMERGENCY EXIT LIGHT AT THE SERVICE DOOR WAS FOUND TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE EMERGENCY EXIT LIGHT LAMP AT THE SERVICE DOOR. OPS CHECKS GOOD. AIRCRAFT OK FOR SERVICE. (M)SDR ASOA03270Skin · crackedDURING HANGAR MAINTENANCE IN CKB, THE FUSELAGE SKIN AT FS 235 ON THE RIGHT SIDE OF THE AFT NOSE GEAR CUT OUT WAS FOUND TO BE CRACKED BEYOND LIMITS. MAINTENANCE REPAIRED THE FUSELAGE SKIN AT FS 235 ON THE RIGHT SIDE OF THE AFT NOSE GEAR DOOR CUTOUT IAW ASA EO SDR ASOA03257Floorbeam · crackedDURING HANGAR MAINTENANCE IN CKB, THE LT AND RT FLOORBEAM ANGLE AT FS 621, WL 73, RBL AND LBL 39 WAS FOUND TO BE CRACKED BEYOND LIMITS. MAINTENANCE REPAIRED THE LT AND RT FLOORBEAM ANGLE AT FS 621, WL 73, RBL AND LBL 39 IAW ASA EO 600-53-0105. (M)SDR ASOA03262Striker · dentedDURING HANGAR MAINTENANCE IN CKB, THE PASSENGER DOOR SEAL STRIKER AT FS 310 AND FS 349 BETWEEN STRINGERS 15L AND 16L WAS FOUND TO BE DENTED BEYOND LIMITS. MAINTENANCE REPAIRED THE PASSENGER DOOR SEAL STRIKER AT FS 310 AND FS 349 BETWEEN STRINGERS 15L AND 16L SDR ASOA03261Skin · dentedDURING HANGAR MAINTENANCE IN CKB, THE FUSELAGE SKIN AT FS 310 BETWEEN STRINGER 15L AND 16L WAS FOUND TO BE DENTED BEYOND LIMITS. MAINTENANCE REPAIRED THE FUSELAGE SKIN AT FS 310 BETWEEN STRINGERS 15L AND 16L IAW REO 601R-52-11-008 REV B REPAIR A. (M)SDR ASOA03269Intercostal · crackedDURING HANGAR MAINTENANCE IN CKB, THE FLOOR SUPPORT INTERCOSTAL AT THE ATTACH FLANGE, FS 484 AT RBL AND LBL 36, AND THE ANGLE AT LBL 27, WL 73 WERE FOUND TO BE CRACKED BEYOND LIMITS. MAINTENANCE REPAIRED THE FLOOR SUPPORT INTERCOSTALS AT THE ATTCH FLANGE, FS SDR ASOA03273Skin · dentedDURING HANGAR MAINTENANCE IN CKB, THE FUSELAGE SKIN AT FS 310 BETWEEN STRINGERS 16L AND 17L WAS FOUND TO BE DENTED BEYOND LIMITS. MAINTENANCE REPAIRED THE FUSELAGE SKIN AT FS 310 BETWEEN STRINGERS 16L TO 17L IAW ASA EO 600-53-0097. (M)SDR ASOA03122Lamp · burned outFLT NR 4414 - DURING A GROUND INSPECTION AT MGM, THE EMERGENCY CEILING LIGHT AT ROW 4 WAS FOUND TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE EMERGENCY CEILING LIGHT LAMP T ROW 4. OPERATIONAL CHECKS GOOD. AIRCRAFT OK FOR SERVICE. (M)SDR ASOA02612Light · inoperativeDURING HANGAR INSPECTION IN BTR, THE AFT OVERHEAD EMERGENCY LIGHT IN THE CABIN WAS FOUND TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE AFT OVERHEAD EMERGENCY LIGHT LAMP. OPERATIONAL CHECKS GOOD. AIRCRAFT OK FOR SERVICE. (M)SDR ASOA02336Lamp · burned outDURING GROUND INSPECTION, THE LEFT HAND SIDE OF THE CENTER EMERGENCY LIGHTED EXIT SIGN WAS INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE BURNED OUT EMERGENCY LIGHT BULB. OPERATIONAL CHECKS GOOD. AIRCRAFT OK FOR SERVICE.SDR ASOA01290Light · inoperativeFLT 4787 - DURING SCHEDULED INSPECTION IN XNA, THE MIDDLE INTERIOR CEILING EMERGENCY LIGHT WAS INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE BURNED OUT MIDDLE CEILING EMERGENCY LIGHT BULB. OPERATIONAL CHECKS GOOD. AIRCRAFT OK FOR SERVICE. (M)SDR ASOA01178Hydraulic Line · crackedFLT 4757 - DURING CRUISE FLIGHT FROM ATL TO DSM, CAPTAIN RECEIVED A HYDRAULIC 1 LOW PRESSURE CAUTION MESSAGE. AFTER COMPLYING WITH ABNORMAL PROCEDURES CAPTAIN DETERMINED A LOSS OF HYDRAULIC FLUID. AN EMERGENCY WAS DECLARED AND AIRCRAFT LANDED UNEVENTFULLY INSDR ASOA00135Light · inoperativeDURING INSPECTION CREW FOUND RT FORWARD EXTERIOR EMERGENCY LIGHTS, INOPERATIVE. MAINTENANCE REMOVED AND REPLACED EXTERIOR EMERGENCY LIGHT BULB. OP CHECKS, GOOD. AC RETURNED TO SERVICE.SDR ASOA00043SCircuit Board · inoperativeFLT 4511 - DURING CRUISE AT FL 260 AN AP PITCH TRIM MESSAGE APPEARED AND WENT OUT BY ITSELF. UPON DESCENT TO FL 240 CREW RECEIVED AN AP PITCH TRIM AND STAB CHANNEL 1 MESSAGE. AFTER FOLLOWING QRH PROCEDURES, THE PROBLEM APPEARED SOLVED. UPON SECOND DESCENT, SDR ASOA00043Warning System · activatedFLT 4511 - DURING CRUISE AT FL 260, AN APU PITCH TRIM MESSAGE APPEARED AND WENT OUT BY ITSELF. UPON DESCENT TO FL 240, CREW RECEIVED AN 'APU PITCH TRIM' AND 'STAB CHANNEL 1' MESSAGE. AFTER FOLLOWING QRH PROCEDURES, THE PROBLEM APPEARED SOLVED. UPON SECOND D
Back to N823AS, cancelled Nov 13, 2017