N919CA
Service difficulty reports · 195
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 = 'N919CA' 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 = 'N919CA' 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 U2RA201408120001Support · corrodedBODY FAIRING PANEL SUPPORT AT BS 880 BL 18 LT FOUND CORROSION AT EXISTING REPAIR. INSPECTION CARRIED OUT IAW MPD TASK 53-804-01.SDR U2RA201408290009Skin · crackedLEADING EDGE SKIN OTBD OF OTBD LANDING LIGHT LENS ON RT WING AT ILES 330 FOUND 1.25 INCH CRACK. REPLACED CRACKED WEB IAW SRM 51-40-02.SDR U2RA201408290003Panel · puncturedMAIN DECK BALL MAT PANEL AT STATION 1860 - 1920 RT OF BL FOUND PUNCTURED. REPAIR CARRIED OUT IAW EO 5330ERO1879.SDR U2RA201408290001Panel · dentedMAIN DECK BAL MAT PANEL AT STATION 1780 - 1840 LT OF BL 75 - 98 FOUND DENTED. REPAIRED DAMAGE IAW EO 5330ERO1879.SDR U2RA201408290008Beam · crackedRIGHT LE TO FRONT SPAR CAVITY NOSE BEAM LOWER CHORD AT ILES 697 FOUND 1.5 INCH CRACK. REPAIRED IAW DWG 5730D1877.SDR U2RA201408290005Oil System · leakingOIL ODOR IN CABIN & COCKPIT. REMOVED OIL CONTAMINATION FROM AIR CONDITIONING SYS & PNEUMATIC SYS. CAUSE OF PROBLEM FOUND TO BE INTERNAL OIL LEAK FROM APU. R & R APU.SDR U2RA201408290010Structure · mechanic errorWHILE ACCOMPLISHING AD 98-07-15 SB 747-53A2396 FOUND SHORT EDGE MARGIN & SHORT PITCH CONDITIONS ON LT & RT SIDES. ACCOMPLISHED DOUBLER INSTALLATION IAW SB 747-53A2396.SDR U2RA201408290004Cowling · damagedNUMBER 2 ENG LT COWL AFT CORNER FOUND FASTENER HOLES ELONGATED. REPAIRED COWL IAW EO 5430ERO1878.SDR U2RA201408290002Panel · dentedMAIN DECK BAL MAT AT STATION 1860-1920 LEFT OF BUTTLINE 79-98 DENTED ON EDGE OF PANEL NEAR BALL TRANFER UNITS. REPAIR CARRIED OUT PER ASI SOLUTIONS ENGINEERING ORDER 5330ERO1879 APPROVED BY 8110-3 NO. 232-884-14-1879.SDR U2RA201407060001Panel · departedUPON LANDING INTO OAIX, THE TOWER NOTIFIED THE FLIGHT CREW THAT A PIECE OF WING WAS FOUND ON THE RUNWAY. POST FLIGHT INSPECTION REVEALED RT WING UPPER PANEL PN 65B11629-30 WAS MISSING.SDR U2RA201406100001Relay · defectivePRIOR TO DESCENT MAIN DECK FIRE WARNING EICAS MSG DISPLAYED. SYS WAS CURRENTLY DEFERRED. FIRE WARNING DISAPPEARED AT 10000' FOOT ON DESCENT. AFTER FLIGHT FOUND FAULTY RELAY R 5187. REPLACED RELAY SYS, CHECKED GOOD.SDR U2RA201401230001Door · inoperativeRIGHT UPPER DECK ESCAPE DOOR INOPERATIVE ELECTRICALLY.SDR U2RA201401080001Battery Pack · dischargedFOUND EMERGENCY EXIT BATTERY PACKS WITH NO VOLTAGE. REPLACED BATTERY PACKS EMERGENCY EXIT LIGHTS TEST GOOD.SDR U2RA201310250001Power Supply · dischargedON DAILY SERVICE CHECK, FOUND RT UPPER DECK DOOR EMERGENCY OPENING SYS FAILS TEST USING 6 VOLT BATTERY TEST, TASK 52-023-00-01.SDR U2RA201308130001Fire Warning · false activationMAIN DECK FORWARD FIRE WARNING ACTIVATED DURING FLIGHT. ON ABOUT 5 SECONDS THEN EXTINGUISHED.SDR U2RA201211200001Battery Pack · no testRT UPPER DECK DOOR EMERGENCY BATTERY DOES NOT TEST.SDR U2RA201206260001Access Panel · crackedRIGHT WING FUEL PANEL FORWARD FIXED PANEL FOUND CRACKED. CRACK LENGTH 1".SDR U2RA201206260006Splice Plate · crackedNLG WHEEL WELL BS 400 RT AFT CORNER SKIN SPLICE PLATE HAS 5 CRACKS. CRACK LENGTH .030". REF AD 2010-26-07, S/B 747-53A2305.SDR U2RA201206190001Drip Tray · crackedMAIN ELECTRICAL CENTER LT OTBD DRIP SHEILD CRACKED, LOCATED AT BS 460. REF AD 2011-16-06, SB 747-25A3588. CRACK LENGTH 2".SDR U2RA201206260004Bulkhead · crackedNLG WHEEL WELL BS 400 LT AFT CORNER SKIN CHORD FOUND CRACKED. CRACK LENGTH .3". REF AD 2012-26-07, S/B 747-53A2305.SDR U2RA201206260005Splice Plate · crackedNLG WHEEL WELL BS 400 LT AFT CORNER SKIN SPLICE PLATE FOUND CRACKED. 2 EACH CRACKS, CRACK LENGTH .3", REF AD 2012-26-07, S/B 747-53A2305.SDR U2RA201206260003Cargo Track · brokenAFT CARGO COMPARTMENT AT BS 1910 LT AND RT RETRACTABLE GUIDE RAIL, TWO HOOK PLATES FOUND BROKEN.SDR U2RA20120626Attach Angle · crackedRIGHT WING FUEL PANEL LATCH ANGLE FOUND CRACKED. CRACK LENGTH .5"SDR U2RA201206260002Bracket · crackedRIGHT WING LANDING GEAR STRUT DOOR LOWWER SECTION FIXED FAIRING MID BRACKET FOUND CRACKED. CRACK LENGTH 1".SDR U2RA201206160005Grommet · brokenCOCKPIT EMERGENCY DECENT DEVICE BLUE GROMMET FOUND BROKEN.SDR U2RA201206160004Reservoir · pressure lossUPPERDECK RT EMERGENCY EXIT DOOR POWER OPENING RESERVIOR PRESSURE LOW.SDR U2RA201206160003Life Raft · pressure lossUPPERDECK LIFE RAFT AT BS 660 LT SIDE FOUND PRESSURE BELOW LIMITS.SDR U2RA201206200004Support Angle · crackedRT WING NR 7, MOVEABLE FLAP FAIRING OTBD FORWARD ANGLE FOUND CRACKED IN 2 PLACES.SDR U2RA201206200003Bracket · crackedRT WING T/E CAVITY AT WING BS 280 BRACKET FOUND CRACKED, CRACK LENGTH .5".SDR U2RA201206200001Retainer · crackedLEFT WING STRUT DOOR LOWER SECTION FIXED FAIRING RETAINER FOUND CRACKED. CRACK LENGTH 1".SDR U2RA201206270001Web · crackedFORWARD CARGO BS 570, RBL 45-50 WEB FOUND CRACKED. CRACK LENGTH .5".SDR U2RA201206210001Beam · crackedNR 2 PYLON OTBD SKIRT FAIRING BEAM L/E CRACKED. 4 CRACKS EXTEND FROM FASTENER HOLE. CRACK LENGTHS .8"SDR U2RA2010206200002Guide · crackedFORWARD LOWER CARGO COMPARTMENT STA 580-600 LT SIDE GUIDE FOUND CRACKED. CRACK LENGTH 1".SDR U2RA201206190005Plate · crackedENGINE FUEL NOZZLE SPLASH PLATE FOUND RADIAL CRACK, CRACK LENGTH .516".SDR U2RA201206190004Roller Tray · crackedAFT LOWER CARGO COMPARTMENT AT STA 1580, RT OF BUTT LINE 58 ROLLER TRAY FOUND CRACKED, CRACK LENGTH 1".SDR U2RA201206190003Seal Depressor · crackedFORWARD LOWER CARGO DOOR SEAL DEPRESSOR FOUND CRACKED. CRACK LENGTH 2".SDR U2RA201206190002Cargo Track · crackedFORWARD CARGO COMPARTMENT STA 570 RT OF BUTT LINE 50" CARGO TRACK FOUND CRACKED. CRACK LENGTH IS 2".SDR U2RA201206150004Tension Tie · crackedUPPERDECK BS 1180 RT SIDE TENSION TIE FORWARD CHANNEL CRACKED. CRACK LENGHT .035".SDR U2RA201206150002Skin · crackedNLG WHEEL WELL BS 400 LT AFT CORNER SKIN PANEL FOUND CRACKED. REF AD 2010-26-07, SB 747-53A2305. CRACK LENGTH 2.5" LONG FASTENER HOLE CRACK .030"SDR U2RA201206160002Pressure Panel · crackedLT LANDING GEAR WHEEL WELL CANTED PRESSURE DECK CLOSEOUT PANEL FOUND CRACKED. REF AD 2003-01 SB 747-51A2057. CRACK LENGTH 1".SDR U2RA201206160001Tension Tie · crackedUPPERDECK STA 1180, RT TENSION TIE AT FRAME WEB FOUND 1 EA HOLE CRACKED. REF AD 2007-23-18 SB 747-53A2507. CRACK HOLE CRACK LENGTH .035"SDR U2RA201206150005Tension Tie · crackedUPPERDECK BS 1140 TENSION TIE AT FRAME WEB FOUND 1 EACH HOLE CRACK AND 2ND HOLE CRACK AT FAILSAFE.SDR U2RA201206150003Tension Tie · crackedUPPERDECK BS 1180 LT TENSION TIE FORWARD CHANNEL FOUND 1 EA CRACK. REF AD 2007-23-18, SB 747-53A2507. CRACK LENGTH .035"SDR U2RA201206150001Structure · crackedBS 2598, FOUND CRACKED.SDR U2RA20120126Battery · dischargedRT UPPER DECK EMERGENCY SLIDE-BATTERY TEST INOPERATIVE. (FOUND DURING ROUTINE COMPANY 24/48 HOUR SERVICE CHECK.)
Back to N919CA