N390CA
Service difficulty reports · 287
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 = 'N390CA' 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 = 'N390CA' 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 V0XD20180901002Seat Track · corrodedLT FLOOR CENTER SEAT TRACK HAS SIGNS OF CORROSION FROM FS597-FS677. REMOVED AND REPLACED LT FLOOR CENTER SEAT TRACK IAW AMM 53-00-49.SDR V0XD20180901001Seat Track · corrodedRT FLOOR CENTER SEAT TRACK HAS SIGNS OF CORROSION FROM FS597-FS677. CORRECTIVE ACTION: REMOVED AND REPLACED RT FLOOR CENTER SEAT TRACK IAW AMM 53-00-49.SDR V0XD2018083101Bracket · crackedLT UPPER TR SLIDER INBD AND OUTBD "A" BRACKET CRACKED. CORRECTIVE ACTION: REMOVED AND REPLACED LT UPPER TR SLIDER INBD AND OUTBD "A" BRACKETS IAW SRM 51-42-22 AND 51-42-13.SDR V0XD20180905003Web · crackedFWD EQUIP BAY FLOOR WEB IS CRACKED AT FS 193.00. REPAIRED FWD EQUIP BAY FLOOR WEB AT FS 193.00 BY REMOVING DAMAGE FABRICATING AND INSTALLING REPAIR PARTS IAW REO 670-53-11-509, REV D DATED 2016-06-29.SDR N6WA2018071110001Mechanism · lack of lubeINTERIOR PAX DOOR HANDLE STICKS, LUBED DOOR MECHANISM OF PAX DOOR. OPS TESTED IAW AMM 52-11-00 OPS TEST GOOD AT THIS TIME.SDR N6WA2017052401Light · inoperativeEMERGENCY LIGHT IS OUT, CEILING LAST ONE IN REAR.SDR N6WA2016111801Door · bindingPAX DOOR HARD TO CLOSE.SDR N6WA2016111001Light · inoperativeAFT EMERGENCY LIGHT INOPERATIVE.SDR N6WA2016092201Warning System · activatedPASSENGER DOOR OUTER HANDLE CAUTION.SDR V0XD20160830152Stringer · corrodedSTRINGER 26R HAD SIGNS OF CORROSION BETWEEN BS 280 AND 333 IN TWO PLACES. REMOVED AND REPLACED THE STRINGER IAW SRM 53-21-03.SDR V0XD20160823151Structure · corrodedPASSENGER DOOR MID CAP CORRODED OUT OF LIMITS. REMOVED AND REPLACED PASSENGER DOOR MID CAP IAW SRM 51-35-00.SDR V0XD20160831153Seal · tornRIGHT OVERWING EXIT PRESSURE SEAL TORN. REPLACED THE OVERWING DOOR SEAL IAW AMM 52-21-07.SDR N6WA2016061602Warning System · false activationPASSANGER DOOR LATCH CAUTION MSG. DEFERRED PAX DOOR MSG ON OCN 70005291 IAW MEL 52-70-01, CAT A.SDR N6WA2016061616Cover · misinstalledLEFT OVERWING EMERGENCY LIGHT COVER INSTALLED UPSIDE DOWN. REMOVED AND REINSTALLED LIGHT EXIT SIGN IAW AMM 33-15-15, OPS CHECK GOOD.SDR N6WA2016050601Battery Pack · dischargedEMERGENCY LIGHT PACK DISCHARGED. PERFORMED OPERATIONS CHECK ON THE EMER LIGHT BATTERY PACKS IAW AMM 33-51-17. ACFT OK FOR SERVICE.SDR N6WA2016042603Light · inoperativeOVERHEAD CTR AISLE EMER LIGHT AT EXIT, ROW DOESN'T FLASH WHEN SELECTED. RELAMPED CTR AISLE EMER LIGHT AT EXIT ROW IAW AMM 33-51-09.SDR 2016FA0000190Floorbeam · corrodedCORROSION FOUND ON FLOORBEAM LBL 9.0 AT FS 1031, REPAIRED IAW REO 670-53-00-029, REV A DATED 2010-08-31.SDR N6WA2016F00102Floor Support · corrodedCORROSION FOUND ON SIDE FLOOR SUPPORT AT FS 1051 TO FS 1069 AT RBL 42.SDR N6WA2016F00101Floor Support · corrodedCORROSION FOUND ON SIDE FLOOR SUPPORT AT BS 985 TO 1000 AT RBL 42.SDR V0XR2016041800100Floor Support · corrodedCORROSION FOUND ON SIDE BEAM AT BS 100 TO 1015 AT RBL 42.SDR 2016F00116Floor Support · corrodedCORROSION FOUND ON SIDE FLOOR SUPPORT AT BS 1015 TO 1031 AT RBL 42.SDR 2016F00114Floor Support · corrodedCORROSION FOUND ON SIDE BEAM AT BS 1031 TO 1051 AT RBL 42.SDR DALA2016041800107Floor Support · corrodedCORROSION FOUND ON FLOOR SUPPORT LBL 27.0 AT BS 1015 - 1031.SDR N6WA2016022901Cover · unsecureEXIT COVERS ON BOTH EMER EXIT DOORS NOT SECURE. R & R VELCRO ON BOTH EXIT ROW DOOR COVERS IAW AMM 20-60-04 & INSTALLED EXIT COVERS.SDR N6WA2015110801Proximity Switch · dirtyPASSENGER DOOR OUTER HANDLE CAUTION MSG. INSPECTED & CLEANED PAX DOOR PROXIMITY SWITCH PX 107 IAW AMM 52-70-04 & 52-70-00. OPERATIONS CHECKED GOOD AT THIS TIME.SDR N6WA2015080401Placard · missingGREEN LOCK INDICATOR PLACARD ON SERVICE DOOR MISSING. DEFERRED PLACARD IAW NEF 25-500-1.SDR N6WA2015052003Cover · looseRIGHT EMER EXIT HANDLE COVER LOOSE. SECURED RT EMER LATCH HANDLE COVER AS REQUIRED.SDR N6WA2015040201Connector · looseRIGHT BLEED DUCT WARNING. FOUND LOOSE CONNECTOR, RETORQUED & SAFTIED CONNECTOR MT145 IAW AMM 20-51-00. OPERATIONS CHECKED GOOD. OK FOR SERVICE.SDR N6WA2015030603Light · inoperativeEMERGENCY CEILING FLOODLIGHT BETWEEN ROW 14 & 15 INOPERATIVE. DEFERRED EMER FLOODLIGHT IAW MEL 33-51-01B CAT C.SDR N6WA2015020101Wire · burnedPASSENGER DOOR WARNING ON LANDING. FOUND DAMAGED & BURNT WIRING. REPAIRED WIRING IAW ESPM 20-33-00. R & R PX107 & PX101 IAW AMM 52-70-04. OPERATIONS CHECKED GOOD.SDR N6WA2015013101Warning System · false activationAFT CARGO DOOR CAUTION MSG. PERFORMED OPERATIONS CHECK OF AFT CARGO DOOR. OPERATIONS CHECKED GOOD. NO DEFECTS NOTED IAW AMM 52-31-00. INDICATION OPERATIONS CHECKED GOOD IAW FIM 52-70-02.SDR N6WA2015012301Hook And Loop · unsecureHANDLE COVER VELCRO CAME OFF ON EMER EXIT DOOR LT SIDE. SECURED VELCRO ON LT EMER EXIT HANDLE COVER IAW AMM 51-22-61.SDR N6WA2015010205Light · inoperativeCEILING EMER FLOODLIGHT AT ROW 6 INOPERATIVE. DEFERRED IAW MEL 33-51-01B CAT C.SDR N6WA2014111802Warning System · false activationSMOKE AFT CABIN LAVATORY WARNING MSG, NO VISIBLE SMOKE. INSPECTED AFT LAVATORY & SURROUNDING AREAS. INSPECTED LIGHT BALLASTS, PERFORMED OPERATIONS CHECKS OF ALL LAVATORY LIGHTS, LAVATORY FLUSH & LAVATORY SMOKE DETECTOR WITH NO DEFECTS OR SMOKE NOTED. NO MSGSDR N6WA2014100603Motor · out of adjustMAIN CABIN DOOR LOWER QUICKER THAN NORMAL. ADJUSTED PAX DOOR ASSIST MOTOR IAW AMM 52-11-08. OPERATIONS CHECKED GOOD AT THIS TIME.SDR N6WA2014100403Striker · dentedCO 4435 MAIN CABIN DOOR SQUEALS IN FLIGHT. UPON INSPECTION, FOUND DENT IN SEAL STRIKER. PERFORMED TEMP REPAIR IAW REO 670-53-22-001 REV H. PERFORMED PRESSURIZATION CHECK IAW AMM 21-31-00, NO DEFECTS NOTED. PLACED TEMP REPAIR ON CO 4435 IAW EO 53-22-001.SDR N6WA2014092902Door Seal · defectivePAX DOOR SQUEAL. R & R PAX DOOR SEAL IAW AMM 52-11-07. PERFORMED OPERATIONS CHECK IAW AMM 21-31-00. OPERATIONS CHECKED GOOD. AIRCRAFT OK FOR SERVICE.SDR V0XD20140928196Intercostal · corrodedINTERCOSTAL 26L AT AVIONICS DOOR CORRODED. REMOVED INTERCOSTAL, REMOVED CORROSION & REPLACED INTERCOSTAL IAW SRM 53-21-23, 51-42-06, 51-21-11, 51-25-16 & 51-42-21.SDR V0XD20140928001Intercostal · corrodedINTERCOSTAL 26L AT AVIONICS DOOR CORRODED. REMOVED, BLENDED & REPLACED 26L INTERCOSTAL IAW SRM 53-21-23, 51-42-06, 51-21-11, 51-25-06, 51-21-11, 51-25-16 & 51-42-21.SDR V0XD20140928195Intercostal · corrodedLEFT SIDE INTERCOSTAL AT STRINGER 27, FS 364 CORRODED. R & R LT SIDE INTERCOSTAL AT STRINGER 27 FS 364 IAW SRM 51-42-06, 51-42-21, 51-40-11 & 51-25-21.SDR V0XD20140928194Stringer · corrodedSTRINGER 26L HAS A SPOT OF CORROSION. R & R STRINGER 26L IAW REO 670-53-21-1128.SDR V0XD20140926193Floorbeam · crackedFS 280 FLOORBEAM CRACKED & CORRODED. REMOVED & INSTALLED FLOORBEAM IAW WITH SRM 53-11-41. SEE WORK ORDER 80247 WC 1045.SDR V0XD20140925192Door Sill · corrodedRIGHT SILL AT FS 280 - 319 CORRODED. R & R RT SILL AT FS 280 - 319 IAW SRM 51-42-06 & 51-21-11. SEE WORK ORDER 80247 WC 1043.SDR V0XD20140925191Channel · corrodedT CAS CHANNEL CORRODED. R & R T CAS ANTENNA DOUBLER IAW SRM 51-40-11, 51-40-11 & 51-42-06. SEE WORK ORDER 80247 WC 1054.SDR V0XD20140925190Angle · corrodedCRAWLWAY ANGLE AT FS 280 IN MAIN AVIONICS BAY CORRODED. R & R CRAWLWAY ANGLE IAW SRM 51-42-13, 51-42-06, 51-21-11, 51-42-21. SEE WORK ORDER 80247, WC 1053.SDR V0XD20140925189Floorbeam · corrodedFLOOR SUPPORT AT FS 280 LBL12 - RBL12 CORRODED. REMOVED CORRODED FLOOR SUPPORT & REPLACED WITH NEW SUPPORT ANGLE IAW SRM 51-42-21, 54-42-06. SEE WORK ORDER 80247, WC 1044.SDR V0XD20140924188Stringer · crackedLINTEL STRINGER AT FS 280 AT STRINGER 3L CRACKED. REPAIRED LINTEL STRINGER IAW SB 670BA-53-040, REO 670-53-21-493 DATED 2011-12-08 REC C. SEE WORK ORDER 80247 WC 2090.SDR V0XD20140924187Bulkhead · corrodedFS 280 RT & LT BULKHEAD WEBS CORRODED. REMOVED CORRODED LT & RT BULKHEAD WEBS & REPLACED WITH NEW WEBS IAW REO 670-53-11-594 DATED 2011/04/27 REV. SEE WORK ORDER 80247 WC 1068.SDR V0XD20140919186Rivet · damagedRIVET ON PAX DOOR LOWER AFT, AS VIEWED WITH DOOR OPEN, DAMAGED. R & R TWO RIVETS ON PAX DOOR LOWER AFT IAW SRM 51-42-13. WORK ORDER 80247 WC 2089.SDR N6WA20140628003Sign · unsecureSERVICE DOOR EMER EXIT SIGN UNSECURED. R & R SIGN HOUSING ASSEMBLY IAW AMM 33-51-07.
Back to N390CA