N496CA
Service difficulty reports · 163
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 = 'N496CA' 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 = 'N496CA' 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 SWIA201436388Fuel Line · defectiveAT CRUISE THERE WAS A STRONG SMELL OF FUEL. BEGINNING WITH THE DESCENT, SMELL DISAPPEARED. FLT 2902 REPLACED THE APU FUEL LINE & THE INLET RETAINING CLIP IAW AMM. PN ON 3883449-1, PN ON 600-97024-9 & PN ON JM44LC86WH3GF.SDR SWIA201436381Unknown · odorSMELL GAS FUMES OUT OF GASPERS AFTER ENG START & WHILE USING HEAT TO WARM UP CABIN & COCKPIT. FLT 2918 CHECKED SERVICING ON LT ACM. OPERATED LEFT PACK, OPERATIONS CHECKED GOOD.SDR SWIA201435997Steering Unit · faultyON TAKEOFF ROLL ENGS SPOOLED SIMULTANEOUSLY & AIRCRAFT PULLED HARD TO THE RIGHT. FULL LT RUDDER WAS INPUT BUT AIRCRAFT CONTINUED RIGHT. ABORTED TAKEOFF AT SLOW SPEED, NOSE WHEEL STEERING CONFIRMED ARMED. FLT2969 REPLACED NOSE WHEEL STEERING HAND WHEEL UNIT SDR SWIA201335199O-Ring · leakingFUEL ODOR WHEN APU IS RUNNING. FLT 2972 REPLACED O-RINGS ON APU FUEL SOLENOID. RAN APU LEAK & OPERATIONS CHECKED GOOD.SDR SWIA201334604Reservoir · contaminatedGEAR DISAGREE WARNING MESSAGE RAN QRH & GEAR CAME UP. FLT#2978 BLED AIR FROM HYDRAULIC NR 3 RESERVOIR IAW AMM. OPERATIONS CHECKED GOOD.SDR SWIA201334402Battery · dischargedEMERGENCY LIGHTS DO NOT ILLUMINATE. FLT#2954 CHARGED EMERGENCY LIGHTS. OPERATIONS CHECKED GOOD.SDR SWIA201333937Light · inoperativeGALLEY EMERGENCY EXIT SIGN BULB IS BURNED OUT. FLT#2941 RELAMPED.SDR SWIA201332947Sill · crackedCARGO FLOOR SILL LEFT AT FS 589 HAS CRACK EXTENDING FROM RIVET HOLE. (C-CHECK) REPAIRED CRACKED AREA OF CARGO FLOOR SILL FS 589 IAW REO.SDR SWIA201332599Hydraulic System · contaminatedHYDRAULIC NR 3 LOW PRESSURE MESSAGE APPEARED ON EDI ALONG WITH GEAR DISAGREE MESSAGE. (FLT 2975) FOUND AIR IN HYDRAULIC SYSTEM NR 3. PURGED SYSTEM. OPS CHECK GOOD.SDR SWIA201232180Light · inoperativeNR 4 EMERGENCY OVERHEAD LIGHT BURNED OUT. (FLT 2948) RELAMPED EMERGENCY LIGHT.SDR SWIA201232110Fuel Line · chafedFUEL SMELL IN AIR CONDITIONING SYSTEM. (FLT 2956) APU BELLOWS CLAMP CHAFED FUEL LINE.SDR SWIA201231915Light · inoperativeAFT OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 2989) RELAMPED EMERGENCY LIGHT.SDR SWIA201231567Connector · looseRECEIVED MLG BAY OVERHEAT WARNING WITH ASSOCIATED TRIPLE CHIME AND AURAL WARNING. (FLT 2981) TIGHTENED LOOSE CONNECTOR AND TIGHTENED JAM NUT IN REFERENCE TO AMM.SDR SWIA201231220Light · inoperativeNR 1 OVERHEAD EMERGENCY LIGHT IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201230933Light · inoperativeNR 3 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 2959) RELAMPED EMERGENCY LIGHT.SDR SWIA201230207Light · inoperativeNR 4 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 2901) RELAMPED EMERGENCY LIGHT.SDR SWIA201230168Light · inoperativeNR 4 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 2954) RELAMPED EMERGENCY LIGHT.SDR SWIA201230167Light · inoperativeNR 1 OVERHEAD EMERGENCY LIGHT IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201230017Window · crackedCAPTAIN SIDE WINDOW SHATTERED. (FLT 2971) REPLACED CAPTAIN SIDE WINDOW. P/N OFF: NP-13922-001 S/N OFF: 03031H5549SDR SWIA201128741Light · inoperativeAFT 3RD CEILING EMERGENCY LIGHT INOPERATIVE. (FLT 3474) RELAMPED EMERGENCY LIGHT.SDR SWIA201128555Light · inoperativeOVERHEAD EMERGENCY LIGHT AT ROW 5 IS OUT. (FLT 3490) RELAMPED EMERGENCY LIGHT.SDR SWIA201128472Torque Link · disconnectedNOSE GEAR WOULD NOT RETRACT. (FLT 3471) FOUND NOSE GEAR TORQUE LINKS DISCONNECTED AND NOSE TIRES DAMAGED, INSPECTED NOSE GEAR FOR DAMAGE REF AMM 32-21-00 WITH NO DAMAGE NOTED, REPLACED BOTH NOSE TIRES. / PN: 5010598 SN OFF: OCT00-3032 / PN: 5010598 SN OFF:SDR SWIA201128254Light · inoperativeNR 3 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4775) RELAMPED EMERGENCY LIGHT.SDR SWIA201128160Light · inoperativeOVERHEAD EMERGENCY LIGHT ABOVE ROW 5 IS OUT. (FLT 4619) RELAMPED EMERGENCY LIGHT.SDR SWIA201127139Light · inoperativeAFT OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4559) RELAMPED EMERGENCY LIGHT.SDR SWIA201126600Light · inoperativeRIGHT FORWARD EXTERIOR EMERGENCY LIGHT IS OUT. (FLT 6340) RELAMPED EMERGENCY LIGHT.SDR SWIA201126525Light · inoperativeNR 3 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6469) RELAMPED EMERGENCY LIGHT.SDR SWIA201126229Light · inoperativeRIGHT EXTERIOR AFT EMERGENCY LIGHT IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201126159Bulkhead · crackedFS 621 PRESSURE BULKHEAD CRACKED AT WEB ABOVE CARGO DOOR TRACK. (C-CHECK) REPAIRED PER REO.SDR SWIA201126129Bulkhead · cracked(C-CHECK) FS 599 PRESSURE BULKHEAD CRACKED AT LEFT AND RIGHT SIDES. REPAIRED PER REO.SDR SWIA201126501Bulkhead · crackedCRACK ON FS 621 BULKHEAD WEB AT LBL 27.50 AT TOP OF CARGO DOOR TRACK. (C-CHECK) REPAIRED PER REO.SDR SWIA201126500Floor Support · crackedFS 280.0 UPPER FLOOR SUPPORT CRACKED. (C-CHECK) REPAIRED PER REO.SDR SWIA201125683Light · inoperativeRIGHT SIDE OVERWING FORWARD EXTERIOR AND GALLEY EMERGENCY LIGHTS ARE OUT. (FLT 3045) RELAMPED EMERGENCY LIGHT.SDR SWIA201125682Light · inoperativeRIGHT FUSELAGE FORWARD EMERGENCY LIGHT IS OUT. (FLT 3044) RELAMPED EMERGENCY LIGHT.SDR SWIA201024873Wire · unsecureLOWER RIGHT EMERGENCY EXIT SIGN BACKLIGHT IS INOPERATIVE. (FLT 3072) RE-SECURED EXIT SIGN WIRING.SDR SWIA201024396Light · inoperativeNR 1 OVERHEAD EMERGENCY LIGHT INOP. (FLT 3099) RELAMPED EMERGENCY LIGHT.SDR SWIA201024259Proximity Sensor · out of adjustNOSE LANDING GEAR DID NOT RETRACT ON COMMAND. (FLT 1052) REPOSITIONED CENTERED/EXTENDED PROXIMITY SENSOR TARGET TO PROPER CLEARANCE.SDR SWIA201024083Light · inoperativeROW TWO CEILING EMERGENCY LIGHT INOP. (FLT 3060) RELAMPED EMERGENCY LIGHT.SDR SWIA201023995Light · inoperativeNR 3 OVERHEAD EMERGENCY FLOODLIGHT INOP. (FLT 3060) RELAMPED EMERGENCY LIGHT.SDR SWIA201023834Light · inoperativeAFT EMERGENCY OVERHEAD LIGHT INOP. (FLT 3116) RELAMPED EMERGENCY LIGHT.SDR SWIA200922857Light · inoperativeAFT CEILING LEVEL EMERGENCY FLOODLIGHT NR 4 INOP. (FLT 2528) RELAMPED EMERGENCY LIGHT.SDR SWIA200922559Light · inoperativeAFT CABIN CEILING LEVEL EMERGENCY LIGHT INOP. (FLT 2506) RELAMPED EMERGENCY LIGHT.SDR SWIA200922359Light · inoperativeAFT CEILING EMERGENCY LIGHT INOP. (FLT 2556) RELAMPED EMERGENCY LIGHT.SDR SWIA200921975Light · inoperativeCEILING LEVEL EMERGENCY LIGHT INOP. (FLT 2740)RELAMPED.SDR SWIA200921872Light · inoperativeNR 3 CEILING EMERGENCY LIGHT INOP. (FLT 2727) RELAMPED EMERGENCY LIGHT.SDR SWIA200921761Actuator · failedGEAR DISAGREE WARNING MESSAGE DISPLAYED. (FLT 2643) REPLACED LT MLG SIDE STAY ACTUATOR.SDR SWIA200921582Lamp · burned outFLT 2564 - AFT CABIN EMERGENCY LIGHT INOP. RELAMPED.SDR SWIA200922044Drag Angle · crackedPASSENGER DOOR AFT DRAG ANGLE CRACKED. (C CHECK) REPAIRED PER SRM.SDR SWIA200922041Support Beam · crackedFS 280 SUPPORT BEAM CRACKED. (C CHECK) REPAIRED PER REO.SDR SWIA200922039Attach Fitting · crackedCLIPS CRACKED IN AREA OF FS 280. REPAIRED PER REO.
Back to N496CA