N78005
Service difficulty reports · 75
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 = 'N78005' 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 = 'N78005' 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 CALA2015042800332Battery Pack · dischargedRIGHT DOOR 4 EMER LIGHT DIM. M33097 BATTERY CHARGER REPLACED & LAMP TESTED NORMAL IAW AMM 33-51-06 & AMM 33-51-00.SDR CALA2015042800331Battery Pack · dischargedRIGHT DOOR 2 EMER LIGHT DIM. M33408 BATTERY PACK REPLACED & LAMP TESTED NORMAL IAW AMM 33-51-06 & AMM 33-51-00.SDR CALA2015012300066Switch · failedL4 DOOR EPAS BATTERY, OPERATIONS CHECK FAILED IAW WC 25-5210-1-9801 STEP1 D & E. OPERATIONAL BATTERY PACK, NO HELP. SEE ATTACHED 44.0008. REPLACED L4 DOOR MODE SELECT SWITCH & DOOR OPEN SWITCH. ALL CHECKED GOOD IAW AMM 52-11-28.SDR CALA2014051600603Control Unit · failedEQUIPMENT COOLING OVERRIDE LIGHT ILLUMINATED IN FLIGHT. RAN CHECKLIST RECYCLED SWITCH & EQUIP COOLING OVERRIDE REMAIN ILLUMINATED. MX MSG 21-15111 ELCU EQUIP CLG VENT FAN NOT IN COMMAND. PERFORMED FIM TASK 21-27-00-810 REPLACED ELCU. OPERATIONS CHECKED GOOSDR CALA2013041600222Battery · failedCABIN L3 DOOR EMER LIGHT BATTERY M33400 FAILED CAPACITY CHECK. BATTERY REPLACED AND OPS CHECKED NORMAL IAW AMM 33-51-06.SDR CALA2013041700228Battery · failedCABIN L4 DOOR EMERGENCY LIGHT BATTERY M33407 FAILED CAPACITY CHECK. BATTERY REPLACED AND OPS CHECKED NORMAL IAW AMM 33-51-06.SDR CALA2013041700227Battery · failedCABIN L1 DOOR EMERGENCY LIGHT BATTERY M33093 FAILED CAPACITY CHECK. BATTERY REPLACED AND OPS CHECKED NORMAL IAW AMM 33-51-06.SDR CALA2013041700226Battery · failedCABIN R2 DOOR EMERGENCY LIGHT BATTERY M33098 FAILED CAPACITY CHECK. BATTERY REPLACED AND OPS CHECKED NORMAL IAW AMM 33-51-06.SDR CALA2013041700225Battery · failedCABIN R4 DOOR EMERGENCY LIGHT BATTERY M33409, CAPACITY CHECK FAILED. BATTERY REPLACED AND OPS CHECKED NORMAL IAW AMM 33-51-06.SDR CALA2013041700224Battery · failedCABIN L2 DOOR EMERGENCY LIGHT BATTERY M33099, CAPACITY CHECK FAILED. BATTERY REPLACED. OPS CHECKED NORMAL IAW AMM 33-51-06.SDR CALA2011112900773Clutch · damagedSPEED BRAKE LEVER STUCK FULL DOWN FOUND BEARING ON AUTO SPEEDBRAKE CLUTCH MIGRATING OUT. REPLACED AUTO SPEEDBRAKE CLUTCH IAW AMM 27-62-02. ALSO FOUND LATCHED MSG 27-17001. PERFORMED FIM TASK 27-62-00-810-806. OPS TEST PASSED MSG CLEARED ROTABLE PARTS CHANGSDR CALA2011100400639Indicator · leakingHYD QTY C LOW HYD C PRESS 3060, QTY 0.40 LO. REVIEW ADVISORY CHECKLIST. PERFORMED THE MX TASK ADP & ACMP CASE DRAIN FILTER INSPECTION & FOUND NO EVIDENCE OF PUMP DAMAGE. WHILE PERFORMING THIS TASK FOUND THE CTR HYD PUMP 1 PRESS AND CASE DRAIN FILTER MODULE SDR CALA2011012100034Light · inoperativeMULT-33-3-0001 RT 1 DOOR SLIDE EMER LIGHTT FOUND INOP. RT 1 DOOR SLIDE EMERGENCY LIGHT REPLACED AND OP CHECK FOUND NORMAL AMM 35-51-0.SDR CALA2011012100033Light · inoperativeMULT-33-3-0001 LEFT 1DOOR EMERGENCY LIGHT INOP. LEFT 1 DOOR SLIDE EMERGENCY LIGHT REPLACED AND OP CHECK FOUND NORMAL AMM 33-51-04.SDR CALA2009030900130Fan · seizedEN ROUTE STRONG ELECTRICAL SMELL IN CABIN ROW 32-37 (STRONGEST ROW 35). DIVERT TO CLE AFTER CO-ORDINATION WITH MX CONTROL AND DISPATCH. EICAS MESSAGE CAME UP AFTER DIVERTING: BULK CARGO FAN. INSPECTED A/C PER MM 05-51-58 FOUND BULK CARGO VENTILATION FAN WISDR CALA0700029Seat Track · corrodedINSPECTION FOUND SEAT TRACK CORRODED AT STA 1546, LBL 74. THE SEAT TRACK WAS REPAIRED AND FASTENER INSTALLED IAW SRM 53-00-52, REPAIR 3.SDR CALA0700028Seat Track · corrodedINSPECTION FOUND SEAT TRACK FLANGE CORRODED AT STA 415-422, RBL 68. THE SEAT TRACK WAS REPLACED IAW SRM 51-10-02 AND SRM 51-40-02.SDR CALA0700026Seat Track · corrodedINSPECTION FOUND SEAT TRACK FLANGE CORRODED AT STA 1520-1546, RBL 74. THE SEAT TRACK WAS REPLACED IAW SRM 53-00-52, REPAIR 3.SDR CALA0700025Seat Track · corrodedINSPECTION FOUND SEAT TRACK CORRODED AT STA 1525-1546, LBL 108. THE SEAT TRACK WAS REPAIRED AND FASTENERS WERE INSTALLED IAW SRM 53-00-52, REPAIR 4.SDR CALA0400682Line · cloggedNR 2 ENG INDICATED A RAPID LOSS OF OIL, FOLLOWED BY LOW OIL PRESSURE IND. CREW SHUTDOWN NR 2 ENG & DIVERTED FLT, LANDED WITHOUT INCIDENT. TROUBLESHOOTING FOUND NR 2 ENG C-SUMP LINE CLOGGED WITH COKE AT 9 O'CLOCK STRUT UNDER AFT CENTER BODY. LINE CLEARED. ENGINSDR CALA0300508Fan · inoperativeTHE (SMOKE CREW CABIN REST AREA), MASTER WARNING, AND SMOKE ALARMS CAME ON WHILE CLIMBING FROM FL 360 TO 380 WHILE ENROUTE TO EWR. THE WARNINGS WERE ACCOMPANIED BY AN ELECTRICAL ODOR AND EICAS STATUS MESSAGE (RECIRC FAN) CAME ON APPROXIMATELY 2 MINUTES AFTER TSDR CALA0300016Skin · deformedINSPECTION FOUND AFT CARGO DOOR AFT LOWER CORNER SKIN DEFORMED WITH A CRACK IN SKIN AT RIVET HOLE. THE DOOR SKIN WAS REPAIRED IAW SRM 52-30-01, REPAIR 17.SDR CALA0300015Seat Track · corrodedINSPECTION FOUND SEAT TRACK CORRODED AT BS 1495-1525, RBL 75. THE SEAT TRACK WAS REPAIRED IAW SRM 53-00-52, REPAIR 3.SDR CALA0200525Fire Warning · false activationAFT CARGO FIRE LIGHT AND WARNING CAME ON 1:15 INTO FLIGHT. CHECKED DETECTORS AND HEATERS AND NO TROUBLE FOUNDSDR CALA0200524Fire Warning · malfunctionedAFT CARGO FIRE LIGHT CAME ON. FOUND NO EVIDENCE OF FIRE. FOUND DOOR NR 4 CHILLER CIRCUIT BREAKERS POPPED
Back to N78005