N400BR, cancelled Feb 22, 2010
Service difficulty reports · 28
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 = 'N400BR' AND deregistration_id = 'N400BR-2010-02-22' 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 = 'N400BR' AND deregistration_id = 'N400BR-2010-02-22' 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 SIMA200829602Seat Track · corrodedDURING A HMBV INSPECTION THE SEAT TRACK AT BL 0.00 WAS FOUND TO BE CORRODED. REMOVED THE SEAT TRACK AND CUT, CLEANED ALODINED AND PRIMED ALL FASTENER HOLES. REPAIR DONE IAW SAAB SRM (SRM 72LKS3079 REV 50) CHAPTER 53-70-60. AIRCRAFT RETURNED TO SERVICE.SDR SIMA200631702Warning Light · illuminatedLEFT TAIL PIPE HOT LIGHT ILLUMINATED. AIRCRAFT OPERATING MANUAL PROCEDURES WERE FOLLOWED, ENGINE WAS SHUTDOWN AND LIGHT EXTINGUISHED ABOUT 10 MINUTES LATER. WX=VRBL 03 KTS CLEAR TEMP 11 DEG C/DP-2DEG C/30/07. COMPLIED WITH ADJUSTMENT TEST OF OVERTEMP SYSTEMSDR SIMA200513603Engine · failedDURING TAKEOFF RT ENGINE FAILED. ITT WAS NOTED AT 1148 DEGREES. ACFT DID NOT GET OFF GROUND. MX REMOVED AND REPLACED RT ENGINE IAW SAAB MM. OPS AND LEAK CHECKS WERE SATISFACTORY. ACFT RETURNED TO SERVICE. (M)SDR SIMA200415404Seat Track · corrodedDURING A MBV INSPECTION ONE AREA OF CORROSION WAS FOUND ON THE WEB OF SEAT TRACK BL 0.0 AT STATION 298.8. BLENDED THE CORRODED AREA. ONE CORROSION PIT REMAINED. COMPLETELY REMOVED CORROSION PIT BY DRILLING A NR 21 HOLE IN THE WEB. WET INSTALLED ONE MS20470SDR SIMA200415415Skin · dentedABI - AIRCRAFT SUSTAINED HAIL DAMAGE THAT NECESSITATED THE REPLACEMENT OF THE RIGHT HORIZONTAL STAB UPPER SKIN. REMOVED DAMGAED UPPER SKIN. I NSTALLED NEW SKIN IAW SAAB 340 SRM, 72LKS3079, REV 43, 51-40-21, 22, 23, 25, 40, 51-20-50, 56, AND SAAB REPAIR STATESDR SIMA200226804Connector · disconnectedTUL - FLT 3651 - CREW REPORTED NO DOWN AND LOCKED GREEN LIGHT WHEN GEAR WAS SELECTED DOWN ON THE RIGHT MAIN LANDING GEAR. CREW ELECTED TO DECLARE EMERGENCY AS A PRECAUTION AND AIRCRAFT WAS LANDED WITH NO FURTHER INCIDENTS. MAINTENANCE FOUND THE DOWNLOCK SWITSDR SIMA200211603Detector · faultyDFW - FLT 3580 - CREW REPORTED THE RIGHT ENGINE TAIL PIPE HOT LIGHT ILLUMINATED. EMERGENCY WAS DECLARED AND AIRCRAFT WAS LANDED WITHOUT FURTHER INCIDENT. MAINTENANCE REMOVED AND REPLACED ALL THREE DETECTORS IN THE RIGHT TAIL PIPE IAW SAAB MM. MAINTENANCE ALSDR SIMA200110103Light · inoperativeDFW - FLT 3913 - FLOOR PROX LIGHT AT 4A ISSUED MEL 33-15-3 AUTH 040303 CAT C. RAI FLOOR PROX LIGHT STRIP IAW AMM 33-50-20. OPS CHECKS GOOD. MEL ITEM RESTORED. REF LOG PAGE 1290613 ITEM NR 4. (M)SDR SIMA0641Pcu · malfunctionedDFW - FLT 3251 - RIGHT PROP WENT TO FEATHER WHEN POWER WAS ADVANCED FOR TAKEOFF, THERE WAS NO TORQUE INDICATION AT THIS POINT. PROP CAME OUT OF FEATHER WHEN THE AUTOCOARSEN WAS TURNED OFF, STILL WITH NO TORQUE INDICATION. RAI RIGHT ENGINE PCU IAW HAMILTON STSDR SIMA02216Plate · corrodedSBP - FOUND CORROSION ON LEFT ENTRY KICKPLATE. REPLACED KICKPLATE. (M)SDR SIMA02215Intercostal · corrodedSBP - FOUND CORROSION ON FUSELAGE INTERCOSTAL BETWEEN FUSELAGE STATION 272 AND 288 RIGHT SIDE. REPLACED INTERCOSTAL ANGLE. (M)SDR SIMA02214Angle · corrodedSBP - FOUND CORROSION ON PREVIOUS REPAIR FILLER AND SUPPORT ANGLE AT FUSELAGE STATION 258. REPLACED REPAIR FILLER AND SUPPORT ANGLE. (M)SDR SIMA02213Frame · corrodedSBP - FOUND CORROSION ON FUSELAGE FRAME AT STATION 272. REMOVED CORRODED AREA. APPLIED SURFACE TREATMENT AND INSTALLED REINFORCEMENT ANGLE, FILLERS AND TRIPLER IAW SAAB STRUCTURAL REPAIR STATEMENT 340SDS000775. (M)SDR SIMA02212Rivet · corrodedSBP - FOUND CORROSION ON RIVETS THROUGH THE FORWARD END OF WEB AT FUSELAGE STATION 236.5 AT BL 18.3 LEFT SIDE ARE CORRODED. REPLACED RIVETS. (M)SDR SIMA02211Web · corrodedSBP - FOUND CORROSION ON WEB PLATE FORWARD OF FRAME 258 AT BL 18.3 TO BL 12. REPLACED WEB. (M)SDR SIMA02210Web · corrodedSBP - FOUND CORROSION ON WEB REINFORCEMENT AT STATION 294. REPLACED WEB. (M)SDR 20010222SG006Angle · corrodedSBP - FOUND CORROSION ON INTERCOSTAL AND SUPPORT ANGLE BETWEEN STATIONS 258 AND 236.5 AT BL 12 LEFT SIDE. REPLACED INTERCOSTAL AND SUPPORT ANGLE. REF SIMA0229. (M)SDR SIMA0229Intercostal · corrodedSBP - FOUND CORROSION ON INTERCOSTAL AND SUPPORT ANGLE BETWEEN STATIONS 258 AND 236.5 AT BL 12 LEFT SIDE. REPLACED INTERCOSTAL AND SUPPORT ANGLE. (M)SDR SIMA0228Track · corrodedSBP - FOUND CORROSION ON AIR STAIR TRACK AND SUPPORTS. REPLAED AIR STAIRS TRACK. (M)SDR 20010222SG007Rivet · corrodedSBP - FOUND CORROSION ON RIVETS BELOW FLOOR AT THE AFT CABIN BULKHEAD AT FUSELAGE STATION 630. REPLACED RIVETS. REF SIMA02217. (M)SDR SIMA02217Rivet · corrodedSBP - FOUND CORROSION ON RIVETS BELOW FLOOR AT THE AFT CABIN BULKHEAD AT FUSELAGE STATION 630. REPLACED RIVETS. (M)SDR SIMA2113Bleed Valve · inoperativeDFW - FLT 3451 - LEFT AIR VALVE LIGHT CAME ON IN FLIGHT. RAN AIR VALVE LIGHT ON CHECKLIST, COULD NOT EXTINGUISH. MAINTENANCE REMOVED AND REPLACED THE LEFT AIR ANTI-ICE START BLEED VALVE IAW GE MM. OPERATIONAL CHECK WAS GOOD AND AIRCRAFT WAS RETURNED TO SERVSDR SIMA1261Smoke Detector · malfunctionedFLT - 3600 - CARGO SMOKE LIGHT CAME ON IN FLIGHT. DISCHARGED NR 1 CARGO FIRE BOTTLE. SMOKE LIGHT WENT OUT, A/C DIVERTED TO ABI. PERFORMED DETAILED CLEANING OF CARGO SMOKE DETECTORS AND PERFORMED OPS CHECK OF SMOKE DETECTOR SYSTEM IAW SAAB AMM. OPS CHECK GOSDR SIMA0491Power Supply · inoperativeDFW - FLT 3594 - EMEREGNCY LIGHTS INOPERATIVE AT ROW 8. REMOVED AND REPLACED POWER SUPPLY AT 20LN. OPS CHECK GOOD. (M)SDR SIMA0455Socket · looseDFW - FLT 3766 - SEAT 6A OVERHEAD EMERGENCY LIGHT INOPERATIVE. FOUND LAMP SOCKET DAMAGED. REMOVED AND REPLACED LAMP SOCKET IAW SAAB 340 AMM 33-50-55. OPS CHECK GOOD. (M)SDR SIMA992041Socket · failedSAT - FLT 5065 - SMOKE IN THE CABIN SMELLED ELECTRICAL IN NATURE. OCCURRED AT FL 200 OVER SAT. MADE EMERGENCY LANDING INTO SAT. FOUND SEAT 5A OVERHEAD LIGHT SOCKET WAS BAD. DEFERRED LIGHT SOCKET. ON AUGUST 5, RESTORED MEL BY REPLACING THE OVERHEAD LAMP HOSDR SIMA982852Hose · leakingDFW - FLT 3652 - AFTER LANDING AT DFW, HYDRAULIC QUANTITY, BRAKE PRESSURE, AND ACCUMULATOR PRESSURE ALL WENT TO ZERO. DEPLANED PASSENGERS ON TAXIWAY. TOWED AIRCRAFT TO HANGAR. REMOVED AND REPLACED BRAKE LINE THAT ATTACHES TO THE LEFT OUTBOARD BRAKE DUE TO LSDR SIMA9701941Connector · looseDFW - FLT 3577 - FORWARD BULKHEAD EXIT SIGN INOPERABLE. RE-SECURED CANNON PLUG TO GALLEY UNIT, OPS CHECK GOOD. AIRCRAFT RETURNED TO SERVICE. (X)
Back to N400BR, cancelled Feb 22, 2010