N738NR, cancelled Sep 9, 2019
Service difficulty reports · 57
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 = 'N738NR' AND deregistration_id = 'N738NR-2019-09-09' 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 = 'N738NR' AND deregistration_id = 'N738NR-2019-09-09' 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 SIMA20130730002Acm · failedAFTER EMERGENCY LANDING FOUND RT PACK GRINDING AND PRODUCING ABNORMAL ODORS IN COCKPIT AND CABIN. ACFT REMOVED FROM SERVICE. R & R RT ACM IAW AMM 21-51-03, OPS CHECKED GOOD, NO DEFECTS NOTED AND NO ABNORMAL ODOR NOTED. ACFT RETURNED TO SERVICE.SDR SIMA20130725005Flashlight · inoperativeF/O FLASHLIGHT INOPERATIVE. R & R F/O'S FLASHLIGHT.SDR SIMA20130701002Connector · damagedDURING B INSPECTION, FOUND EMERGENCY LIGHT CONNECTOR WITH A BROKEN PIN. R & R CONNECTOR IAW AMM 33-50-12. THE OPS CHECKED GOOD.SDR SIMA20130621004Bulb · inoperativeDURING MX INSPECTION, FOUND THE F/O’S FLASHLIGHT INOPERATIVE. ACFT REMOVED FROM SERVICE. R & R BULB IAW STD-MX. OPS CHECKED GOOD. ACFT RETURNED TO SERVICE.SDR SIMA20130522002Holder · brokenDURING MX INSPECTION, FOUND THE F/O EMERGENCY FLASHLIGHT HOLDER BROKEN. THE ACFT WAS REMOVED FROM SERVICE. R & R THE F/O EMERGENCY FLASHLIGHT HOLDER IAW AMM 33-50-16. THE ACFT WAS RETURNED TO SERVICE.SDR SIMA20130214005Light · inoperativeDURING MAINTENANCE INSPECTION FOUND THE LEFT OVERWING EMERGENCY LIGHT INOPERABLE. THE AIRCRAFT WAS REMOVED FROM SERVICE. REMOVED AND REPLACED THE LEFT OVERWING EMERGENCY LAMP IAW EMB AMM 33-50-10. THE OPERATIONAL CHECK WAS GOOD. THE AIRCRAFT WAS RETURNED TSDR SIMA20130212003Flashlight · inoperativeON FLIGHT 2886 THE CREW REPORTED THE FLIGHT ATTENDANT FLASHLIGHT WAS INOPERABLE. THE AIRCRAFT WAS REMOVED FROM SERVICE. REMOVED AND REPLACED THE FLIGHT ATTENDANT FLASHLIGHT AS REQUIRED. THE OPERATIONAL CHECK WAS GOOD AMM 25-60-00. THE AIRCRAFT WAS RETURNEDSDR SIMA20121213002Flapper Valve · malfunctionedON FLIGHT 2981 DEPARTURE CONTROL CONTACTED THE CREW AND REPORTED A POSSIBLE FUEL LEAK FROM THE LEFT WING. THEY OBSERVED A WHITE VAPOR/SMOKE COMING FROM LEFT WING. THE CREW DECLARED AN EMERGENCY AND RETURNED TO DFW. THE AIRCRAFT LANDED WITHOUT INCIDENT. THESDR SIMA20120927001Flashlight · defectiveON FLIGHT 3322 THE CREW REPORTED THE FLIGHT ATTENDANT FLASHLIGHT OVER THE JUMP SEAT WILL NOT CHARGE. THE AIRCRAFT WAS REMOVED FROM SERVICE. REMOVED AND REPLACED THE FLIGHT ATTENDANT FLASHLIGHT IAW EMB 135 AMM 33-50-16. THE OPERATIONAL CHECK WAS GOOD. THE ASDR SIMA20120716001Battery · inoperativeFLIGHT 4505, FLIGHT ATTENDANT CAME ONBOARD AND FOUND THE EMERGENCY LIGHTS ON. THE BACK HALF OF THE FLOOR STRIP AND OVERWING EXITS DID NOT LIGHT. AIRCRAFT REMOVED FROM SERVICE. REMOVED AND REPLACED BOTH NR 3 AND 4 EMERGENCY BATTERY POWER SUPPLY. OPS CHECKEDSDR SIMA20120627003Panel · looseON FLIGHT 4500 THE CREW REPORTED THAT DURING ROTATION A PASSENGER ON THE LEFT SIDE OF AIRCRAFT NOTICED FLUID COMING OFF THE TRAILING EDGE OF THE LEFT WING. THE AIRCRAFT LANDED WITHOUT INCIDENT. THE AIRCRAFT WAS REMOVED FROM SERVICE. POST FLIGHT INSPECTION RSDR SIMA20120609001Battery · inoperativeDURING MAINTENANCE INSPECTION, FOUND EMERGENCY LIGHTING BATTERY AND POWER CHARGER NR 4 INOPERATIVE. THE AIRCRAFT WAS REMOVED FROM SERVICE. REMOVED AND REPLACED THE EMERGENCY LIGHTING BATTERY AND CHARGER AS PER MAINTENANCE WORK CARD NR 33-700-19. THE OPERATISDR SIMA20120326002Roller · dirtyON FLIGHT 4468 THE CREW REPORTED THE MAIN CABIN DOOR WAS HARD TO OPEN/ CLOSE. THE AIRCRAFT WAS REMOVED FROM SERVICE. CLEANED AND LUBRICATED MAIN CABIN DOOR ROLLERS IAW EMB 135 AMM # 52-00-04. THE OPERATIONAL CHECK WAS GOOD. THE AIRCRAFT WAS RETURNED TO SERSDR SIMA20120321005Light · brokenDURING MAINTENANCE INSPECTION FOUND THE PROXIMITY LIGHT POSITIONS 3 AT ROW 6 BROKEN. THE AIRCRAFT WAS REMOVED FROM SERVICE. REMOVED AND REPLACED THE PROXIMITY LIGHT POSITION 3 AT ROW 6 IAW EMB 135 AMM 33-50-12. THE OPERATIONAL CHECK WAS GOOD. THE AIRCRAFT SDR SIMA20120312005Light · inoperativeDURING B-INSPECTION FOUND THE NR 3 EMERGENCY STRIP INOPERABLE. THE AIRCRAFT WAS REMOVED FROM SERVICE. REMOVED AND REPLACED EMERGENCY STRIP IAW EMB135 AMM 33-50-12. THE OPERATIONAL CHECK WAS GOOD. THE AIRCRAFT WAS RETURNED TO SERVICE.SDR SIMA201206502001Smoke Detector · false activationON FLIGHT 4553 THE CREW REPORTED THAT ONE MINUTE AFTER TAKEOFF THEY RECEIVED A BAGGAGE SMOKE WARNING MESSAGE. THE CREW BLEW BOTTLES AFTER WARNING ILLUMINATED. THE CREW DECLARED AN EMERGECNY AND RETURNED TO LGA WITHOUT INCIDENT. THE AIRCRAFT WAS REMOVED FROMSDR SIMA20120301007Smoke Detector · defectiveON FLIGHT 4413 CREW RECEIVED BAGGAGE SMOKE WARNING MESSAGE ON EICAS, PRESSED BAGGAGE EXT BUTTON AS PER MEMORY ITEM. THE AIRCRAFT WAS REMOVED FROM SERVICE. REMOVED AND REPLACED FWD AND AFT CARGO SMOKE DETECTOR IAW EMB AMM 26-15-01. OPERATIONAL TEST CHECK GOOSDR SIMA2012030002Light · malfunctionedON FLIGHT 4522 THE CREW REPORTED THE FIRST OFFICER’S READING LIGHT BULB SHATTERED WITH A LOUD BANG AND PRODUCED A BURNING ODOR. THE AIRCRAFT WAS REMOVED FROM SERVICE. REMOVED AND REPLACED THE FIRST OFFICER’S READING LIGHT IAW EMB 135 AMM 33-11-02. THE OPERASDR SIMA2012012006Lens · missingDURING MAINTENANCE BASE INSPECTION FOUND THE RIGHT WING EMERGENCY LIGHT LENS MISSING. NUT PLATES, LENSE REMOVED. THE AIRCRAFT WAS REMOVED FROM SERVICE. REMOVED AND PLACED THE EMERGENCY EXIT LIGHT RIGHT SIDE OVER THE WING IAW EMB AMM 33-50-10. THE OPERATIONSDR SIMA201136105Wire · brokenEMERGENCY FLOOR LIGHTING SECOND STRIP BACK FROM FRONT HAS BROKEN WIRE. REMOVED AND REPLACED SECOND BACK FROM FRONT EMERGENCY FLOOR LIGHT STRIP IAW AMM 33-50-01. OPS CHECK GOOD.SDR SIMA201136101Proximity Sensor · defectiveIN FLIGHT GOT A SPOILER FAIL ON EICAS WITH SPOILER OPN INDICATION DECLARED EMERGENCY UPON ARRIVAL TO XNA AND LANDED WITHOUT INCIDENT. REPLACED PROX SENSOR AND CONNECTOR P1166 ON LEFT OUTBOARD SPOILER IAW EMB-135 AMM 27-63-04 AND SWPM 20-50-01. OPS TEST OF SPSDR SIMA2011313008Fire Bottle · inoperativeDURING MAINTENANCE INSPECTION FOUND THE BAGGAGE FIRE BOTTLE INOPERABLE. THE AIRCRAFT WAS REMOVED FROM SERIVCE. REMOVED AND REPLACED THE BAGGAGE HIGH RATE FIRE BOTTLE IAW AMM 26-23-01. THE OPERATIONAL CHECK WAS GOOD. THE AIRCRAFT WAS RETURNED TO SERVICE.SDR SIMA201129102Battery · dischargedDURING MAINTENANCE BASE VISIT FOUND THE LEFT FORWARD OVERWING EMERGENCY AND MAIN DOOR ENTRANCE EMERGENCY LIGHT INOPERABLE. THE AIRCRAFT WAS REMOVED FROM SERVICE. REMOVED AND REPLACED THE NUMBER 1 EMERGENCY BATTERY AND CHARGER ASSEMBLY IAW EMB 135 AMM 33-50-0SDR SIMA201015801Sign · inoperativeDURING PS-1 MAINTENANCE BASE VISIT FOUND THE EMERGENCY EXIT SIGN ABOVE THE FLIGHT ATTENDANT’S SEAT FAILED TO ILLUMINATE. THE AIRCRAFT WAS REMOVED FROM SERVICE. REMOVED AND REPLACED THE EXIT SIGN IAW EMB AMM 33-50-14. THE OPERATIONAL CHECK WAS GOOD. THE AIRSDR SIMA201015204Ecu · malfunctionedON FLIGHT 4580 THE CREW RECEIVED A FLAP FAIL MESSAGE. THE CREW DECLARED AN EMERGENCY AND LANDED WITH 0 FLAPS. THE AIRCRAFT LANDED WITHOUT INCIDENT. THE AIRCRAFT WAS REMOVED FROM SERVICE. TROUBLESHOT AND FOUND FLAP ELECTRONIC CONTROL UNIT FAIL, RIGHT SENSORSDR SIMA201002601Holder · brokenON FLIGHT 4413 A CREW MEMBER REPORTED THAT THE FORWARD CABIN EMERGENCY FLASHLIGHT HOLDER WAS BROKEN. THE AIRCRAFT WAS REMOVED FROM SERVICE. REMOVED AND REPLACED THE FORWARD EMERGENCY FLASHLIGHT HOLDER ASSEMBLY IAW AMM 33-50-16. THE AIRCRAFT WAS RETURNED TO SDR SIMA200925303Floor Support · corrodedDURING MAINTENANCE BASE INSPECTION FOUND THE LEFT OMEGA BEAM CORRODED AT FRAME 24. AIRCRAFT REMOVED FROM SERVICE. REPAIRED OMEGA BEAM AT FRAME 24 IAW EMB SRM 53-00-11 AND 51-40-02. AIRCRAFT RETURNED TO SERVICE.SDR SIMA200925101Sill · corrodedDURING THE MAIN BASE INSPECTION, FRAME 65 OF THE CARGO DOOR SILL PLATE WAS FOUND TO BE CORRODED. REMOVED AND REPLACED CARGO DOOR SILL PLATE IAW EMB 51-40-02. AIRCRAFT WAS RETURNED TO SERVICE.SDR SIM2008F00018Ballast · burnedON FLIGHT, CREW REPORTED PLASTIC BURNING ODOR THROUGH THE CABIN COMING FROM ABOVE 4A. AC REMOVED FROM SERVICE. FOUND LT SIDE WALL BALLAST BY ROW 2A, BURNED AND INOPERATIVE. REMOVED AND REPLACED BALLAST ABOVE ROW 2A IAW MM 33-71-03. OPERATIONAL CHECK GOOD, SDR SIMA200815103Liner · crackedON FLIGHT 4599 IN CLIMB CREW EXPERIENCED A MOMENTARY HIGH ITT ON ENGINE NUMBER 1 GOING THRU 3000 FEET FOR 3600 FEET. CREW REDUCED THRUST AND ITT REMAINED IN NORMAL GREEN LIMITS. FADEC A WAS IN CONTROL OF ENGINE NUMBER ONE. FOUND NUMBER ONE ENGINE COMBUSTOSDR SIMA200708503Gusset · corrodedGALLEY FORWARD GUSSET FOUND TO BE CORRODED. BLENDED THE AREA REMOVING CORROSION, FABRICATED AND INSTALLED REPAIR DOUBLER IAW EMB IC2007-145/01751, DATED 3-12-07. RETURNED AIRCRAFT TO SERVICE.SDR SIMA200708507Sill · corrodedSERVICE DOOR SILL FOUND CORRODED. REMOVED AND REPLACED SERVICE DOOR SILL IAW EMB SRM 51-20-01, 51-20-03, 51-40-02, 51-40-04 AND 51-40-06. RETURNED AIRCRAFT TO SERVICE.SDR SIMA200708506Bearing Cap · corrodedRIGHT NOSE LANDING GEAR BEARING CAP FOUND CORRODED. REMOVED AND REPLACED BEARING CAP IAW EMB AMM 32-20-02. RETURNED AIRCRAFT TO SERVICE.SDR SIMA200708504Floor Support · corrodedCENTER BEAM RAMP SUPPORT IN GALLEY AREA FOUND TO BE CORRODED. REMOVED AND REPLACED THE RAMP SUPPORT IAW EMB SRM 51-40-02. RETURNED AIRCRAFT TO SERVICE.SDR SIMA200708505Floor Support · corrodedLEFT OMEGA BEAM RAMP SUPPORT IN GALLEY FOUND CORRODED. REMOVED AND REPLACED RAMP SUPPORT IAW EMB SRM 51-40-02. RETURNED AIRCRAFT TO SERVICE.SDR SIMA200618605Insulation · looseRDU - FLT 4672 - IN DESCENT, A BURNING ELECTRICAL SMELL WAS EVIDENT IN THE COCKPIT. FLIGHT ATTENDANT SMELLED IT ONLY IN THE FORWARD CABIN. CHECKED NR 2 TEMP CONTROLLER FOR DEFECTS NONE NOTED. CHECKED NR 2 CONTACTOR AND FUSE FOR DEFECTS NONE NOTED. FOUND FOSDR SIMA200513104Battery · inoperativeCLT - FLT 4892 - CREW REPORTED THE EMERGENCY LIGHTING SYSTEM FLOOR PROXIMITY STRIPS BY ROW 3, 4, 5 AND 6 TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE NR 2 BATTERY AND CHARGER IAW EMB MM. OPERATIONAL CHECK WAS GOOD AND AIRCRAFT WAS RETURNED TO SERVSDR SIMA200501917Sill · corrodedDURING CPCP INSPECTION, MAINTENANCE FOUND THE SERVICE DOOR FORWARD SILL HAS CORROSION IN SEVERAL AREAS OF THE UPPER SURFACE. MAINTENANCE REMOVED AND REPLACED THE SERVICE DOOR FORWARD WEB (SILL) IAW SRM. AIRCRAFT RETURNED TO SERVICE. (SW21200502486) (K)SDR SIMA200501916Doubler · corrodedDURING CPCP INSPECTION MAINTENANCE FOUND THE FORWARD CABIN DOUBLER AT FRAME 20 HAS CORROSION NEAR IB EDGE. MAINTENANCE REMOVED AND REPLACED NEW DOUBLER IAW SRM. AIRCRAFT RETURNED TO SERVICE. (SW21200502486) (K)SDR SIMA200501915Bracket · corrodedDURING CPCP INSPECTION MAINTENANCE FOUND THE MAIN CABIN DOOR SHAPE U HAS CORROSION AROUND NUTPLATES AT FRAME 16. INSTALLED NEW CABIN DOOR U-SHAPE BRACKET IAW SRM. AIRCRAFT RETURNED TO SERVICE. (SW21200502486) (K)SDR SIMA200501914Doubler · corrodedDURING CPCP INSPECTION MAINTENANCE FOUND THE OMEGA BEAM AT FRAME 20 LT SIDE CORRODED. MAINTENANCE REPLACED CORRODED DOUBLER IAW SRM. AIRCRAFT RETURNED TO SERVICE. (SW21200502486) (K)SDR SIMA200501913Channel · corrodedDURING CPCP INSPECTION, MAINTENANCE FOUND THE SERVICE DOOR CHANNEL HAS CORROSION AROUND NUTPLATES. MAINTENANCE REMOVED AND REPLACED SERVICE DOOR CENTER SILL CHANNEL IAW SRM. AIRCRAFT RETURNED TO SERVICE. (SW21200501913) (K)SDR SIMA200501912Channel · corrodedDURING CPCP INSPECTION, MAINTENANCE FOUND THE MAIN CABIN DOOR SILL AFT U-SHAPE HAS CORROSION AROUND NUTPLATES. MAINTENANCE REMOVED AND NEW CABIN DOOR SILL AFT U-SHAPE BRACKET SRM. AIRCRAFT RETURNED TO SERVICE. (SW21200502486) (K)SDR SIMA200501911Floorbeam · corrodedDURING CPCP INSPECTION MAINTENANCE FOUND THE FORWARD CABIN FLOORBEAM HAT SECTION HAS CORROSION THROUGH TOP IB EDGE AT FR 20 IAW SRM. AIRCRAFT RETURNED TO SERVICE. (SW21200502486) (K)SDR SIMA200501910Floorbeam · corrodedDURING CPCP INSPECTION MAINTENANCE FOUND THE FORWARD CABIN FLOOR DIGITAL HAS CORROSION IN SEVERAL AREAS OF UPPER SURFACE. MAINTENANCE REMOVED AND REPLACED THE FLOOR DIGITAL IAW SRM. AIRCRAFT RETURNED TO SERVICE. (SW21200502486) (K)SDR SIMA200501909Floor Support · corrodedDURING CPCP INSPECTION MAINTENANCE FOUND THE FORWARD CABIN FLOOR SUPPORT AT FRAME 20 HAS CORROSION THROUGH AFT END AT LAP JOINT WITH GUSSET. MAINTENANCE REMOVED AND REPLACED THE FLOOR SUPPORT IAW SRM. AIRCRAFT RETURNED TO SERVICE. (SW21200502486) (K)SDR SIMA200501908Angle · corrodedDURING CPCP INSPECTION MAINTENANCE FOUND THE FORWARD CABIN PROFILE (Z) AT FRAME 22 HAS CORROSION IN SEVERAL FORWARD SURFACE AREAS. MAINTENANCE REMOVED AND REPLACED NEW PROFILE (Z) IAW SRM. AIRCRAFT RETURNED TO SERVICE. (SW21200502486) (K)SDR SIMA200501907Gusset · corrodedDURING INSPECTION THE FORWARD CABIN FLOOR GUSSET FRAME 20 TO FRAME 23 HAS CORROSION IN SEVERAL AREAS. INSTALLED NEW FLOOR GUSSET IAW SRM. AIRCRAFT RETURNED TO SERVICE. (SW21200502486) (K)SDR SIMA200435204Pressure Switch · failedDURING CLIMB, THE YAW DAMP FAILED FOLLOWED BY RUDDER SYS-1 INOPERATIVE. FOLLOWED BY THE RUDDER SYS-2 INOPERATIVE. AIRCRAFT WAS CONTROLLABLE AND RETURNED AS A PRECAUTION . MAINTENANCE REMOVED AND REPLACED THE NR 2 RUDDER PRESSURE SWITCH IAW MM. OPS CHECK WASDR SIMA200417202Control Unit · inoperativeNAS - FLT 4739 - DURING TAKEOFF ROLL THRUST LEVERS AT THRUST SETTING, SPOILER DEPLOYED UNCOMMANDED. CREW REPORTED A TAKEOFF MISCONFIG MESSAGE AND WHLE TAXIING BACK TO GATE RECEIVED DAU 1 MISCOMPARE. MAINTNENANCE REMOVED AND REPLACED THE SPOILER CONTROL UNIT
Back to N738NR, cancelled Sep 9, 2019