N838AS
Service difficulty reports not matched to an aircraft · 173
They name N838AS, but no registry record covers the date, the aircraft registered then was built later, or the report describes another aircraft. 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 = 'N838AS' AND registry_match IS NULL 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 = 'N838AS' AND registry_match IS NULL 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 ASOA05838Skin · crackedDURING AN A-CHECK IN BTR, THE RIGHT FS 640, AT STRINGER 9 WAS FOUND TO BE CRACKED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE RIGHT FS 640, AT STRINGER 9. OPERATIONAL CHECKS GOOD. (M)SDR ASOA05819Doubler · crackedDURING AN A-CHECK IN BTR, THE RIGHT FS 640 BONDED SKIN DOUBLER, AT STRINGER 8-13, WAS FOUND TO BE CRACKED BEYOND LIMITS. MAINTENANCE WILL REPAIR THE RIGHT FS 640 BONDED SKIN DOUBLER, AT STRINGER 8-13, IAW ASA EO 600-53-0107. (M)SDR ASOA05810Frame · crackedDURING AN A-CHECK IN BTR, THE RIGHT SIDE 640 FRAME DOUBLER WAS FOUND TO POSSIBLY BE CRACKED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE RIGHT SIDE FS 640 FRAME DOUBLER IAW CRJ200 SRM 51-40-00. (M)SDR ASOA05529Light · inoperativeFLT 4906 - DURING AN OVERNIGHT MAINTENANCE VISIT TO CAE, THE FLOOR LEVEL EMERGENCY LIGHT BY THE PASSENGER DOOR WAS INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE INOPERATIVE EMERGENCY LIGHT ASSEMBLY. OPERATIONAL CHECKS GOOD. AIRCRAFT OK FOR SERVICE. (M)SDR ASOA05499Relay · shortedDURING A GROUND INSPECTION, AN AC ESS BUSS FAULT MESSAGE WAS RECEIVED AND THE EMERGENCY LIGHTS REMAINED ON. MAINTENANCE REMOVED AND REPLACED THE AC ESS TRANSFER RELAY. OPERATIONAL CHECKS GOOD AIRCRAFT OK FOR SERVICE. (K)SDR ASOA05541Light · inoperativeDURING HANGAR MAINTENANCE IN MCN, THE EMERGENCY FLOOR LIGHT STRIP WAS FOUND TO BE DAMAGED IN SEVERAL PLACES. MAINTENANCE REMOVED AND REPLACED THE EMERGENCY FLOOR LIGHT STRIP. OPERATIONAL CHECKS GOOD. AIRCRAFT OK FOR SERVICE. (M)SDR ASOA05438Light · brokenDURING HANGAR MAINTENANCE IN BTR, THE EMERGENCY FLOOR TRACK LIGHTING AT ROW 5 WAS FOUND TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED A BROKEN EMERGENCY FLOOR LIGHT STRIP AT ROW 5. OPERATIONAL CHECK GOOD. AIRCRAFT OK FOR SERVICE. (M)SDR ASOA05158Step · brokenFLT 4533 - DURING A GROUND INSPECTION IN ATL, THE BOTTOM STEP ON THE PASSENGER DOOR WAS FOUND BROKEN AT THE FOLDING ROD CONNECTION POINT. MAINTENANCE REMOVED AND REPLACED THE BOTTOM STEP ON THE PASSENGER DOOR. OPERATIONAL CHECKS GOOD. AIRCRAFT OK FOR SERVICSDR ASOA05133Step · crackedDURING HANGAR MAINTENANCE IN MCN, THE LOWER STEP ON THE PASSENGER DOOR WAS FOUND CRACKED AT THE STAY ROD ATTACHMENT. MAINTENANCE REMOVED AND REPLACED THE LOWER STEP ON THE PASSENGER DOOR. (M)SDR ASOA04960Step · crackedDURING AN A-CHECK IN MCN, THE BOTTOM STEP ON THE PASSENGER DOOR WAS FOUND CRACKED. MAINTENANCE REMOVED AND REPLACED THE BOTTOM STEP ON THE PASSENGER DOOR. (M)SDR ASOA04378Battery Pack · dischargedDURING A C-CHECK, THE FORWARD EMERGENCY FLOOR LIGHT TRACK WAS FOUND TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE NR1 EMERGENCY BATTERY PACK AND THE FORWARD EMERGENCY FLOOR LIGHT STRIP. OPERATIONAL CHECKS GOOD.SDR ASOA04379Battery Pack · dischargedDURING A C-CHECK, THE FORWARD EMERGENCY FLOOR LIGHT TRACK WAS FOUND TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE NR 1 EMERGENCY BATTERY PACK AND THE FORWARD EMERGENCY FLOOR LIGHT STRIP. OPERATIONAL CHECKS GOOD.SDR ASOA04374Step · crackedDURING C-CHECK, THE PASSENGER DOOR TOP STEP WAS FOUND TO BE CRACKED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE PASSENGER DOOR TOP STEP.SDR ASOA04350Floor Support · crackedDURING C-CHECK INSPECTION, THE LT AND RT SIDE FLOOR SUPPORT ANGLES AT FS 621 WERE FOUND CRACKED. MAINTENANCE REPAIRED THE CRACKED FLOOR SUPPORT ANGLES IAW REO 601R5361117.SDR ASOA04349Clip · crackedDURING C-CHECK INSPECTION, THE CLIPS AT FS 280 WERE FOUND CRACKED ON BOTH IB AND OB SIDES OF RBL AND LBL 9. MAINTENANCE REMOVE AND REPLACED CRACKED CLIPS IAW SRM 5100.SDR ASOA04348Rib · crackedDURING C-CHECK INSPECTION, THE RT MLG BATT RIB WAS FOUND CRACKED. MAINTENANCE REPAIRED THE CRACKED MLG BATT RIB IAW EO 600570039A AND 600570042.SDR ASOA04351Sill · corrodedDURING C-CHECK INSPECTION, THE CARGO COMPARTMENT SILL PLATE BETWEEN FS 562.72 AND FS 589.00 WAS FOUND TO HAVE CORROSION IN SEVERAL AREAS, AND WAS ALSO CRACKED. MAINTENANCE IS REPAIRING THE SILL PLATE IN THE CARGO COMPARTMENT IAW REO 601R5361690 AND EO 6005300SDR ASOA04103Pseu · malfunctionedFLT 4736 - DURING CLIMB-OUT FROM ICT-ATL, THE CREW RECEIVED A PASSENGER DOOR LATCH CAUTION MESSAGE. QRH PROCEDURES WERE COMPLIED WITH. THE FLIGHT ATTENDANT VERIFIED SECURITY OF THE DOOR AND DETERMINED IT WAS CORRECTLY CLOSE. PRESSURIZATION BEING NORMAL, THESDR ASOA03493Fitting · crackedDURING A HANGAR INSPECTION IN MCN, THE FORWARD PASSENGER DOOR CABLE ANCHOR FITTING WAS FOUND TO BE CRACKED. MAINTENANCE WILL MONITOR CRACK AND REPLACE DOOR CABLE ANCHOR FITTING WITHIN 100 FLIGHT HOURS PER REO 601R-52-11-416. MAINTENANCE REMOVED AND REPLACED SDR ASOA02379Light · inoperativeDURING A SCHEDULED INSPECTION IN XNA, THE AFT OVERHEAD CABIN EMERGENCY LIGHT WAS INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE BURNED OUT EMERGENCY LIGHT BULB. OPERATIONAL CHECKS GOOD. AIRCRAFT OK FOR SERVICE. (M)SDR ASOA00002Pump · leakingFLT 4773 - EN ROUTE TO SAT, HYDRAULIC LOW PRESSURE MESSAGE ILLUMINATED ON EICAS. IAW QRH AND COMPANY PROCEDURES, CREW SAFELY LANDED AT NEAREST AIRPORT, HOU. MAINTENANCE REPLACED THE ENGINE DRIVEN PUMP. OPERATIONAL CHECKS WERE GOOD. AIRCRAFT RETURNED TO SERSDR ASOA99080Battery Pack · dischargedDURING INSPECTION, NR 2 EMERGENCY LIGHTING SYSTEM BATTERY PACK FOUND INOPERATIVE. MAINTENANCE REPLACED THE NR 2 EMERGENCY LIGHTING SYSTEM BATTERY PACK. OPERATIONAL CHECKS WERE GOOD. AIRCRAFT RETURNED TO SERVICE. (M)SDR 99ZZZX3702Battery Pack · dischargedDURING INSPECTION, NR 1 EMERGENCY LIGHTING SYSTEM BATTERY PACK FOUND INOPERATIVE. MAINTENANCE REPLACED THE NR 1 EMERGENCY LIGHTING SYSTEM BATTERY PACK. OPERATIONAL CHECK WERE GOOD. AIRCRAFT RETURNED TO SERVICE. (X)
Back to N838AS