N542EA
Service difficulty reports · 91
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 = 'N542EA' AND registry_match = 'registration' 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 = 'N542EA' AND registry_match = 'registration' 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 SIMA2020013017012Web · unknownRH WEB/FLOOR AT FS 193.00 OUTBD OF THE ADG RETACTION PUMP HAS 3/8" CRACK ON THE PREVIOUS REPAIR DOUBLER. -C/A-REPLACED REPAIR DOUBLER FROM PREVIOUS REPAIR IAW SRM 53-11-43 AND ETN-CR-53-099.SDR SIMA2020021906008Charger · failedEMERGENCY LIGHTING BATT P/N 2013-1 S/N 109524 AND POWER SUPPLY P/N 11-0049 S/N 24464 A110 REQ TO BE REMOVED AND REPLACED.-C/A-FOUND BATTERY S/N 109524 AND CHARGER S/N 24464 IN THE #3 POSITION. REMOVED AND REPLACED EMERGENCY LIGHTING BATTERY AND CHARGER IAW CSDR SIMA201911298005Unknown · odorOUT OF 12,000 FT SMELLED A PLASTIC BURNING SMELL FOLLOWED BY SMOKE AFT LAV EICAS FOLLOWED GRH PROCEDURE SMOKE AFT LAV RETURNED ORD EMERGENCY DECLARED-C/A-C/W FIM TASK 21-22-00ABNORMAL SMOKE/ SMELL AFTER MAIN ENG COMPRESSOR WASH, GROUND RAN BOTH ENGS AND BLEEDSDR SIMA201910176001Bulb · inoperativeLH AFT EXTERIOR EMERGENCY LIGHT INOP. REMOVED AND REPLACED LH AFT EXTERIOR EMERGENCY LIGHT BULB IAW AMM 33-51-15. OPS CHECK GOODSDR SIMA20190215005Warning System · false activationSTEERING INOP CAUTION MESSAGE AFTER EXTENDING LANDING GEAR. STEERING INOP CAUTION RESET PER AOM VOLUME 1 RESET PROCEDURES PAGE 130.13.SDR SIMA20181008001Charger · failedAFT EMERGENCY LIGHT (EXIT) WILL NOT SHUT OFF. -C/A-REMOVED AND REPLACED NR 3 EMERGENCY LIGHT CHARGER/CRADLE ASSY IAW AMM 33-51-07; OPS CHECK GOOD.SDR SIMA20180923001Hydraulic Line · leakingAFTER LANDING ON TAXI LOSS OF NOSE WHEEL STEERING CONTROL FOLLOWED BY HYD 3 LO PRESS, STEERING INOP AND SYSTEM 3 QUANTITY AT 0% FLUID REPORTED PUDDLED AROUND NOSE GEAR AND BEHIND AIRCRAFT ON TAXIWAY TOWED TO GATE. REF NRWC 542-ORD-02159 FOR THE R&R OF HYD LINESDR SIMA20180627002Acm · seizedWHEN LEFT PACK WAS TURNED ON AFTER A FEW SECONDS WE'VE GOT SMOKE IN THE CABIN AND 'L PACK AUTOFAIL CAUTION MSG WAS POSTED'. HAD PAX ALREADY ON BOARD AND DEPLANED IMMEDIATELY. DEFERRED PER MEL PERFORMED FIM TASK 21-21-00 AND 21-22-00. SMOKE AND ABNORMAL SMELL SDR SIMA20170918001Wire · brokenEMERGENCY EXIT FA CALL BUTTON LIGHT INOPERATIVE. REMOVED AND REPLACED BOTH LIGHT BULBS AT EXTERIOR LAVATORY WALL, AND CIRCUIT BOARD PANEL IAW AMM 33-23-01 AND AMM 23-31-17 NEITHER COMPONENTS CORRECTED PROBLEM WITH LIGHT DIMMING. REPAIRED BROKEN GROUND WIRE SDR SIMA20170809004Structure · crackedLEFT FORWARD EQUIPMENT BAY FLOOR CRACKED IN CORNER. REPAIRED LEFT FORWARD EQUIPMENT BAY FLOOR IAW ETN-CR-53-099.SDR SIMA20170307001Angle · crackedLEFT UPPER TRANSLATING COWL FORWARD INBOARD ANGLE IS CRACKED, REPLACED ANGLE IAW ETN-CR-54-015R1.SDR SIMA20170305003Angle · crackedLEFT UPPER TRANSLATING COWL FWD OUTBD ANGLE IS CRACKED. REPLACED THE ANGLE IAW ETN-CR-54-015R1.SDR SIMA20170305004Stand Off · damagedLEFT LOWER TRANSLATING COWL FWD INBD ANGLE IS CRACKED. REPLACED THE STANDOFF IAW SRM 51-42-14, 51-42-21 AND ETNCR-54-015R1.SDR SIMA20160709001Handle · obstructedPASSENGER ENTRY (MAIN CABIN DOOR) DIFFICULT TO OPEN. CLEANED DEBRIS FROM INTERIOR LOCK HANDLE ROLLER BEARING IAW STANDARD MAINTENANCE PRACTICES. OPS CHECK GOODSDR SIMA20160702004Warning System · false activationWHEN RETRACTING SPOILERS DURING APPROACH, RECEIVED OTBD SPOILERONS AND OTBD FLT SPOILERS CAUTION MSG. C/W QRH CHECKLIST. INTERROGATED MDC, FOUND LT OTBD MFS PCU, PCU JAM MESSAGE. PERFORMED SPOST1 REST. PERFORMED OPS CK IAW ETN CR-27-093. OPS CK GOOD.SDR SIMA20160527002Warning System · false activationIN DESCENT DOWNWIND, UPON STOWING THE FLIGHT SPOILER HANDLE, THE OTBD SPOILERS & OTBD FLIGHT SPOILERS CAUTION MSG POSTED. RAN THE AOM 1 CHECKLIST & DECLARED AN EMER. ON THE FLIGHT CONTROLS SYNOPTIC PAGE THE LT OTBD FLIGHT SPOILER BOX IS AMBER, RT OTBD FLIGHSDR SIMA20160226002Holder · brokenFLASHLIGHT HOLDER FOR NR 1 FLIGHT ATTENDANT BROKEN. R & R FWD FLIGHT ATTENDANT FLASHLIGHT ASSEMBLY IAW AMM 25-61-02. OPERATIONS CHECKED GOOD. MEL ITEM RESTORED.SDR SIMA20160213006Battery · dischargedEMERGENCY LIGHTS FOR BATTERY PACK 3 STAY ON. TROUBLE SHOT & FOUND NR 3 EMER BATTERY & CHARGER BAD. R & R NR 3 EMER BATTERY & EMER BATTERY CHARGER. OPERATIONS CHECKED GOOD IAW AMM 33-51-00. BATTERY CHARGER ASSEMBLY PN 11-0049 & SN 13314.SDR SIMA20160212002Relay · failedEMERGENCY LIGHTS ON EXIT ROW CAPTAIN'S SIDE ARE STAYING ON. R & R RELAY K198 IAW MM 33-51-19. OPERATIONS CHECKED GOOD.SDR SIMA20160113001Flashlight · inoperativeAFT FLIGHT ATTENDANT FLASHLIGHT NOT CHARGING. REPLACED AFT FLIGHT ATTENDANT FLASHLIGHT IAW AMM 25-61-02.SDR SIMA20150303012Structure · crackedRIGHT SIDE FLOOR IN FWD EQUIP COMPARTMENT HAS A 3/8" CRACK THAT RUNS UNDER ADG PUMP. REPAIRED RT SIDE FLOOR IN FWD EQUIP COMPARTMENT IAW ETN-CR-53-099.SDR SIMA20150225012Frame · corrodedMAIN AVIONICS UNDERFLOOR FRAME AT FS 295.00 IS CORRODED BETWEEN STRINGERS 26 LT - 26 RT. REPAIRED UNDERFLOOR FRAME IAW SRM 53-21-06. COMPLIED WITH DT CHECKLIST 15 - 27.SDR SIMA20150225007Bracket · crackedRIGHT HEAT EXCHANGER WATER INJECTION LINE BRACKET BETWEEN FS 1144.00 & 1162.00 AT STRINGER 7 IS CRACKED. R & R BRACKET IAW SRM 51-42-06.SDR SIMA20150225008Bracket · crackedRIGHT HEAT EXCHANGER WATER INJECTION LINE BRACKET BETWEEN FS 1144.00 & 1162.00 AT STRINGER 9 IS CRACKED. R & R BRACKET IAW SRM 51-24-06.SDR SIMA20150225009Intercostal · chafedRIGHT SUPPORT WEB BETWEEN FS 1144.00 & 1162.00, AT STRINGER 9 IS CHAFED. REPAIRED IAW ERS-CR-53MR-1125.SDR SIMA20150225010Cover · damagedCABIN EMER FLOOR LIGHT STRIPS RT SIDE SECTIONS 1, 9 & OVERWING EXIT HAVE CRACKED, BROKEN OR UNSERVICEABLE COVERS. R & R CRACKED, BROKEN OR UNSERVICEABLE CABIN EMER FLOOR LIGHT STRIPS RT SIDE SECTIONS 1, 9 & OVERWING EXIT IAW AMM 33-51-01.SDR SIMA20150225011Frame · corrodedMAIN AVIONICS UNDERFLOOR FRAME AT FS 319.70 IS CORRODED BETWEEN STRINGERS 26 LT - 27. REPAIRED UNDERFLOOR FRAME IAW SRM 53-21-06. COMPLIED WITH DT CHECKLIST 15 - 27.SDR SIMA20150225005Frame · corrodedMAIN AVIONICS UNDERFLOOR FRAME AT FS 310.00 IS CORRODED BETWEEN STRINGERS 26 LT - 26 RT. REPAIRED UNDERFLOOR FRAME IAW SRM 53-21-06. COMPLIED WITH DT CHECKLIST 15 - 27.SDR SIMA20150225006Panel · crackedPASSENGER DOOR AFT SIDE PANEL AT UPPER MIDDLE STEP IS CRACKED. REPAIRED PAX DOOR AFT SIDE PANEL AT UPPER MIDDLE STEP IAW SRM 52-11-04.SDR SIMA20141008008Light · missingEMERGENCY LIGHT MISSING ON MAIN CABIN DOOR. INSTALLED NEW LIGHT STRIP IAW SMP. NO FURTHER DEFECTS NOTED.SDR SIMA20141007001Warning Message · false activationPASSENGER DOOR WARNING IN FLIGHT. FOLLOWED AOM VOL 1 PROCEDURES. PERFORMED OPS CHECK OF THE PAX DOOR INDICATION IAW AMM 52-11-00. OPS CHECK GOOD. NO DEFECTS NOTED.SDR SIMA20140621001Hand Rail · defectiveUNABLE TO OPEN PAX DOOR FROM EITHER INSIDE OR OUTSIDE. R & R FWD & AFT STUDS HANDRAIL IAW AMM 52-11-05. OPERATIONS CHECKED GOOD.SDR SIMA20140326002Flashlight · inoperativeNR 1 FLIGHT ATTENDANT FLASHLIGHT & MOUNT FELL OFF WALL & WILL NOT CHARGE. REPLACED NR 1 FLIGHT ATTENDANT FLASHLIGHT ASSEMBLY IAW AMM 25-61-02, OPERATIONS GOOD.SDR SIMA20131010001Battery · malfunctionedAFT EXTERIOR EMERGENCY LIGHTS CONTINOUSLY ILLUMINATED. R & R EMERGENCY LIGHT CHARGER AND BATTERY AT NR 4 POSITION IAW AMM 33-51-17. OPS CHECK GOOD.SDR SIMA20130917001Engine · vibrationLEFT ENGINE, HIGH VIBATION ON CLIMBOUT WENT UP TO 1.8 BEFORE WE LEVELED OFF AND BROUGHT BACK THE POWER. PREFORMED FIM TASK 72-00-00-810-011. ALL VIBRATIONS WITHIN LIMITS.SDR SIMA20130906002Battery Pack · inoperativeBATTERY POWER SUPPLY UNSERVICEABLE. R & R NR 4 BATTERY POWER SUPPLY IAW WORK CARD 33-002. OPS CHECKED GOOD.SDR SIMA20120920005Flashlight · intermittentON FLIGHT 3785 - THE CREW REPORTED THE FIRST OFFICER’S FLASHLIGHT ONLY WORKED WHEN SHAKEN. REMOVED AND REPLACED THE FIRST OFFICER’S FLASHLIGHT ASSEMBLY IAW CRJ 700 AMM 25-6102. THE OPERATIONAL CHECK WAS GOOD. THE AIRCRAFT WAS RETURNED TO SERVICE.SDR SIMA2012059007Cable Assy · brokenDURING FLIGHT 4590 THE MAIN PASSENGER DOOR HAS LOUD AIR LEAK NOISE WHILE IN FLIGHT. THE AIRCRAFT WAS REMOVED FROM SERVICE. FOUND ICE BREAK CABLE BROKEN BETWEEN VENT FLAP & DOOR ASSY PREVENTING DOOR (FLAP VENT) TO SEAL. REPLACED ICE BREAK CABLE IAW AMM 52-11SDR SIMA201203802Wire Harness · faultyFOR FLIGHT 3745 THE CREW REPORTED THAT WHILE ON APPROACH THEY RECEIVED AN ANTI-SKID OUTBAORD MESSAGE. THE CREW DECLARED AN EMERGENCY AND LANDED WTHOUT INCIDENT. THE AIRCRAFT WAS REMOVED FROM SERVICE. REMOVED AND REPLACED THE RIGHT MAIN LANDING GEAR PRXIMITYSDR SIMA201202504Wire Harness · faultyON FLIGHT 4588 THE CREW REPORTED THAT ON SHORT FINAL THEY RECEIVED AN ANTI-SKID INBOARD INOPERABLE CAUTION MESSAGE. THE CREW DECLARED AN EMERGENCY. UPON TOUCHDOWN THE MESSAGE EXTINGUISHED. THE AIRCRAFT LANDED WITHOUT INCIDENT. THE AIRCRAFT WAS REMOVED FROMSDR SIMA201109411Tru · malfunctionedON FLIGHT 3712 SMOKE WAS OBSERVED COMING FROM THE NOSE CLAM SHELL DOORS. (WHEN DISCOVERED-UNKNOWN) THE CAPTAIN ELECTED TO RETURN TO ORD. REMOVED AND REPLACED THE NUMBER 1 TRANSFORMER RECTIFIER UNIT IAW CRJ 700 AMM 24-31-01. THE OPERATIONAL CHECK WAS GOOD NO
Back to N542EA