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 ASOA200901096Floor Support · corrodedLBL 27.0 FLOOR SUPPORT OTBD SIDE HAS CORROSION AROUND FASTENER HOLES, FS 574.0 TO FS 621.0. REMOVED UPPER FLOOR SUPPORT CAP AT LBL 27.0 FROM FS 559+112 TO FS 621 IAW SRM 51-42-06. INSTALLED SERVICEABLE FLOOR SUPPORT CAP AT LBL 27 FROM 574 TO 621 IAW REO 601RSDR ASOA200901095Bulkhead · crackedFOUND FS 559 BULKHEAD WEB HAS 2 INDICATIONS NOTED: 1) RT WEB I/B OF RBL 18, WL 59.10 INDICATION NOTED APPROX. .5" IN LENGTH, 100% FSH, 2) RT WEB O/B OF RBL 9, WL 54.10 APPROX. .2" IN LENGTH, 50% FSH, AND FOUND FS 559 LT CAP ANGLE HAS INDICATION NOTED APPROX. .SDR ASOA200901088Support Angle · crackedRT WING TO FUSELAGE ACCESS FAIRING SUPPORT ANGLE CRACKED AT FS 461.50. REMOVED AND REPLACED RT WING TO FUSE ACCESS FAIRING SUPPORT ANGLE AT FS 461.50 IAW SRM 51-42-06. SELF CONTOURING SEALING PAD ON ANGLE AT 461.50. APPLIED SELF CONTOURING SEALING PAD TO RSDR ASOA200901087Support Angle · crackedRT WING TO FUSELAGE ACCESS FAIRING SUPPORT ANGLE CRACKED AT FS 449.85. REMOVED AND REPLACED RT WING TO FUSE ACCESS FAIRING SUPPORT ANGLE AT FS 449.85 IAW SRM 51-42-06. SELF CONTOURING SEALING PAD ON ANGLE AT 449.85. APPLIED SELF CONTOURING SEALING PAD TO RSDR ASOA200900936Warning Message · activatedCARGO BTL LO ON CLIMBOUT OF ATL. EMERGENCY DECLARED -- AIRCRAFT RETURNED TO AFTER T/O.SDR ASOA200900756Hydraulic System · malfunctionedHYD SYSTEM 2 LOW PRESSURE IN FLIGHT. EMERGENCY DECLARED, EQUIPMENT WAS STANDING BY.SDR ASOA200900624Warning System · activatedUPON TAKEOFF, RECEIVED A "NOSE DOOR OPEN" MSG. WRH ADVISED RETURN TO AIRPORT. FLT 5399 DEL 67 MINS. NC/08C EMERGENCY DECLARED.SDR ASOA200801606Angle · crackedREPAIR ANGLE AT FS 484, RBL 27 CRACKED.SDR TRAX200800770Step · crackedASD LOWER STEP CRACKED. REMOVED AND REPLACED ASD LOWER STEP IAW AMM 52-11-00. OPS CHECKED GOOD. REMOVED AND REPLACED ASD LOWER STEP IAW AMM 52-11-00. OPS CHECKED GOOD. (B)SDR TRAX200800631Door · out of adjustASD HARD TO CLOSE, ADJUSTED PAX DOOR COUNTERBALANCE SYSTEM IAW MM 52-11-17. OK FOR SERVICE. (B)SDR TRAX200800486Door · bindsVERBALLY REPORTED BY FELLOW MTC CONTROLLER MERRICK REPORTED BY STATION PERSONNEL THAT ASD DIFFICULT TO OPERATE.SDR TRAX200701928Door · stuckPASSENGER DOOR WILL NOT OPEN OR CLOSE.SDR TRAX200701697Flap System · failedFLAP FAIL DURING APPROACH AT ZERO. TOWER DECLARED EMERGENCY. EMERGENCY EQUIPMENT ON STANDBY. FLT 4877 CX.SDR TRAX200701448Placard · missingAAR - CREW ESCAPE HATCH PLACARDS MISSING (X 4).SDR TRAX200701405Placard · damagedEMERGENCY EXIT AND CLOSED PLACARD ON SERVICE DOOR UNLEDGIBLE. REMOVED UNLEDGIBLE ""CLOSED"" PLACARD AND REPLACED WITH SERVICEABLE PN S1874, IAW CRJ 200 AMM 11-20-00. JC13349. EMERGENCY EXIT PLACARD ON SERVICE DOOR WITH SERVICEABLE PLACARD PN S1880 IAW CRJ SDR TRAX200701404Attach Angle · crackedLT WING L/E 530JL I/B ATTACH ANGLE IS CRACKED IN UPPER AND LOWER RADIUS. REMOVED LT L/E WING ATTACH ANGLE THAT WAS CRACKED, AND LOCATED NEW SERVICEABLE P/N 600-12045-11 AND INSTALLED, IAW CRJ SRM 51-40-11.SDR TRAX200701403Track · crackedRIGHT THRUST REVERSER LOWER O/B TRACK IS CRACKED. 10-9-07 REMOVED UNSERVICEABLE RT THRUST REVERSER LOWER O/B TRACK IAW CRJ AMM 78-34-11. PICKED UP NUTPLATES ON SERVICEABLE TRACK IAW CRJ SRM 51-42-06. REAMED AFT MOUNT BUSHING ON TRACK IAW CRJ AMM 20-26-00.SDR TRAX200701388Intercostal · crackedAAR - RIGHT HAND 621 OBLIQUE ANGLE CRACKED (INTERCOSTAL). REMOVED CRACKED OBLIQUE ANGLE AND LOCATED AND INSTALLED SERVICEABLE RT OBLIQUE ANGLE (P/N 601-35012-52) IAW CRJ 200 SRM 51-42-21. 1367. 10-1-07.SDR TRAX200701394Intercostal · crackedINTERCOSTAL CLIP CRACKED AT FS 484, LBL 27 O/B. REMOVED CRACKED INTERCOSTAL CLIP AT FS 484 LBL 27 O/B IAW CRJ 200 SRM 51-42-21. DUPLICATED ANGLE, LOCATED, DEBURRED, ALODINED, PRIMED, AND PAINTED IAW CRJ 200 SRM 53-41-43. INSTALLED SERVICEABLE ANGLE IAW CRJSDR TRAX200701393Placard · damagedAAR - PAX DOOR PANEL 832BT HAS DAMAGED -EXIT- PLACARD. REMOVED ADN APPLIED NEW SERVICEABLE EXIT PLACARD PN S1574-18 TO PAX DOOR PANEL 832BT IAW CRJ 200 AMM 11-30-00.
SDR TRAX200701084Light · inoperativeEMERGENCY LIGHT SWITCH IN COCKPIT HAS SEVERAL INOP BULBS.SDR TRAX200701083Light · inoperativeSECOND FROM AFT CEILING EMERGENCY LIGHT INOP.SDR TRAX200701042Flap System · malfunctionedFLAP ASYMMETRY IN FLIGHT LT AT ZERO AND RT AT 8-9. AFTER AIR RETURN RT INDICATION SHOWS 11 DEGREES BUT THE FLAPS PHYSICALLY SHOW AT ZERO. A/C RETURNED TO PIA AFTER T/O. EMERGENCY DECLARED. FLT 4678 DEL 495 MINS.SDR TRAX200700490Flap · failedFLAPS FAIL MESSAGE ON APPROACH TO CVG. FLAPS FAILED AT 0'. BRAKE TEMPS MAXED OUT AT 4. EMERGENCY DECLARED. FLT 4863 CX AND ON 04/08/07 FLT 4421 CX.SDR TRAX200700425Flap · malfunctionedFLAPS AGAIN, FAILED AT 0 DEG PERFORMED 0 DEG FLAP LANDING ON 41,000 CARD. REPEAT WRITE UP. EMERGENCY EQUIPMENT ON STANDBY.SDR TRAX200700395Flap System · failedFLAPS AGAIN FAILED AT ZERO. PERFORMED ZERO FLAP LANDING ON 41,000 LB CARD. REPEAT WRITE-UP. EMERGENCY DECLARED. FLTS 4913, 4818, 4683 CX.SDR TRAX200700386Flap System · malfunctionedFLAPS FAIL CAUTION WHEN SELECTED FROM 0 TO 8 INDICATION SHOWED ALL FLAPS AT 0. EMERGENCY DECLARED.SDR TRAX200700380Flap System · failedFLAPS FAIL AT 0 ON APP. EMERGENCY DECLARED. FLT 4762 DEL 35 MINS.SDR TRAX200601107Unknown · odorAIRCRAFT PERMEATED WITH A STRONG SMELL, POSSIBLY MOLD OR MILDEW ISSUE. CHECK ACM SOCKS.SDR TRAX200601050A/C Pack · odorAIR COMING FROM PACKS SMELLS LIKE DIRTY SOCKS. FLT 4425 DEL 15 MINS.SDR TRAX200600802Anchor Fitting · crackedASD FWD ANCHOR FITTING CRACKED. COMPLIED WITH E.O 600-52-0066B AS PER S/B 601R-52-116 BY REPLACING FWD AND AFT ASD COUNTER BALANCE SWIVEL LEVERS AND ANCHOR FITTINGS. OPS CK GOOD.SDR TRAX200600799Fitting · crackedASD - FWD ANCHOR FITTING CRACKED.SDR TRAX200600798Step · brokenASD - BTM STEP BROKEN.SDR TRAX200600574Step · crackedTOP STEP CRACKED ON MAIN PAX DOORSDR ASOA06119Step · crackedDURING A HANGAR INSPECTION IN MCN, THE PASSENGER DOOR BOTTOM STEP WAS FOUND TO BE CRACKED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE PASSENGER DOOR BOTTOM STEP. OPERATIONAL CHECKS GOOD. AIRCRAFT OK FOR SERVICE. (M)SDR ASOA051144Light · inoperativeDURING A GROUND INSPECTION IN CAE, THE AFT CEILING EMERGENCY LIGHTS WERE FOUND TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE LAMP IN THE AFT CEILING EMERGENCY LIGHTS. OPS CHECKS GOOD. AIRCRAFT OK FOR SERVICE. (M)SDR ASOA05949Sill · corrodedDURING A C-CHECK, THE SERVICE DOOR SILL AREA WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINT REMOVED LIGHT CORROSION IN 2 PLACES OF SERVICE DOOR SILL AREA. CLEANED, TREATED, PRIMED AND PAINTED AREAS IAW SRM. (K)SDR ASOA05923Skin · corrodedDURING A C-CHECK IN MCN, THE FORWARD FS 605, AT STRINGER 26-27, WAS FOUND TO BE CORRODED. AFTER MAINTENANCE BLENDED, ALODINED, AND PRIMED THE FORWARD FS 605, AT STRINGER 26-27, IAW REO 601R-53-61-1565, IT WAS FOUND TO BE WITHIN LIMITS. (M)SDR ASOA05924Skin · corrodedDURING A C-CHECK IN MCN, THE INTERNAL SKIN AT FS 610, AT STRINGER 22LT, UNDER THE CARGO FLOOR, WAS FOUND TO BE CORRODED. MAINTENANCE REPAIRED THE INTERNAL SKIN AT FS 610, STRINGER 22 LT, UNDER THE CARGO FLOOR IAW BOMBARDIER REO 601R-53-61-1565. (M)SDR ASOA05925Attach Angle · corrodedDURING A C-CHECK IN MCN, THE FLOOR ATTACH ANGLE, AT BL 45 LT, FS 559 PLUS 112 TO PLUS 80, WAS FOUND TO BE CORRODED. AFTER MAINTENANCE BLENDED, ALODINED, AND PRIMED THE FLOOR ATTACH ANGLE AT BL 45 LT, FS 559 PLUS 112 TO PLUS 80 IAW REO 601R-53-61-1564, IT WAS SDR ASOA05926Cargo Track · corrodedDURING A C-CHECK IN MCN, THE CARGO COMPARTMENT SEAT TRACKS WERE FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE WILL REMOVE AND REPLACE THE CARGO COMPARTMENT SEAT TRACKS. (M)SDR ASOA05927Floorbeam · corrodedDURING A C-CHECK IN MCN, THE FLOORBEAM ATTACH POINTS, AT FS 621 TO FS 560, LBL 37L, WERE FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE FLOOR ATTACH POINTS, AT FS 621 TO 560, LBL 37L IAW CRJ 200 SRM 51-42-06. (M)SDR ASOA05928Web · corrodedDURING A C-CHECK IN MCN, THE FLOOR ATTACH WEB , AT FS 559 PLUS 80 TO 621, BL 45 RT, WAS FOUND TO BE CORRODED. AFTER MAINTENANCE BLENDED, ALODINED, AND PRIMED THE FLOOR ATTACH WEB, AT FS 559 PLUS 80 TO 621, BL 45 RT, IAW REO 601R-53-61-1564, IT WAS FOUND TO BWSDR ASOA05956Floorbeam · corrodedDURING A C-CHECK IN MCN, THE FLOORBEAM AT FS 615, RBL 9, WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE FLOORBEAM AT S 615, RBL 9, IAW CRJ 200 SRM 51-42-06, 51-42-20, AND 51-00. (M)SDR ASOA05917Clip · crackedDURING A C-CHECK, THE LT IB CLIP AT FS 484, LBL 27 WAS FOUND TO BE CRACKED BEYOND LIMITS. MAINTENANCE IS REMOVING AND REPLACING THE LT IB CLIP AT FS 484, LBL 27 IAW EO 600-53-0098.SDR ASOA05918Clip · crackedDURING A C-CHECK IN MCN, THE RIGHT OUTBOARD CLIP AT FS 484, RBL 36 WAS FOUND TO BE CRACKED BEYOND LIMITS. MAINTENANCE IS REPAIRING THE RIGHT OUTBOARD CLIP AT FS 484, RBL 36 IAW ASA EO 600-53-0098. (M)SDR ASOA05919Wire · damagedDURING A C-CHECK IN MCN, THE EMERGENCY FLOOR LIGHT WIRING AT THE LAVATORY WAS FOUND TO BE DAMAGED. MAINTENANCE IS REMOVING AND REPLACING THE CONNECTORS TO THE EMERGENCY FLOOR LIGHTS AT THE LAVATORY. (M)SDR ASOA05921Skin · corrodedDURING A C-CHECK IN MCN, SKIN CORROSION WAS FOUND AT LBL 36 AND RBL 36, AT FS 409 PLUS 28 THROUGH FS 559. AFTER MAINTENANCE BLENDED, ALODINED, AND PRIMED THE SKIN CORROSION AT LBL 36 AND RBL 36, AT FS 409 PLUS 28 THROUGH FS 559, IAW REO 601R-53-41-370, IT WASSDR ASOA05920Pressure Panel · corrodedDURING A C-CHECK IN MCN, THE PRESSURE FLOOR SKIN AT LBL 36 AND RBL 36, FROM FS 409 PLUS 28 TO FS 559, WAS FOUND TO BE CORRODED BEYOND LIMITS. AFTER MAINTENANCE BLENDED, ALODINED, AND PRIMED THE PRESSURE FLOOR SKIN AT LBL 36 AND RBL 36, FROM FS 409 PLUS 28 TO SDR ASOA05914Beam · crackedDURING A C-CHECK IN MCN, THE FS 280 BEAM, OUTBOARD OF RBL 9, WAS FOUND TO BE CRACKED BEYOND LIMITS. MAINTENANCE WILL BE REPAIRING THE FS 280 BEAM, OUTBOARD OF RBL 9, IAW ASA EO`S 600-53-0090 AND 600-53-0091. (M)
Back to N838AS