N8475B, cancelled Mar 4, 2023
Service difficulty reports · 35
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 = 'N8475B' AND deregistration_id = 'N8475B-2023-03-04' 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 = 'N8475B' AND deregistration_id = 'N8475B-2023-03-04' 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 REXA2014080600841Sensing Element · faultyAIRCRAFT RECEIVED LT 14TH STAGE DUCT MASTER WARNING ON CLIMB OUT WHILE GOING THROUGH 2000 FEET. PILOT STATED THE MESSAGE CAME ON SEVERAL TIMES. ALSO RECEIVED AN AUTO PILOT TRIM CAUTION & A HYD PUMP 1A CAUTION. AN EMERGENCY WAS DECLARED. REPLACED LT PYLON SSDR REXA2014031800302Unknown · odorELEC SMELL IN COCKPIT. PERFORMED A GENERAL VISUAL INSPECTION OF FLIGHT DECK & CB PANELS NR 1 - NR 4. INSPECTED AVIONICS BAY & EQUIPMENT, INSPECTED CARGO BAY & AFT EQUIPMENT BAY. NO EVIDENCE OF OVERHEATED WIRES OR OTHER EQUIPMENT, NO EVIDENCE OF ELEC SMELL NSDR REXA2014030600261Battery · dischargedCAPTAIN'S EMERGENCY FLASHLIGHT INOPERATIVE. REPLACED CAPTAIN'S EMERGENCY FLASHLIGHT BATTERY. OPERATIONS CHECKED GOOD IAW AMM 25-60-00. PN ON & OFF P4-01-0021.SDR REXA2013121202315Access Panel · corrodedRIGHT WING FUEL ACCESS CUTOUT HOLE FOR PANEL 640BB AT WS 54.897 HAS CORROSION 0.004 INCHES DEEP IN THE NON-CRITICAL REGION. REPAIRED IAW REO 601R-57-21-030.SDR REXA2013121202314Access Panel · corrodedLEFT WING FUEL ACCESS CUTOUT HOLE FOR PANEL 550BB AT WS 178 HAS CORROSION 0.004 INCHES DEEP IN THE NON-CRITICAL REGION. REPAIRED IAW REO 601R-57-21-030.SDR REXA2013121202313Access Panel · corrodedLEFT WING FUEL ACCESS CUTOUT HOLE NR 11 HAS CORROSION 0.004 INCHES DEEP IN THE NON-CRITICAL REGION. REPAIRED IAW REO 601R-57-21-030.SDR REXA2013121002309Hinge · gougedLEFT ELEVATOR NR 2 HINGE GOUGED. REPAIRED IAW REO 601R-55-21-080.SDR REXA2013082601616Landing Gear · out of rigSTEERING INOPERATIVE MESSAGE WHEN GEAR WAS RETRACTED. RESET AND MESSAGE WENT AWAY. MESSAGE CAME BACK WHEN GEAR LOWERED. RESET AND MESSAGE CLEARED. RIGGED RT & LT MLG IAW AMM 32-51-20. PERFORMED EXTENSION AND RETRACTION OF GEAR IAW AMM 32-30-00. ALL CHESDR REXA2013080801565Warning Light · illuminatedON APPROACH, WHILE BRING GEAR DOWN, RECEIVED A GEAR WARNING, CREW DID A GO AROUND AND RAN QRH. CYCLED STEERING SWITCH ON/OFF AND MESSAGE WENT AWAY. EMERGENCY WAS DECLARED. LANDED SAFELY. MX ADJUSTED NWS ON GROUND. NO DEFECTS WERE NOTED. NO MESSAGES DISPSDR REXA2013072601383Oxygen Mask · no testCAPTAIN`S O2 MASK FREE FLOWS DURING O2 MASK TEST OR WHEN LIFT PANEL OPEN. MUST PUSH TO TEST/REST TO GET TO STOP. CHECKED & REPLACED O2 MASK IAW AMM 35-11-12. OPS CHECKED GOOD.SDR REXA2013052801030Fire Loop · faultyLEFT ENGINE, LOOP B FAILING TEST. GIVES FIRE WARNING ON "FAIL" TEST.SDR REXA2013041900753Light · inoperativeOVERHEAD CEILING EMERGENCY FLOODLIGHT INOPERABLE. REMOVED AND REPLACED OVERHEAD CEILING EMERGENCY LIGHT IAW AMM 33-20-00. OK FOR SERVICE.SDR REXA2013040200719Control Handle · faultyINBOUND TO MSP BROUGHT GEAR DOWN AND NOTHING HAPPENED. GEAR DID NOT CAME DOWN. NO WARNING OR CAUTION MESSAGES. CYCLED GEAR LEVER AND THE GEAR CAME DOWN. REMOVED AND REPLACED LANDING GEAR CONTROL HANDLE PER AMM 32-31-01. FUNCTIONAL TESTS GOOD PER AMM 32-30SDR REXA2013033000605Control Panel · faultyON FLIGHT 3965 (MSP TO XNA), AFTER TAKEOFF, UNABLE TO RETRACT LANDING GEAR, LEVER STUCK IN DOWN POSITION. DID NOT SELECT DOWNLOCK REL, LEFT GEAR DOWN. CREW PERFORMED AIR RETURN TO MSP. PSEU REPORTED FAULT CODE DO47 CONTROL HANDLE DOWNLOCK SOLENOID FAILED. SDR REXA2013020900283Flashlight · inoperativeCAPTAIN'S SIDE FLASHLIGHT LED NOT BLINKING. REPLACED CAPTAIN'S EMERGENCY FLASHLIGHT IAW AMM 25-61-01.SDR REXA2013020600272Control Handle · malfunctionedON FLIGHT 4400 (SWF TO DTW) DURING CLIMB RECEIVED GEAR DISAGREE AND LANDING GEAR WOULD NOT RETRACT AND DOWNLOCKS FAILED TO RELEASE. HANDLE MOVED FREELY. THE AIRCRAFT DIVERTED TO JFK AND LANDED SAFELY. FOUND PSEU CODE D111 OFF. COMPLIED WITH SCENARIO 1 OF PSDR REXA0829201201297Smoke Goggles · missingOBSERVER SEAT SMOKE GOGGLES MISSING. REPLACED SMOKE GOGGLES IAW AMM 35-10-00.SDR REXA2012082301092Skin · dentedDENTS IN FUSELAGE SKIN BETWEEN FS 409 AND 409+48 S21-25L. REPAIRED IAW BOMBARDIER SRM 53-00-31 REPAIR NR 1.SDR REXA2012051400723Life Vest · tornOBSERVER LIFE VEST BAG TORN. REMOVED AND REPLACED VEST IAW AMM 25-61-03.SDR REXA2012050400609Light · inoperativeNR 4 INTERIOR EMERGENCY LIGHT INOP. REMOVED AND REPLACED NR 4 INTERIOR EMERGENCY LIGHT IAW AMM 33-51-21. OPS CHECK GOOD.SDR REXA2012022300272Trim System · slowAILERON TRIM SLOW. OPC AILERON TRIM SYSTEM, OPC NORMAL.SDR REXA2012021800260Light · inoperativeEMERGENCY FLOOR LIGHTING STRIP ROW 9-12 INOPERATIVE. REMOVED AND REPLACED EMERGENCY FLOOR LIGHT AT ROW 9-12 IAW AMM 33-51-01. OPS CHECKED GOOD. OK FOR SERVICE.SDR REXA201100713Bulkhead · crackedFS 280 BULKHEAD WEB IS CRACKED OUTBD OF LBL 9 AND RBL 9, AFT J-ANGLE AT FS 280 CRACKED OUTBD OF LBL 9, 2 EA CLIPS CRACKED AT LBL 9, 2 EACH CLIPS CRACKED AT RBL 9, FWD J-ANGLE AND AFT J-ANGLE CORRODED BETWEEN RBL 9 AND LBL 9 FS 280. REPAIRED IAW BOMBARDIER REOSDR REXA201100702Bpsu · defectiveFLAPS FAIL CAUTION MSG INFLIGHT. EMERGENCY DECLARED. SECURED FLAPS AT FLAP 20 BY PULLING & COLLARING CB 1F4, B5 2F4, B5 IAW SERVICE LETTER RJ-CL27-077. A/C FLAP SYSTEM INSPECTED AND DETERMINED TO BE INOPERATIVE AND NOT AIRWORTHY FOR REVENUE FLIGHT, BUT THE SDR REXA201100288Light · malfunctionedAFTER CLOSING MCD ELECTRICAL BURNING SMELL FILLED FLIGHT DECK, FOUND ELECTRICAL BURN ON GALLEY LIGHT FIXTURE. DISCONNECTED GALLEY LIGHTS AND DEFERRED PER MEL 33-31-01 AUTH 43642 PLACARD INSTALLED.SDR REXA201100287AFixture · burnedAFTER CLOSING MCD ELECTRICAL BURNING SMELL FILLED FLIGHT DECK FOUND ELECTRICAL BURN ON GALLEY LIGHT FIXTURE. DISCONNECTED GALLEY LIGHTS AND DEFERRED PER MEL 33-31-01 AUTH 43642 PLACARD INSTALLED.SDR REXA201100280Unknown · fumesAIR RETURN FOR FUMES IN THE COCKPIT. CREW DECLARED EMERGENCY LANDED WITHOUT INCIDENT.SDR REXA201100180Unknown · malfunctionedA/C LOST PRESSURIZATION AT 10000 FT. MANUAL OVERRIDE LEVER MOVE TO CLOSE ON THE OVERBOARD EXHAUST SHUTOFF VALVE AS PER AMM 21-24-040-806.SDR REXA201000086Secu · failedSPOILERONS CAUTION AND SPOILER CAUTION MSG IN FLIGHT. EMERGENCY LANDING DECLARED. REMOVED AND REPLACED SECU RT SIDE IAW AMM 27-61-05-04, OPS CHECK GOOD.SDR REXA201000075Ecu · malfunctionedCREW REPORTED A FLAPS FAIL AT 20. MISSED APPROACH, RAN QRH. LANDED WITHOUT INCIDENT. MAINTENANCE REMOVED AND REPLACED THE FECU IAW AMM 27-51-05.SDR REXA201000016Flap · failedFLAPS FAIL AT 20 PERFORMED TROUBLESHOOTING PER BOMBARDIER FIM REV 39 IAW AD2009-06-12 PAR H, G, I PER AMOC DATED MARCH 27 2009 AND PAAD27-052F. PERFORMED FECU BPSU & CONTROL LEVER BITE CHECK IAW FIM 27-50-00, CHECKS GOOD, PERFORMED MAN TORQUE CK ON BPSU & RIGSDR REXA200900068Apu · smokeUPON APU START AT KCLE, THE CABIN AND COCKPIT FILLED WITH SMOKE. FLIGHT CREW NOTIFIED ATC AND ASKED FOR CFR. THE AIRCRAFT WAS EVACUATED WITHOUT INCIDENT. CFR FOUND NO EVIDENCE OF FIRE. MAINTENANCE DETERMINED THE SMOKE WAS PRODUCED BY THE APU. THE APU WAS SDR REXA200900062Apu · smokeTHE AIRCRAFT WAS ON TAXIWAY A1 AT KFNT PREPARING TO RETURN TO THE GATE DUE TO WEATHER HOLD. THE FLIGHT CREW SMELLED SMOKE AND THE FLIGHT ATTENDANT REPORTED THERE WAS VISIBLE SMOKE IN THE CABIN. THE FLIGHT CREW DECLARED AN EMERGENCY, PERFORMED THE QRH AND EVASDR REXA200600024Light · defectiveBURNING ELECTRICAL SMELL/ ACIDIC ODOR NOTED WITHIN FLIGHT DECK AT GATE. REMOVED AND REPLACED GALLEY LIGHT ASSEMBLY (SECOND FROM TOP) IAW AIRCRAFT MAINTENANCE MANUAL. AIRCRAFT OKAY FOR SERVICE.SDR REX2002F00001Handle · inoperativeFLAP FAIL MESSAGE WHILE CONFIGURING FOR VISUAL APPROACH. QRH PROCEDURES FOLLOWED AND A UNEVENTFUL LANDING WAS PERFORMED. COMPLETED AD 98-20-01 FOUND FLAP HANDLE NOT IN DETENT, DI OPENED AND FLAPS WHERE MONITORED FOR SEVENTY TWO HOURS WITH NO DEFECTS NOTED.
Back to N8475B, cancelled Mar 4, 2023